web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

SharePoint List Form : Sort order of Lookup column

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I create SharePoint list and its Newform is customized by using PowerApps. There is a lookup field and I want to sort order.

ShriniA_0-1643592342696.png

@HCP旅行手配依頼書 is column name and 企画イベント名 is lookup column.

 

Ex: My Lookup data dropdown list will appear like this.

20211023_XXX

20211110_XXX

20211127_XXX

20211205_XXX

20220115_XXX

But I want to sort it like this.

20220115_XXX

20211205_XXX

20211127_XXX

20211110_XXX

20211023_XXX

 

Any help or guidance would be greatly appreciated.

Thank you.

I have the same question (0)
  • WarrenBelz Profile Picture
    152,816 Most Valuable Professional on at
    Re: SharePoint List Form : Sort order of Lookup column

    Hi @ShriniA ,

    Note that this is not Delegable (you cannot sort on a Lookup column in a Delegable way)

    Sort(
     AddColumns(
     SPListName,
     "SortField",
     企画イベント名 .Value
     ),
     SortField
    )
    

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

     

     

  • ShriniA Profile Picture
    on at
    Re: SharePoint List Form : Sort order of Lookup column

    Hi @WarrenBelz ,

     

    I am afraid I try it but it didn't work.

    ShriniA_0-1643594118137.png

    There is no error but didn't show any data on dropdown list.

    ShriniA_1-1643594181387.png

     

  • WarrenBelz Profile Picture
    152,816 Most Valuable Professional on at
    Re: SharePoint List Form : Sort order of Lookup column

    @ShriniA ,

    That is the correct syntax - how many items are in the list? Also what is the field shown in the drop-down ?

  • ShriniA Profile Picture
    on at
    Re: SharePoint List Form : Sort order of Lookup column

    @WarrenBelz ,

     

    There are dozens of data on that lookup field. My problem is latest data is goes to bottom of the list. That's why I want to sort it that I mention above.

     

    ShriniA_0-1643594807408.png

     

  • WarrenBelz Profile Picture
    152,816 Most Valuable Professional on at
    Re: SharePoint List Form : Sort order of Lookup column

    @ShriniA ,

    So you are saying there are some items that are blank?  Again, this is not Delegable

    Sort(
     Filter(
     AddColumns(
     SPListName,
     "SortField",
     企画イベント名 .Value
     ),
     Len(SortField) > 0
     ),
     SortField
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

  • ShriniA Profile Picture
    on at
    Re: SharePoint List Form : Sort order of Lookup column

    @WarrenBelz ,

     

    It doesn't work. 😔😔

    That field is Events name with starting date (20211025_XXX).

    This is its original list. This column is 'Event Name' which is type of calculated (TEXT field). I want this order to display in Lookup filed dropdown  list.

    ShriniA_0-1643595503948.png

     

  • WarrenBelz Profile Picture
    152,816 Most Valuable Professional on at
    Re: SharePoint List Form : Sort order of Lookup column

    @ShriniA ,

    That is the first you have mentioned a Calculated field - you are correct, they do not work well in Power Apps and you need to store that as Text if you want to use it. Also you need to seriously consider not using Lookup columns (I have not used them for many years) unless you want to use them directly in SharePoint.

  • ShriniA Profile Picture
    on at
    Re: SharePoint List Form : Sort order of Lookup column

    @WarrenBelz ,

     

    Yes, It's a stored as a Text. But I couldn't sort it well when I use lookup field

    I try to use default SharePoint form as well but it didn't work well too.

    ShriniA_0-1643596771709.png

     

  • WarrenBelz Profile Picture
    152,816 Most Valuable Professional on at
    Re: SharePoint List Form : Sort order of Lookup column

    @ShriniA ,

    Can you please answer my original question - how many items are in this list?

  • ShriniA Profile Picture
    on at
    Re: SharePoint List Form : Sort order of Lookup column

    @WarrenBelz 

     

    New Events are added frequently, so there is no limit. Currently, we have 50+ items(events).
    When we have a new event, then the original event list will be updated day by day.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard