Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.FromList

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

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  

Arguments

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.

Example

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
© 2018 Microsoft