Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Filter a Gallery based on combo box selected from child table

Posted on 13 Dec 2024 19:03:21 by
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!
 
  • EV-13121856-0 Profile Picture
    EV-13121856-0 on 14 Dec 2024 at 15:14:25
    Filter a Gallery based on combo box selected from child table
    Thanks for the answer, but it is not working. Power Apps error is The specified column is not accessible in this context
  • jpespena Profile Picture
    jpespena 294 on 14 Dec 2024 at 08:44:00
    Filter a Gallery based on combo box selected from child table
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,595

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,098

Leaderboard