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 @pwrappr01 ,
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 @pwrappr01 !
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 🙂
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.