Skip to main content

Record.SelectFields

Returns a record that contains only the specified fields.

Syntax

Record.SelectFields(
record as record,
fields as any,
optional missingField as MissingField.Type
) as record

Remarks

Returns a record which includes only the fields specified in list fields from the input record.

Examples

Example #1

Select the fields "Item" and "Price" in the record.

Record.SelectFields(
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0],
{"Item", "Price"}
)

Result:

[Item = "Fishing rod", Price = 100]

Category

Record.Selection