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.
Usage
Record.ReorderFields(
[CustomerID = 1, OrderID = 1, Item = "Fishing rod", Price = 100.0],
{"OrderID", "CustomerID"}
)
Output
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]