Power Query
published
Search
K
Comment on page

Record.ReorderFields

Record.ReorderFields

Reorders the field(s) specified into the new order.
function (record as record, fieldOrder as list, optional missingField as nullable any) as record

Description

Returns a record after reordering the fields in record in the order of fields specified in list fieldOrder. Field values are maintained and fields not listed in fieldOrder are left in their original position.

Category

Record.Transformations

Examples

Reorder some of the fields in the record.
Record.ReorderFields([CustomerID= 1, OrderID = 1, Item = "Fishing rod", Price = 100.0], {"OrderID", "CustomerID"})
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]