Record.FieldValues

Updated on

Record.FieldValues is a Power Query M function that retrieves a list of the field values in a record. The function returns a list containing the values of all the fields in the input record.

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

Syntax

Record.FieldValues( record as record ) as list

Description

Record.FieldValues returns a collection of the values stored in a record, presented as a list. This function is useful for extracting all the data contained in a record without its field names.

Examples

Find the field values in the record.

// Output: {1, "Bob", "123-4567"}
Record.FieldValues( [CustomerID = 1, Name = "Bob", Phone = "123-4567"] )

Other functions related to Record.FieldValues are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/record-fieldvalues