Record.FieldNames
The names of a record's fields, in the record's order.
Group: Record. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Record.FieldNames(record as record) as list| Parameter | Type | Description |
|---|---|---|
record | record | The record whose field names you want. |
Returns
list. A list of texts, one per field.
Examples
A customer record's fields
Record.FieldNames([Name = "Ann", City = "Oslo", Since = 2021]){"Name", "City", "Since"}The order is the record's own, not alphabetical.
Related functions
Record.FieldValues, Record.ToTable, Record.FieldCount, Table.ColumnNames.