Announcements
Hello All,
I noticed that there is a delegation warning on a Date field that i am trying to filter (DB=SharePoint List).
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
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.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 335 Most Valuable Professional
11manish 166
sannavajjala87 71 Super User 2026 Season 1
