Concatenate

join multiple text strings into one single string.

The Concatenate function in Power FX is used to join multiple text strings from different fields or values into a single output, like creating dynamic messages or combining parts of data for display.

Syntax

Concatenate(ThisItem.ColumnName1, "text_1", ThisItem.ColumnName2, "text_2",....)

• ThisItem : The identifier for the current row or record

• ColumnName: The column containing the numerical values you want to include for the average calculation

• "Text": The literal text is enclosed in quotes.

Example

Suppose you have an order table with the full address broken into columns Street1, Street2, City, State, PostalCode, and Country.

Requirement:

Show the full address within one field when viewing the records in the collection layout of the View from... page of the table.

For example:

• Street 1: 2103 CASTLE VIEW DR

• City: AUSTIN

• State: TX

• PostalCode: 78728-5490

• CountryCode: US

Concatenate to: 2103 CASTLE VIEW DR, AUSTIN, TX 78728-5490, US

Formula:

Concatenate(ThisItem.Street1,", ", ThisItem.City,", ",ThisItem.State," ",ThisItem.PostalCode,", ",ThisItem.CountryCode)

Result

If the formula and data are correct, you can see the value of column when you set to view it in the app.