Table.FromList

Table.FromList
Converts a list into a table by applying the specified splitting function to each item in the list.
function (list as list, optional splitter as nullable function, optional columns as nullable any, optional default as nullable any, optional extraValues as nullable any) as table
Description
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.
Category
Table.Table construction
Examples
Create a table from the list with the column named "Letters" using the default splitter.
1
Table.FromList({"a", "b", "c", "d"}, null, {"Letters"})
Copied!
Table.FromRecords({ [ Letters = "a" ], [ Letters = "b" ], [ Letters = "c" ], [ Letters = "d" ] }, { "Letters" })
Create a table from the list using the Record.FieldValues splitter with the resulting table having "CustomerID" and "Name" as column names.
1
Table.FromList({[CustomerID=1,Name="Bob"],[CustomerID=2,Name="Jim"]} , Record.FieldValues, {"CustomerID", "Name"})
Copied!
Table.FromRecords({[CustomerID=1,Name="Bob"],[CustomerID=2,Name="Jim"]})

Table.FromColumns

Table.FromPartitions

Last modified 3yr ago

Copy link

Contents

Table.FromList

Description