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 listDescription
Returns a list of the field values in record record.
Examples
Find the field values in the record.
// Output: {1, "Bob", "123-4567"}
Record.FieldValues( [CustomerID = 1, Name = "Bob", Phone = "123-4567"] )Related functions
Other functions related to Record.FieldValues are:
