Answered

Slow sorting with 7k+ records

(0) Share

Report

Posted on by teerapattang

I have 7k+ records with 76 columns in SharePoint list connected to PowerApps. I'm using SortByColumns function to sort the items in my gallery. The problem is when I set the sort order to ascending it took me only 0.4s to retrieve response but when I set it to descending it took me around 10s.

Here is my monitoring result:

monitoring result.PNG

The sort order in the red box is ascending and the blue is descending.

The formula that I'm using is SortByColumns(DBSubject,"ID",TextInput1.Text)

Why the first response size is not equal to the second one and how can I reduce the duration?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @teerapattang ,

It's because when sort ascending App can get all entries directly, the default sequence of entries is ascending. But sort descending need SharePoint server to process on all the entries first and then pass the result table to PowerApps.

Best regards,

Was this reply helpful? Yes No
Verified answer

teerapattang 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, the real problem was i have a multiline column that contains Base64 images after I deleted this column sort descending works fine.

Was this reply helpful? Yes No