Unanswered

Issue sorting an huge sharepoint list (more than 20000 record)

(0) Share

Report

Posted on by babaciu75

I have a BrowseGallery connected to a Sharepoint List of 25000 rows, if I try to do a Sort or a SortByColumns on a single column of my List I have no problems, but if I try to insert another Sort or another column in the SortByColumns my list returns no data.

Can you tell me if there is a record limit that prevents me from sorting based on 2 columns?

I temporarily solved my issue by concatenating the 2 columns.
This is the content of my BrowseGallery Items :

Sort(
Filter(
[MySP_List];
ACCOUNT = User().Email;
StartsWith(
Column1;
TextSearchBox1.Text
) || StartsWith(
Column2;
TextSearchBox1.Text
) || StartsWith(
Column3;
TextSearchBox1.Text
) || StartsWith(
Column4;
TextSearchBox1.Text
)
);
Column_order1 & Column_order2;
If(
SortDescending1;
Descending;
Ascending
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@babaciu75

SortByColumns is not delegatable if you use a variable to sort on. The problem is SortDescending1. If you can live with just sorting your columns Ascending, I think you will avoid the issue.

Was this reply helpful? Yes No
babaciu75 6 on at

Like
a
(0)

Report
Copy link

Link copied!

I already did, but the problem persists

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@babaciu75

Try

Sort( Sort( Filter([MySP_List]; ACCOUNT = User().Email; StartsWith(Column1;TextSearchBox1.Text) || StartsWith(Column2;TextSearchBox1.Text) || StartsWith(Column3;TextSearchBox1.Text) || StartsWith(Column4;TextSearchBox1.Text) ); Column_order1; Ascending); ColumnOrder2, Ascending )

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@babaciu75

Try

Sort( Sort( Filter([MySP_List]; ACCOUNT = User().Email; StartsWith(Column1;TextSearchBox1.Text) || StartsWith(Column2;TextSearchBox1.Text) || StartsWith(Column3;TextSearchBox1.Text) || StartsWith(Column4;TextSearchBox1.Text) ); Column_order1; Ascending //If this isn't a variable, otherwise Column1;Ascending ); ColumnOrder2, Ascending //If this isn't a variable, otherwise Column2;Ascending )

Was this reply helpful? Yes No
babaciu75 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I had already tried ... I think there is a power apps limit that depends on the number of lines on the SharePoint list. I tried to take another list with the same structure but with only 200 rows and everything works correctly with 2 and even more sorts nestled.
My question is if someone is aware of this limit.
Thank you

Was this reply helpful? Yes No
Adoe 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the exact same issue. My formula were Filter(Sort(DataSource;Column;Sortorder);Column = A;etc).
It worked until the sharepoint list exceeded 8300 rows.
I then tried Sort(Filter(...)) - but it just showed me an empty gallery.

Was this reply helpful? Yes No
Adoe 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I now solved this issue - the solution (for me, atleast) - were to Index the sorting column in Sharepoint list.
Go to the sharepoint list - list settings - in the bottom of the columns specification there is 'Indexed columns' - create an Index for the column(s) you wish to sort in Power Apps
When this is done, use a filter/sort like this example:
SortByColumns( Filter( 'DataSource'; StartsWith(Title;Search.Text);Type.Value = Filter.SelectedText.Value || Filter.SelectedText.Value = "All");IndexedColumn;If(Sort.SelectedText.Value = "Ascending";SortOrder.Ascending;SortOrder.Descending))

Was this reply helpful? Yes No
babaciu75 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the proposed solution, to solve the problem I had chosen an appropriate criterion by concatenating 2 columns (for example date in yyyymmdd format and a numerical value indicating the status of my record) of my sharepointlist and then sorting by this field

Was this reply helpful? Yes No