Filter warnings how to use filters without warnings?

(0) Share

Report

Posted on by Oskarkuus

1,097

How to fix the "warnings" that i get when using different filters?

For example i have this: Sum(Filter(Kassa_Lista;KlubbNamn=varKlubbNamn);Saldo)

Then i get a warning (in my language) saying something about

This formula might not work correct in large datasets

How large is a "large" data set?

What can i do about this, how to filter in a way that does not generate warnings?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

Is Kassa_Lista a SharePoint list? The Sum() isn't delegable in SharePoint. The definition of a large data set is based on what you have the "Data row limit for non-delegable queries" set to in the App Settings. By default it is set to 500 but you can increase it up to 2,000. To view or update the setting go to File > App Settings > Advance Settings.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Oskarkuus how are you progressing with this? Was the above reply helpful?

@Anonymous

Was this reply helpful? Yes No
Oskarkuus 1,097 on at

Like (0)

Report

I have increaset the max value to 2000
Kassa_list is a SP List.

Im tho worried that in the futere my app will fail in some way. It is unlikely that my list will ever contain more than 700 objects.
But can something else go wrong by using this code? Can i use some other code with the same effect?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I think you can use CountRows(Filter(Kassa_Lista;KlubbNamn=varKlubbNamn)). Put that in a label to see the result.

If u use variable that doesnt work on large datasets, it works poorly if it becomes over that size.

Was this reply helpful? Yes No
Oskarkuus 1,097 on at

Like (0)

Report

Over 2000 or 700?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

2000. The delegation warning is there mainly because of performance reasons. You can read more about delegation here:
https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Deep-Dive-Into-Delegation-What-Is-It-Exactly/ba-p/181456

Was this reply helpful? Yes No