Power Fx function
SortByColumns — Power Fx function reference
Order by named columns.
Syntax
powerfx
SortByColumns( Table, Column1 [, SortOrder1 ] [, Column2, SortOrder2, ... ] )
Examples
powerfx
SortByColumns(Staff, "LastName", SortOrder.Ascending)
→ Ordered rows
powerfx
SortByColumns(Orders, "Status", SortOrder.Ascending, "Amount", SortOrder.Descending)
powerfx
SortByColumns(Filter(Staff, Active), "Department", SortOrder.Ascending)
Common mistakes & gotchas
- Column names are passed as text strings, not bare identifiers — a typo in the string fails less obviously than a design-time reference error.
- SortOrder is optional per column and defaults to Ascending when omitted.
Related Power Fx functions
From Filtering, search & sort