How do I order the selection in a lookup field?

Question

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 in fruits in this order...Apple, Mango, Orange, Kiwi. But I want the lookup to display them as Orange, Mango, Kiwi, Apple...is there a way to reorder the entries so the users can view them in the preferred order in the lookup?

Thanks

spawn10 · Answer

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?

steveknutson · Answer

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

rkirk2k · Answer

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 · Answer

rkirk2k&nbsp;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)

carlos_grando_1987 · Answer

rkirk2k&nbsp;Awesome solution!&nbsp;The only change I would suggest on your code is change the colons by semicolons: before this, PowerApps was pushing some syntax errors (at least in my current version at 2023, January).&nbsp;So, instead of:Sort(Choices([@LIST_NAME].LOOKUP_COLUMN),Id,Ascending)I would suggest someone to also try what worked for me:Sort(Choices([@LIST_NAME].LOOKUP_COLUMN);Id;Ascending)&nbsp;Thank you!

Forum Discussion

How do I order the selection in a lookup field?

5 Replies

Resources