Combo box filtering off a list that has a lookup column

(0) Share

Report

Posted on by jimi_hendrix

Ive tried everyway i can think of so Im reaching out for some help.

I have two tables

Table A - Call it Squads/Teams

Team ---- Overall Team

Sub Team A - 123	Baseball
Sub Team B - 23048	Baseball
Sub Team A - xyz	Football

Overall Team column is a lookup to a different table (table B)

table B - Call it List of Overall Teams

Overall Team Name ---- other columns that arent being used

Baseball
Basketball
Football

For example... When Baseball is selected from a different combo box, id like to filter a 2nd combo box to just list Sub Team A - 123 and Sub Team B - 23048 but its proving to be cumbersome.

Any help would be greatly appreciated.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@jimi_hendrix -

In the Items property of your ComboBox, I would expect:

Choices([@'Squads/Teams'].'Overall Team')

And in the 2nd ComboBox, I would expect:

Filter( 'Squads/Teams', 'Overall Team'.Value = ComboBox1.Selected.Value )

If the above solution is what you have already done, what is proving to be cumbersome?
jimi_hendrix on at

Like
a
(1)

Report
Copy link

Link copied!

Probably just time for me to go home for the day.. Not sure why I didnt get to this solution.. Thanks for the quick response and solution.