Обука
Модул
Create formulas that use tables, records, and collections in a canvas app in Power Apps - Training
Do you have need for complex formulas in your app? This module can help you write those formulas.
Table.ToList
Table.ToList(table as table, optional combiner as nullable function) as list
Converts a table into a list by applying the specified combining function to each row of values in the table.
Combine the text of each row with a comma.
Usage
Power Query M
Table.ToList(
Table.FromRows({
{Number.ToText(1), "Bob", "123-4567"},
{Number.ToText(2), "Jim", "987-6543"},
{Number.ToText(3), "Paul", "543-7890"}
}),
Combiner.CombineTextByDelimiter(",")
)
Output
{"1,Bob,123-4567", "2,Jim,987-6543", "3,Paul,543-7890"}