Unanswered

Delegation warning when using With / Today construction

(0) Share

Report

Posted on by MrNappa

241

Here's some unexpected behavior I encountered. When attempting to filter a (CDS) data source based on a date, I encountered a 'delegation warning'. After analysis, this turned out to be the result of a 'With' construction:

With({
 mindate: DateAdd( Today(), -7, Days )
},
 Filter( Projects, Datum >= mindate )
);

Is there any explanation for this?

I was poking around a bit, and it seems to be tied to only a With/Today() setup, as you can observe from the following screenshot:

What's happening here?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MrNappa ,

That is because the With and Today() functions and their interaction with the delegation capabilities of PowerApps. You should not use that function multiples times because that functions works locally and it will not work well if your entity filter query returns more than 500 records. My recommendation is to preload the today() value in a global variable or to create a collection only if you are working with + 500 records.
Best regards,
Sik
If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

Was this reply helpful? Yes No
MrNappa 241 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the suggestion. Yeah I know I can work around it, in fact I already did, but I found it curious that the same construct with With/Now() does not give any delegation problems while With/Today() does. Not sure if I were missing something subtle here.

Was this reply helpful? Yes No