Power Fx function
Concat — Power Fx function reference
Join a table column into text.
Syntax
powerfx
Concat( Table, Formula [, Separator ] )
Examples
powerfx
Concat(colTags, Value, ", ")
→ "x, y, z"
powerfx
Concat(colTags, Value, ", ")
powerfx
Concat(Filter(Staff, Department = "IT"), Name & " (" & Email & ")", Char(10))Common mistakes & gotchas
- Formula is evaluated per row and can be any expression, not just a bare column reference — Concat is effectively the inverse of Split.
- Against a large non-delegable table, Concat only joins the rows retrieved locally, subject to the same row limits as other non-delegable functions.
Related Power Fx functions
From Text
Used in these tutorials
Beyond Built-in Charts: Using QuickChart for Custom Visuals in Power AppsFrom Breaking to Resilient: Three Error-Handling Strategies in Power AutomateMastering Table Variables in Copilot Studio: Add, Remove, and Clear via YAMLFrom Raw Strings to Structured Data: A Guide to Power Automate Text Functions