Table.ToList

 

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.

Returns a table into a list by applying the specified combining function to each row of values in a table.

Table.ToList(table as table,  optional combiner as nullable function) as list  

ArgumentDescription
tableThe Table to convert.
optional combinerThe combiner function is applied to each row in the table to produce a single value for the row.
let  
  
    input = Table.FromRows({  
  
    {Number.ToText(1),"Bob", "123-4567" },  
  
    {Number.ToText(2), "Jim", "987-6543" },  
  
    {Number.ToText(3), "Paul", "543-7890" }})  
  
in  
  
    Table.ToList(input, Combiner.CombineTextByDelimiter(","))  
  
equals  
  
{  
  
    "1,Bob,123-4567",  
  
    "2,Jim,987-6543",  
  
    "3,Paul,543-7890"  
  
}  

Show: