web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sort Ascending / Alpha...
Power Apps
Unanswered

Sort Ascending / Alphabetical in Dropdown or Combo Box

(1) ShareShare
ReportReport
Posted on by 5,329 Super User 2025 Season 2

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:
I have the same question (0)
  • Coopedup Profile Picture
    347 on at

    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)

     

  • Phineas Profile Picture
    5,329 Super User 2025 Season 2 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 405 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 280 Super User 2025 Season 2

#3
Kalathiya Profile Picture

Kalathiya 272

Last 30 days Overall leaderboard