Delegation warning on delegable operators

(0) Share

Report

Posted on by Anonymous_Hippo

1,247 Super User 2024 Season 1

Hello All,

I noticed that there is a delegation warning on a Date field that i am trying to filter (DB=SharePoint List).

Screenshot 2022-10-16 132447.png

Can someone please explain to me why there is a delegation warning even though i am using delegable operators. Also is there a way to fix this issue 🙂 Thanks

Categories:

General Questions

All responses (2)

Answers (1)

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (1)

Report
Re: Delegation warning on delegable operators

I was able to fix this delegation warning my replacing the calculation to a variable

Set(RequestFilterByDate,Today()-21) //OnStart

Filter('Product Support Requests','Request Closed Date'=Blank() || 'Request Closed Date' >= RequestFilterByDate)

Boom no delegation warning 🙂

Hopefully this will be helpful for somebody who encounters this issue in the future
Verified answer

Pstork1 67,060 Most Valuable Professional on at

Like (3)

Report

Re: Delegation warning on delegable operators

The use of Blank() isn't what is flagged as delegable. The use of || (or) and the attempt to check the date against a formula instead of a value are what are flagged as non-delegable. Formulas can't be delegated to the data source and OR is rarely a delegable operator.