Record.FromList

Syntax

Record.FromList(list as list, fields as any) as record

About

Returns a record given a list of field values and a set of fields. The fields can be specified either by a list of text values, or a record type. An error is thrown if the fields are not unique.

Example 1

Build a record from a list of field values and a list of field names.

Record.FromList({1, "Bob", "123-4567"}, {"CustomerID", "Name", "Phone"})
CustomerID 1
Name Bob
Phone 123-4567

Example 2

Build a record from a list of field values and a record type.

Record.FromList({1, "Bob", "123-4567"}, type [CustomerID = number, Name = text, Phone = number])
CustomerID 1
Name Bob
Phone 123-4567