Delegation warning on Sharepoint

[iagosalvadori]

Hi everyone,

I am a beginner in powerapps and I have a question that I am unable to resolve.

I am developing an expense application, and I would like the finals users to be able to view the expenses that were sent:

Status Approval:

• Open
• Aprroved
• Deny

I write the code to make it possible, an warning appears and I don't know how to overcome a situation:

Is it possible to do that?

[YiannisLap]

Isn't this a flaw of powerapps? this should not be a matter of delegation: the filter in within the sum, so you'd expect the filter to run first, regardless of the SUM and after it fetches SP records, the sum function should just give their sum.

The solutions suggested are anything than optional I am afraid. running flows is too much if you are dealing with a large collection. Further, updating a list (with a schedule) will only provide inconsistent data for current records.

there must be another way...