web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter a collection wi...

Power Apps

Unanswered

Filter a collection with serveral values from other collection

(0) Share

Report

Report

Posted on by esemuhdeoh

40

I am pretty sure this question already exists here, but I cannot find it...

I got a Collection A with several services ("Power Automate", "Power Apps", "Windows", etc.)

I got another collection B with a lot of entries and there is one multi-value lookup-column that can have some of these values in it.

So I want to filter the Collection B to show me all values that have one or more of the values in Collection A.

How to do it?

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @esemuhdeoh ,

Please try:

Filter( CollectionB, !IsBlank( LookUp(CollectionA,CollectionA[@ColumnNameInCollectionA]=CollectionB[@LookupColumn].Value) ) )

Best Regards,

Bof
esemuhdeoh 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately it looks like this:
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @esemuhdeoh ,

Please try:

Filter( ColMyMessages, !IsBlank( LookUp(colMyServices,colMyServices[@'{Name}'] in ColMyMessages[@Service].Value) ) )

Best Regards,

Bof

Join the conversation