How can I use ForAll and RemoveIf to remove items in one collection that are missing in another?

[Anonymous]

I have two collections I want to compare so I can ensure they match exactly. Here are samples of the two collections:

Collection1

ID	Item
3	C

Collection2

ID	Item
1	A
2	B
3	C

How can I write my ForAll( RemoveIf ) so it removes IDs 1 and 2 from Collection2 because they are missing from Collection1?

[Rebetcha]

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))

[pontusofsweden]

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
)

BR

Pontus

[FUS]

Thanks PontusofSweden

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?

[pontusofsweden]

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 🙂

BR

Pontus

[FUS]

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 🙂

[aayaanmayank]

@Rebetcha Can you please help me when i trying to clear the collection post uncheck it is not working properly i am using this on my uncheck property Removeif(Lever,ThisItem.SolutionImpactLever)