Forum Discussion

Copper Contributor

Jan 31, 2022

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...

SharePoint Online

Copper Contributor

Feb 01, 2022

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?

Copper Contributor

Dec 20, 2022

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
Copper Contributor
Dec 20, 2022
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)
- carlos_grando_1987
  Copper Contributor
  Jan 13, 2023
  rkirk2k Awesome solution!
  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).
  
  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)
  
  Thank you!

Resources