Record.Field Function in Power Query
The Record.Field function returns the value of the given field. If the field is not found, an error is thrown.
Syntax
Record.Field(record as record, field as text) as any
Example: Find the value of field "CustomerID" in the record.
Power Query M
Record.Field([CustomerID = 3, Name = "Alia", Phone = "543-7890"], "CustomerID")
The output will be 3.
