Record.ReorderFields(record as record, fieldOrder as list, optional missingField as nullable number) as record


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.

Example 1

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