Table.FromList

Syntax

Table.FromList(list as list, optional splitter as nullable function, optional columns as any, optional default as any, optional extraValues as nullable number) as table 

About

Converts a list, list into a table by applying the optional splitting function, splitter, to each item in the list. By default, the list is assumed to be a list of text values that is split by commas. Optional columns may be the number of columns, a list of columns or a TableType. Optional default and extraValues may also be specified.

Example 1

Create a table from the list with the column named "Letters" using the default splitter.

Table.FromList({"a", "b", "c", "d"}, null, {"Letters"})
Letters
a
b
c
d

Example 2

Create a table from the list using the Record.FieldValues splitter with the resulting table having "CustomerID" and "Name" as column names.

Table.FromList(
    {
        [CustomerID = 1, Name = "Bob"],
        [CustomerID = 2, Name = "Jim"]
    },
    Record.FieldValues,
    {"CustomerID", "Name"}
)
CustomerID Name
1 Bob
2 Jim