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 🙂
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.