Unanswered

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)

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
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,605 Super User 2025 Season 2 on at

Like (0)

Report
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 (0)

Report

thank for looking at this for me. 😀

Was this reply helpful? Yes No