Check if item from collection1 exist in collection 2

(0) Share

Report

Posted on by DanielPowerUser

Hi together,

I hope someone could help me with my problem:

I have two collections with some fields. Now i want to check if items in collection 1 exist in collection 2 (like a double foreach). So i want to check im ItemsFromCollection1.Title = ItemsFromCollection2.Title and if yes add the whole item from Collection1 and add a new column and fill it with the value true (string).

I started with something like that (but it dont work):

ClearCollect(Collection3; ForAll(Collection1;ForAll(Collection2;If(Collection1Title.Value in Collection2Title; AddColumns(MySharePointList; "colMatch";"True")))));;

I hope anyone could help me

Greetings

Daniel

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Cooper01 664 on at

Like (1)

Report
Copy link

Link copied!
Not exactly sure what the initial collections look like so here are the ones I initialized to show how you could get the duplicate titles. If I'm understanding you correctly, the final collection would have the two records where title is Red & Green as those titles appear in both collections.
Collection 1
ClearCollect(ItemsFromCollection1, {Title: "Red", Quantity: 2}, {Title: "Green", Quantity: 1}, {Title: "Blue", Quantity: 6})
Collection 2
ClearCollect(ItemsFromCollection2, {Title: "Red", Quantity: 8}, {Title: "Green", Quantity: 1})
Collection 3
Clear(Collection3); ForAll( ItemsFromCollection1, If( ThisRecord.Title in ItemsFromCollection2.Title, Collect( Collection3, { Record: ThisRecord, inBoth: true } ) ) );

Was this reply helpful? Yes No
FabianAckeret 969 on at

Like (1)

Report
Copy link

Link copied!
Hi @DanielPowerUser

In addition to @Cooper01 's response:
If you would like to add the value for the inBoth column to false in case it's not in both columns, you just need to complete the If() with the false parameter, like so:
ForAll( ItemsFromCollection1, If(ThisRecord.Title in ItemsFromCollection2.Title, Collect(colMatch,{Record: ThisRecord,inBoth: false}), Collect(colMatch,{Record: ThisRecord,inBoth: true}) ) )

Furthermore, if you'd like to have a new collection that only has some coluimns, including the inBoth and they should all be next to each other rather than as a table in a collection, you could use this:
ForAll( ItemsFromCollection1, If(ThisRecord.Title in ItemsFromCollection2.Title, Collect(colMatch,{Record: ThisRecord.Title,inBoth: false}), Collect(colMatch,{Record: ThisRecord.Title,inBoth: true}) ) )

Kind regards,
Fabian

Was this reply helpful? Yes No
DanielPowerUser 11 on at

Like (0)

Report
Copy link

Link copied!

Hi @Cooper01,

this is excatly what i have looked for. A big Thank you for your fast help!

Kind regards
Daniel

Was this reply helpful? Yes No