Training
Module
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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Table.CombineColumns(table as table, sourceColumns as list, combiner as function, column as text) as table
Combines the specified columns into a new column using the specified combiner function.
Combine the last and first names into a new column, separated by a comma.
Usage
Table.CombineColumns(
Table.FromRecords({[FirstName = "Bob", LastName = "Smith"]}),
{"LastName", "FirstName"},
Combiner.CombineTextByDelimiter(",", QuoteStyle.None),
"FullName"
)
Output
Table.FromRecords({[FullName = "Smith,Bob"]})
Training
Module
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.