Record.FieldValues

Returns a collection of the values stored in the fields of the specified record.

Syntax

Record.FieldValues(record as record) as list

About

Returns a collection of the values stored in the fields of the specified record.

Explanation

Retrieve the field values from the record using Power Query function MRecord.FieldValues([CustomerID = 1, Name = "Bob", Phone = "123-4567"]). The output will be {1, "Bob", "123-4567"}.