Announcements
@KKss
It is a warning that you are aware of and as long as the tables those functions and operators are working on are below the limit, there is no effect.
.
Unless you can filter your data down to less than 2k items say by archiving some records out, or by using the last 2k records, you cannot use ForAll() or the "in" operator.
Hello @KKss ,PowerApps will not let you filter on more that 2,000 even if you don't have delegation warning sign for performance-pruposes.So what you need to do is instead of using the datasource itself, Collect the data into a collection and filter on the collection.Please refer to my comment as an accepted solution if it fix your problem,Regards,Oussama.
@OussamaOsman
You realize that Collect() and ClearCollect() are also not delegatable?
@Drrickryp try to collect into a collection while filtering, it will filter without any limitation than you have a collection of the data you want 😀 for Example:lets say i have a variable called "VarA" contains string valueClear(Coll1);Collect(Coll1,Filter([Table_Name], ColumnA = VarA))then you have in Coll1 the rows you need without having delegation problems on your filter and without filtering directly on the data source.try it and let me know what you realize.regards.
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 534
WarrenBelz 416 Most Valuable Professional
Valantis 306
