Record.ReorderFields

Syntax

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

About

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