Sort Ascending / Alphabetical in Dropdown or Combo Box

(1) Share

Report

Posted on by Phineas

5,331 Moderator

How do I get the following to show the content of my dropdown or combo box in Ascending / Alphabetical order?

When original constructed the dropdown and data worked fine. However, as I started adding new names through power apps those name always display at the bottom of the dropdown list, rather than appearing ascending and alphabetically. The new names appear at the bottom as shown here, as an example.

Leghorn, Daffy A

Wayne, Bruce
Duck, Daffy A

How do I get the above and any new names to appear in the dropdown ascending and alphabetically by rewriting the below? All components of the below work, except any new names. Also, anyone OTHER than region should see ALL names (no matter region) in ascending/alphabetical order.

If(Hierarchy="Manager", Sort(Filter('List', Region=varRegion),FullName,Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Coopedup 347 on at

Like (0)

Report
Copy link

Link copied!
I have something for a SP Person Field, which will remove duplicate names I have and order ascending.

If( Dropdown1.Selected.Value = "Owner", Sort(ForAll(Distinct( 'Register'.'Owner', { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", DisplayName:'Rik Owner'.DisplayName, Claims:'Owner'.Claims, Email:'Owner'.Email } ),Result), DisplayName, Ascending)

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

Like (0)

Report
Copy link

Link copied!

Sorry, that won't work. I should clarify...

I have a hierarchy set up for the members in the collection (National, Region, Local, Employee).

My condition should allow those employees with 'Region' hierarchy to only see the names of individuals in their given region (the varRegion in the condition contains the members region and the varProgramHierarchy tests for hieararchy level) in the dropdown or combo box.

Currently, as written, the condition is returning ALL names in alphabetical order, except for the last dozen NEW names that were added to the collection after the site was built.

All those name are forced to the bottom of the dropdown or combo box in the order in which they were added. Why is in new names are not sorted ascending/alphabetical?

Why is this? I have the ascending language in the condition and no errors appears.

Condition:
If(varProgramHierarchy="Region", Sort(Filter('List', Region=varRegion),FullName,Ascending), If(varProgramHierachy="National", Sort(Filter('List', FullName),Ascending)))

*Actually, I don't even need the 'National' part; the end can just be show all in order to whomever.

Was this reply helpful? Yes No