Answered

Filtering two collections

(0) Share

Report

Posted on by GreenFrog

Hey there,

I am new to PowerApps and working on my first app. I have spent days trying to figure this out but no luck so grateful if anyone can help me.

I have two collections, collectionOne and collectionTwo

TableOne

LookupID Invoice

1 32

2 48

3 49

4 52

5 67

tableTwo

LookupID

I am trying to filter these two tables and find any matches e.g. 2 and 5 and then get the corresponding invoice number e.g. 48, 67 to store in a new collection. LookupID columns are both lookups to related dataverse tables.

Filter(

collectionOne, tableOne[@LookupID].LookupID, Value in collectionTwo[@LookupID].LookupID

)

Any suggestions where I am going wrong would be soooo helpful.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @GreenFrog ,
i have implemented a test for your use case and working fine for me give it a try:
ClearCollect( collectionOne, { LookupID: 1, Invoice: 32 }, { LookupID: 2, Invoice: 48 }, { LookupID: 3, Invoice: 49 }, { LookupID: 4, Invoice: 52 }, { LookupID: 5, Invoice: 67 } ); ClearCollect( collectionTwo, {LookupID: 2}, {LookupID: 4}, {LookupID: 5} ); ClearCollect( matchedCollection, Filter( collectionOne, LookupID in ForAll( collectionTwo, LookupID ) ) );

Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @GreenFrog

can u try this:

ClearCollect( MatchingInvoices, Filter( collectionOne, LookupID in collectionTwo.LookupID ) )

you would need to rename to your needs

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
GreenFrog 53 on at

Like
a
(0)

Report
Copy link

Link copied!

thank for looking at this for me. 😀

Was this reply helpful? Yes No