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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Pstork1 68,707 Most Valuable Professional on at

Like (3)

Report

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.

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (1)

Report
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

Was this reply helpful? Yes No