Forum Discussion

Spawn10's avatar
Spawn10
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
Spawn10's avatar
Spawn10
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?
  • rkirk2k's avatar
    rkirk2k
    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's avatar
      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's avatar
        carlos_grando_1987
        Copper Contributor
        Jan 13, 2023

        rkirk2k Awesome solution! :smile:
        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