Power Fx function
Read and shape data
SortByColumns
Orders rows by columns.
What it does
Orders rows by columns.
The job: Take a table or data source, keep the rows you want, and reshape the columns for display.
How to use SortByColumns
Start from the task, not the alphabet. If you are shaping rows for a gallery, reach for SortByColumns alongside the other data functions in its group; if you are saving, navigating, or changing state, use it on an event such as a button OnSelect rather than in a display property. When a formula misbehaves, check for a blank value where you expected text, then confirm the behaviour against the examples in the Power Fx function reference hub.
New to the language itself? Read What Is Microsoft Power Fx? first, then come back here when you need this specific tool.
Related functions
AddColumnsAdds calculated columns to a table.ChoicesAllowed values of a choice column.DistinctUnique values only, duplicates removed.DropColumnsRemoves columns from a table.FilterKeeps rows that meet a condition.GroupByBundles rows into groups.LookUpFirst row that meets a condition.RenameColumnsGives columns new names.