Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Sort Drop Down by Name Value

I have a app for tracking sales 

our sales teams use it to update 

i have it set so that the team can choose manager from drop down

then choose themselves from drop down

and enter their sales


both drop downs are linked to sharepoint list so that the coaches (team leads) can be changed as needed

when I set it up in the beginning I entered the coaches alphabetically 


since then many more coaches have been added


since all stored data is tied to the ID number assigned by sharepoint I am unable to simply manually reorder the list and i can not figure out how to sort names in the drop down on the app




when a user edits form on sharepoint names are sorted correctly but on the app it will only sort by the ID not the Title (Value)

MelindaK Skilled Sharer
Skilled Sharer

Re: Sort Drop Down by Name Value



This sounds like you can use the SortByColumn function in the Items property of the drop down:


SortByColumns(ListName, "Field_Name").Title 

- where Field_Name should be the name of the field you want to sort by and Title would be the name of the column you want to display in the drop down


This can also be nested with a Filter function, something like this:

SortByColumn(Filter(ListName, condition), "Field_Name").Title


Hope this helps 🙂 



Helpful resources


Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!


New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,779)