Sort/Filter/Sort.Ascending not Sorting A - Z

(1) Share

Report

Posted on by Phineas

5,331 Moderator

I have multiple Dropdowns, one of which is FullName.

I am trying to Sort(Filter...SortOrder.Ascending) my Collection in the Dropdow but it is not working.

The formula is not sorting by first or last name in the FullName Dropdown.

The are areas in the list where it appears some sorting if being done, but the first 10 or so are not sorted at all, and the last
Item starts with a 'B' (and should be near the top of the list).

There are two 'Role', "Technician" or "Subcontractor". The Dropdown should filter and sort A - Z based on the Role choice.

What am I missing?

My Tech / Contractor Name Dropdown formula -

Sort(Filter(Technician_and_Contractor_Collection,Role = Role_Dropdown.Selected.Value).Full_Name,

SortOrder.Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

jpespena 335 on at

Like (0)

Report
Copy link

Link copied!
Hi Phineas,

Try:

Sort(Filter(Technician_and_Contractor_Collection,Role = Role_Dropdown.Selected.Value),Full_Name,SortOrder.Descending)

Or

SortByColumns(Filter(Technician_and_Contractor_Collection,Role = Role_Dropdown.Selected.Value),"Full_Name",SortOrder.Descending)

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (1)

Report
Copy link

Link copied!

Yes, the SortByColumns did it!

Was this reply helpful? Yes No