I have two collections I want to compare so I can ensure they match exactly. Here are samples of the two collections:
How can I write my ForAll( RemoveIf ) so it removes IDs 1 and 2 from Collection2 because they are missing from Collection1?
Hi @Anonymous ,
I dont't think you need the ForAll in this case. The RemoveIf already allows you to loop through a table.
Why not do?:
RemoveIf(Collection2, Not(ID in Collection1.ID))
Hi @Anonymous !
You dont need to use ForAll since RemoveIf loops through all lines anyway. Try this formula:
RemoveIf( Collection2, CountRows( Filter( Collection1, Id = Collection2[@Id] && Item = Collection2[@Item] ) ) < 1 )
I had the same problem and I tried your suggestion... worked like a charm on the first 2000 rows.
Is there a solution without the delegation warning which I can use on all the rows?
Hi @FUS !
Do you really getting delegation warnings on Collections? You shouldn´t get that since it´s stored locally on your device. Or are you using another data source? I would always recommend to use Collections when working with the data in a Powerapp so if you are using Sharepoint for instance, try to fetch all the records to Collections on OnStart. It´s also good for the overall performance of the app 🙂
Yea, I'm using Sharepoint... but added a sort and in that way can do 4000 rows.
It's still a limitation, but couldn't get any other way to work. (Made a post about it)
Good suggestion about importing the data... will take it into consideration forward 🙂
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
We are excited to announce a new way to share your ideas for Power Apps!