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)
This sounds like you can use the SortByColumn function in the Items property of the drop down:
- 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 🙂
Keep your eyes open for our upcoming T-shirt design contest!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020