SP List has more then 2000 rows, Records are missing in Browsegallery

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I have 2000+ records in my SP list. I cannot some records in my app.

What I have tried -

1) I changed the settings of data row limit to 2000.

2) OnStart of App -

Concurrent(
ClearCollect(col1, Filter(testme_1, ID >= 1 && ID <= 2000)),
ClearCollect(col2, Filter(testme_1, ID >= 2001 && ID <= 4000)),
ClearCollect(col3, Filter(testme_1, ID >= 4001 && ID <= 5000))
);
ClearCollect(MergedCollection, col1, col2, col3)

then in my browsegallery i have -

SortByColumns(Filter([@MergedCollection],

('Assigned to'.Email = User().Email And (Status = "In Progress" Or Status = "NOT STARTED"))

), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

However I am still missing my records in my browsegallery. Anything I am doing wrong here?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report
Your onStart won't work because the only delegable operator allowed with the ID is =. So your ClearCollect statements aren't delegable. A better solution is to filter your gallery using delegable functions to get the size down below 2,000. User's won't scroll through a gallery that large anyway. I would suggest the following code assuming that Status is a Choice column.

Set(currentEmail, User().Email); SortByColumns(Filter(DataSourceName, ('Assigned to'.Email = currentEmail && (Status.value = "In Progress" || Status.value = "NOT STARTED")) ), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

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

Like (0)

Report

@Pstork1 thanks, why are you making the current email variable? is that its easier to read? Getting an error on it.

also Status is not a choice column, its a single line of text.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

Using the User() function inside a filter statement makes it non-delegable because the back end data source doesn't know the function. But passing it a value is delegable. Just put the set in OnStart or OnVisible for the first page or somewhere like that. It doesn't change after the user starts the program so it only needs to run once.

Was this reply helpful? Yes No