Record.Field

Updated on

Record.Field is a Power Query M function that retrieves the value of the specified field in a record. The function returns the value of the field or throws an exception if the field is not found.

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

Syntax

Record.Field(
   record as record,
   field as text,
) as any

Description

Record.Field retrieves the value associated with a specific field within a record. Should the specified field not exist within the record, the function will throw an error.

Examples

Find the value of field “CustomerID” in the record.

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

Other functions related to Record.Field are:

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