Answered

SharePoint List Form : Sort order of Lookup column

(0) Share

Report

Posted on by ShriniA

Hi,

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

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

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
ShriniA on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

I am afraid I try it but it didn't work.
There is no error but didn't show any data on dropdown list.

Was this reply helpful? Yes No
WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@ShriniA ,

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

Was this reply helpful? Yes No
ShriniA on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
ShriniA on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ShriniA on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@ShriniA ,

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

Was this reply helpful? Yes No
ShriniA on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No