Forum Discussion
How do I order the selection in a lookup field?
I am using a lookup column in SharePoint to pull data into the list users use to create an order. Is there a way to order the entries in the lookup column? As an example if I have my lookup pulling i...
It items will show in the order they appear in the List. If you want to use an alternative sorting method then you will need to customise the List form using PowerApps https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-list-form
- Thanks for the response. I have a custom PowerApps form that is using my lookup column. Right now the order is that is being displayed in the form is in alphabetical order. I want to be able to rearrange the order so that when the user click on the field in the custom PowerApps form, the lookup order is as desired and not in alphabetical order.
Is there a way to accomplish this?- Same issue here. I've sorted the default view of the list that is the target of the lookup column, so it appears in the desired order... But when I click the choice combo box in my Power App form, it is ordering them alphabetically anyway. Help????
rkirk2k I WAS ABLE TO SOLVE THIS...
For whatever reason, PowerApps insists on presenting the choices in alphabetical order, EVEN THOUGH the list was created in the desired order (AND EVEN AFTER I went in and sorted the default view of the targeted list on the column holding the choices) So WEIRD.
So, I actually had the items in the list in the order I wanted.Meaning - the ID field was in the correct order, but the column I was rendering continued to be displayed alphabetically. I had to force the choice control in PowerApps to sort based on the ID field in ascending order. It looked like this...
Sort(Choices([@LIST_NAME].LOOKUP_COLUMN),Id,Ascending)
