warning on sum function

(0) Share

Report

Posted on by MelvinGRM

Hi,

I have a gallery where i count all the items in a sp list. It works fine, but i keep getting a warning about the 500data limit. Is there any way to solve this?

the code i use:

Sum(Filter(Uitgeleend;Titel = ThisItem.Titel);AantalUIT)

thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@MelvinGRM

Aggregate functions like Sum() are not delegatable in SharePoint. Up to 2k maximum records can be calculated and will be accurate. You are getting the warning because you could possibly exceed this number and it is letting you know about it. You can raise the limit from the default of 500 up to 2k in the Settings.

Was this reply helpful? Yes No