Power Fx function
Sort — Power Fx function reference
Order by a single formula.
Syntax
powerfx
Sort( Table, Formula [, SortOrder ] )
Examples
powerfx
Sort(Staff, LastName)
→ Ordered rows
powerfx
Sort(Orders, Amount, SortOrder.Descending)
powerfx
Sort(Staff, Len(LastName))
Common mistakes & gotchas
- Formula can be any per-row expression, not just a column name — but a non-delegable formula (like Len() on SharePoint) falls back to sorting only the retrieved page.
- Sort only orders by one formula; use SortByColumns for multiple sort keys with independent directions.
Related Power Fx functions
From Filtering, search & sort