Answered

Help with custom sorting on a SharePoint lookup column

(2) Share

Report

Posted on by gsr51

In this form the Status field is a SharePoint lookup column. The Status lookup is coming from the "Sunday Lookup List" and has an associated StatusCode (0-4) column I'd like to sort by.

Sunday Request List is the main (form) list. Status & StatusCode are the lookup columns.

Sunday Lookup List is the lookup list.

The Sunday Request List settings:

The "Sunday Lookup List" settings:

image 5

This is what I have so far in the Items property of the Status field. This is where I need help with the syntax.

If anyone can help me out with the syntax here I'd really appreciate it!

Thanks,

-Greg

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
Hi gsr51

You do not need quotes around "Order" for the AddColumns parameter.
SortBvColumns( AddColumns( Choices([@’Sunday Request List’].Status), Order, LookUp( 'Sunday Lookup List', Title = Value ).StatusCode ), "Order", SortOrder.Ascending )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
gsr51 76 on at

Like (0)

Report

Thanks! That fixed the issue. Appreciate you helping.

Was this reply helpful? Yes No