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
Solved! Go to 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
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
Thanks Wearsky,
Yes, the delegation warning goes away and the app delegates the Filter() properly with your suggested change. I appreciate the response!
Bryan
User | Count |
---|---|
257 | |
110 | |
97 | |
52 | |
39 |