Record.Field

This function retrieves the value stored in the specified field. It is designed to generate field lookup syntax dynamically for a specific record. Essentially, it is a dynamic alternative to using the record[field] syntax.

Locate the value of the "CustomerID" field in the record using Power Query M. The record contains information such as CustomerID, Name, and Phone number. The field we are interested in is labeled "CustomerID" with a value of 1. The output will display the number 1.