cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Suilenroc
Frequent Visitor

Help with sorting dropdown populated with Sharepoint list items

Greetings everyone,

 

I have a dropdown that is currently populated from a Sharepoint list using a simple expression:

 

 

Filter(
    'Employee List', 
EmployeeJob = "Job-1" Or 
EmployeeJob = "Job-2" Or
EmployeeJob = "Job-3" Or 
EmployeeJob = "Job-4")

 

 

Certain employees can add to this list through Powerapps, but when an employee is added it is placing the new employee at the bottom of the drop down box. How can I get it to automatically sort the drop-down items in alphabetical order?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
MarvinBangert
Solution Sage
Solution Sage

Hey @Suilenroc 

please try the following:

Sort(
    Filter(
        'Employee List', 
        EmployeeJob = "Job-1" Or 
        EmployeeJob = "Job-2" Or
        EmployeeJob = "Job-3" Or 
        EmployeeJob = "Job-4"
    ),
    Title,
    <Ascending/Descending>
)

 

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

View solution in original post

2 REPLIES 2
MarvinBangert
Solution Sage
Solution Sage

Hey @Suilenroc 

please try the following:

Sort(
    Filter(
        'Employee List', 
        EmployeeJob = "Job-1" Or 
        EmployeeJob = "Job-2" Or
        EmployeeJob = "Job-3" Or 
        EmployeeJob = "Job-4"
    ),
    Title,
    <Ascending/Descending>
)

 

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

View solution in original post

Knew it had to be something simple!

 

Thank you!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,802)