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  

ArgumentDescription
listThe List to convert.
optional splitterSplitter function.
optional columnsA list of text values specifying the column names of the resulting table.
optional defaultA default can be provided to be used for missing values in the table.
optional extraValuesExtra 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"})  

CustomerIDNamePhone
1Bob123-4567
2Jim987-6543
Show: