Unanswered

Remove item from collection by comparing with another collection

(0) Share

Report

Posted on by benji-7

Hallo,

I am trying to remove items by comparing two collections. If a value is found in the one collection, it should be removed in the second collection. Here is what I have tried:

ForAll(collection1,RemoveIf(collection2,Titel=ThisRecord.Titel));

But this isn't working. I assume that with ThisRecord, I refer to current collection1 item in the forall loop. Somehow it deletes items in collection2 that are not even in collection1.

Do I miss something?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Prabhakar_S 735 Moderator on at

Like (0)

Report
Hi @benji-7 ,

Try this,

ForAll(
collection1,
RemoveIf(
collection2,
Titel = Value.Titel
)
)

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

Was this reply helpful? Yes No
benji-7 33 on at

Like (0)

Report
That gives me an error: "invalid use of '.' " and "Value isn't recognized"

I also tired this one:

ForAll(collection1,Remove(collection2,LookUp(collection2,Title=ThisRecord.Title)));

but same result.

Was this reply helpful? Yes No
Verified answer

benji-7 33 on at

Like (1)

Report
I found the solution:
ForAll(collection1 as col1,Remove(collection2,LookUp(collection2,col1.Title=ThisRecord.Title)));

Was this reply helpful? Yes No