Answered

How to avoid delegation warning for "not equal" to ID

(0) Share

Report

Posted on by Community Power Pla...

I have a collection named "booking". I want to compare one of item with all the other items in the same collection. Therefore I want to filter out all rows in "booking" beside ID=bid. My code:

Filter(booking,(ID<>bid)

But it prompt me for delegation warning. How can I get rid of it?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,059 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

Unfortunately you cannot - the <> (not equals) operator is not Delegable.

Please click Accept as solution 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 giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I am using SharePoint as data source now. Will upgrade to Dataverse avoid the limit forever?

Was this reply helpful? Yes No
WarrenBelz 153,059 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

I am not a Dataverse user, but I believe this is Delegable (refer this document) - I assume you understand the additional licensing cost that will be involved.

Please click Accept as solution 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 giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

After I applied "With" as below, the delegation warning is suddenly gone:

With({_preFilter: Filter(Booking,((StartTime <= myStartTime)},
Filter(_preFilter,(ID<>bid)
))

I am wondering what the justification of delegation warning is.

In my environment, before applying the _prefilter the number of rows is about 100 only. After applying _prefilter there are 10 rows. Both are far below 2,000 rows limit.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,059 Most Valuable Professional on at

Like (0)

Report
@Anonymous ,

It may be masking it however - With() is a "hidden" Delegation limit (I would have suggested it however if you had another filter in the code you posted). This code relies on the number of records returned from the With() statement is less than your Delegation limit.

With( { _preFilter: Filter( Booking, StartTime <= myStartTime } {, Filter( _preFilter, ID <> bid ) )

Please click Accept as solution 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 giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No