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
| Argument | Description |
|---|---|
| table | The Table to convert. |
| optional combiner | The 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: