Record.FieldNames is a Power Query M function that extracts the names of the fields in a record as text. The function returns a list containing the names of all the fields in the input record.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Record.FieldNames( record as record ) as list


Returns the names of the fields in the record record as text.


Find the names of the fields in the record.

// Output: {"OrderID", "CustomerID", "Item", "Price"}
Record.FieldNames( [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0] )

Other functions related to Record.FieldNames are:

BI Gorilla Youtube Channel

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.