Concatenate & — Power Fx function reference

Syntax

Concatenate( Text1, Text2, ... ) / Text1 & Text2

Examples

"Hi, " & txtName.Text

Concatenate(txtFirst.Text, " ", txtLast.Text)

"Order #" & ThisItem.OrderNumber & " – " & Text(ThisItem.Amount, "$#,##0.00")

Common mistakes & gotchas

• The & operator is the idiomatic way to concatenate.
• & coerces non-text values (numbers, dates, booleans) to text with default formatting — for a specific format, wrap with Text(value, format) instead of relying on the implicit conversion.
• A blank value contributes an empty string to &, unlike some functions where a blank argument propagates and blanks out the whole result.

Related Power Fx functions

From Text

Used in these tutorials