Announcements
Hello,
I need some clarification about the delegation when using ClearCollect and Filter functions:
Thank you
No
At least not as far as i know.
The item limit retrieved is 2K (if you changed the settings)
If a filter result has more than items it will only return the first 2000
A solution is to retrieve the items in different subcollections (batches), which you can then merge into a bigger one
@martijnA , my confusion was because I don't get the delegation warning when using Filter inside the ClearCollect!!
Hi @AhmedSalih ,
A collection is inherently a "hidden" Delegation limitation in that it will accept and act on a Delegable filter (so you can filter any number of records) , however it will then only collect the first (500 - 2000) set of records from the output of the filter.
There are ways of making large collections - I have a blog on this (it is based on SharePoint, but the effect is exactly the same for Dataverse).
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 383 Super User 2026 Season 2
Mohsin Ali 356
WarrenBelz 232 Most Valuable Professional
