Delegation in a Dataverse Date column

[BCLS776]

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

[v-xiaochen-msft · Accepted solution]

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

[BCLS776]

Thanks Wearsky,

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

Bryan