Filter Gallery with Table

(0) Share

Report

Posted on by vaibhav15211

Hello,

I have a Gallery based on a source A.

I am looking to filter this Gallery for all the results coming from another Filter on SourceB.

Something like:

Filter(Source A, ContentId=Filter(SourceB,LinkedId="asda1231312fsdt4565464").ContentId)

I tried with Lookup but it returns only one row, hence getting 1 result. There could be multiple rows from Filter on Source B and I want to show corresponding results from Source A.

Currently getting incompatible types error, which I understand, but not able to figure out how to pass all the values from Source B Filter into Source A Filter.

Any suggestions?

Thanks,

Vaibhav

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vaibhav15211 ,

Please try this:
Filter(Source A, ContentId in Filter(SourceB,LinkedId="asda1231312fsdt4565464").ContentId)

Best Regards,

Wearsky
vaibhav15211 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, Thanks for the quick reply.
The Filter(Source B......) doesn't allow ".ContentId" to be appended at the end.
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vaibhav15211 ,

What's the data type of ContentId?

Best Regards,

Wearsky
vaibhav15211 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, I refreshed the Power App portal and it worked. Thanks a lot for your help.