delegation error

(0) Share

Report

Posted on by TS-17021950-0

Getting delegation warning when I run the below code on a choice column. The data source is SharePoint

What have I tried..:

pushing the limit up to 2000

using the With()

tried using !=, and !(Status.Value = "Closed")

None of the above worked. Can someone explain to me what I'm missing here?

Code:

With(
    {
        _overdue: Filter(
            EnvironmentalPermits,
            Status.Value <>"Closed" && ExpirationDate < Today()
        )
    },
    CountRows(_overdue)
)

Categories:

Building Power Apps

General topics

Error handling

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @TS-17021950-0,

That is because Not is not Delegable - you have used not equals <>. You are going to need to specify all the other Status values you want (example)
With( { _overdue: Filter( EnvironmentalPermits, ( Status.Value = "In Progress" || Status.Value = "Pending" || Status.Value = "Opened" ) && ExpirationDate < Today() ) }, CountRows(_overdue) )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

Amol-Kavnekar 125 on at

Like (0)

Report
Copy link

Link copied!

Hi TS-17021950-0

In SharePoint, delegation for Choice columns is limited. The operator <> (not equal) is not delegable for Choice fields, and neither is CountRows() over a non‑delegable filter. So even though your filter works on small data sets, it won’t delegate for larger lists.

Also, Today() is delegable, but once the filter uses a non‑delegable operator, the whole filter becomes non‑delegable.

You can find more about delegable functions here - https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-sharepoint-online#power-apps-delegable-functions-and-operations-for-sharepoint

Was this reply helpful? Yes No