You’re offline. This is a read only version of the page.
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
213
Most Valuable Professional
#2
MS.Ragavendar
108
#3
stampcoin
80
