web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter a Gallery based...

Power Apps

Unanswered

Filter a Gallery based on combo box selected from child table

(1) Share

Report

Report

Posted on by EV-13121856-0

6

Hi all,

I have the current scenario,

Table A

A_ID	Name
1	ABC_1
2	ABC_2

Table B

B_ID	Name
3	ABC_3
4	ABC_4

Table C (The joint between A and B)

C_ID	A_ID	B_ID
1	1	3
2	1	4
3	2	3

I need to Filter a gallery that shows information from Table A, using a Combo Box with Table B list of values (multiple selection allowed).

I hope you can help me out with this since I am fairly new on Power Apps.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

jpespena 335 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Try:

Filter( 'Table A List', ID in Filter('Table C List', B_ID in Combobox.Selected.ID).A_ID )

If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!

Was this reply helpful? Yes No
EV-13121856-0 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the answer, but it is not working. Power Apps error is The specified column is not accessible in this context

Was this reply helpful? Yes No

Join the conversation