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?
@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.
Share
Report
All responses (
Answers (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
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.
@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
I am using SharePoint as data source now. Will upgrade to Dataverse avoid the limit forever?
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
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
