Split — Power Fx function reference

Syntax

Split( Text, Separator )

Examples

Split("a,b,c", ",")

Split(txtTags.Text, ",")

ForAll(Split("a;b;c", ";"), Trim(Value))

Common mistakes & gotchas

• The result is a single-column table with the column named "Result" — reference each piece as .Result, not a custom column name.
• Split does not trim whitespace around each piece — wrap each result in Trim() when the separator is often followed by a space, e.g. "a, b, c".

Related Power Fx functions

From Text

Used in these tutorials