Power Fx function
Ungroup — Power Fx function reference
Flatten a grouped table.
Syntax
powerfx
Ungroup( Table, GroupColumnName )
Examples
powerfx
Ungroup(grouped, "Rows")
→ Flat table
powerfx
Ungroup(GroupBy(Orders, "CustomerID", "Rows"), "Rows")
powerfx
ClearCollect(colFlat, Ungroup(colGrouped, "ByRegion"))
Common mistakes & gotchas
- Ungroup exactly reverses a GroupBy that used the same GroupColumnName — a table not produced by GroupBy, or the wrong column name, fails since it expects that nested-table shape.
- Rarely needed outside round-tripping a GroupBy result; most apps consume the grouped table directly instead of flattening it back.
Related Power Fx functions
From Table shaping