Record.SelectFields
Syntax
Record.SelectFields(record as record, fields as any, optional missingField as nullable number) as record
About
Returns a record which includes only the fields specified in list fields
from the input record
.
Example 1
Select the fields "Item" and "Price" in the record.
Usage
Record.SelectFields(
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0],
{"Item", "Price"}
)
Output
[Item = "Fishing rod", Price = 100]