cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Nkilgor
Level: Powered On

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

 

image.png

 

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)

1 REPLY 1
MelindaK
Level 8

Re: Sort Drop Down by Name Value

Hi,

 

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 🙂 

 

MelindaK

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,476)