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

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]