Delegation in a Dataverse Date column

(0) Share

Report

Posted on by BCLS776

8,994 Moderator

Hi All,

I've got a stubborn delegation warning that I am unsure how to handle:

Here's a clear view of the code, in the Items property of a nested gallery:

With({
 closeDate: DateAdd(DateValue(labFirstSunday.Text), ThisItem.Value, Days), 
 closeDatePlusOne: DateAdd(DateValue(labFirstSunday.Text), ThisItem.Value+1, Days)},
 Filter(Deals,
 ClosingDate >= closeDate,
 ClosingDate < closeDatePlusOne
 )
)

This is a gallery-within-a-gallery to create a calendar to show records from the Deals table by ClosingDate. ClosingDate is a date-only Dataverse column, which should be delegable in this situation. However, I get a warning.

I have tried a nested With() to prefilter the Filter() by the first filtering term, but I still get a delegation warning on that one too.

Any ideas on how to get this one to delegate?

TIA,
Bryan

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCLS776 ,

I made a test and I found that if you use with() function and date field , it will return a delegation warning .

Please see the screenshot:

So I tried remove the with() function ,it's wierd that the delegation warning disappeared... and it showed the correct output in the gallery.

You can see that it returned 2 items .

My delegation seeting:

So I think you could try the formula without with()...

Best Regards,

Wearsky

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Wearsky,

Yes, the delegation warning goes away and the app delegates the Filter() properly with your suggested change. I appreciate the response!

Bryan

Was this reply helpful? Yes No