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.
Usage
Table.FromList({"a", "b", "c", "d"}, null, {"Letters"})
Output
Table.FromRecords({
[Letters = "a"],
[Letters = "b"],
[Letters = "c"],
[Letters = "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.
Usage
Table.FromList(
{
[CustomerID = 1, Name = "Bob"],
[CustomerID = 2, Name = "Jim"]
},
Record.FieldValues,
{"CustomerID", "Name"}
)
Output
Table.FromRecords({
[CustomerID = 1, Name = "Bob"],
[CustomerID = 2, Name = "Jim"]
})