SortByColumns not working on multiple columns

(0) Share

Report

Posted on by mychau

My Sharepoint List gallery is not showing anything ("We didn't find any data"). I'm not sure what is wrong here.

1. Column names are correct

2. Formula is correct

3. If I used SortByColumns on 1 column (either mentioned columns above), it worked. But when I combine it, it's not working.

SortByColumns(
 BankReconciliation_Summary,
 "StatementDate",
 SortOrder.Descending,
 "TransactionAmount_x002d_Credit",
 SortOrder.Ascending
)

Screenshot 2023-08-08 010048.png

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
@mychau ,

There is nothing wrong with the code and it should work. You can nest Sort Functions

Sort( Sort( DataSource, Field1, Order1 ), Field2, Order2 )

but you should not have to do this.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

mychau 56 on at

Like (0)

Report

Hi @WarrenBelz ,
Thank you so much for your prompt help. I just discovered that multiple-level sorting does not work on Sharepoint List over 5,000 records. I've tried your suggested workaround but still no result. I guess I have no option but to accept one-level sorting only.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@mychau ,

If you index the columns you are sorting on, it may work - I have not struck that particular restriction before

Was this reply helpful? Yes No
mychau 56 on at

Like (0)

Report

I did index the columns used in sorting.
It took me hours of searching in the forum and I came across someone with same issue.
Solved: Re: Threshold Limits - Multiple Levels of Gallery ... - Page 2 - Power Platform Community (microsoft.com)
I will find some workaround to reduce the records in my SharepointList so I could use the multiple level sorting again 😞

Was this reply helpful? Yes No