Record.SelectFields

The function retrieves a new data entry that includes specific fields chosen from the original data entry. The sequence of the fields remains the same as in the original data entry.

Syntax

Record.SelectFields(record as record, fields as any, optional missingField as nullable number) as record

About

The function retrieves a new data entry that includes specific fields chosen from the original data entry. The sequence of the fields remains the same as in the original data entry.

Explanation

Choose the "Item" and "Price" fields from the record using Power Query method MRecord.SelectFields([OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0], {"Item", "Price"}). The resulting output will display [Item = "Fishing rod", Price = 100].