Table.FromList
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Converts a list into a table by applying the specified splitting function to each item in the list.
Table.FromList(list as list, optional splitter as nullable function, optional columns as any, optional default as any, optional extraValues as any) as table
| Argument | Description |
|---|---|
| list | The List to convert. |
| optional splitter | Splitter function. |
| optional columns | A list of text values specifying the column names of the resulting table. |
| optional default | A default can be provided to be used for missing values in the table. |
| optional extraValues | Extra values for each item in the list. |
Table.FromList(
{[CustomerID =1, Name ="Bob", Phone = "123-4567"] ,
[CustomerID =2, Name ="Jim", Phone = "987-6543"]},
Record.FieldValues, {"CustomerID", "Name", "Phone"})
| CustomerID | Name | Phone |
|---|---|---|
| 1 | Bob | 123-4567 |
| 2 | Jim | 987-6543 |
Show: