Hello reader,
I'm a student that is currently working with Power Apps. I created a SQL server database with 3 different tables
TEAMS > Joins on TEAM_ID with TEAM_PLAYER
PLAYER > Joins on PLAYER_ID with TEAM_PLAYER
TEAM_PLAYER > Has the foreign keys TEAM_ID and PLAYER_ID
Within Powerapps I have 2 dropdowns that I am going to use. One to select a certain team, and another dropdown for selecting players in their connected team. So I basically want to select a team and than select players that are in that team. I checked if these 2 dropdowns can be combined in a nested dropdown, but could not find if this was possible).
Right now I working with the 'Depends on' function to get somewhere, but the problem is that I still have an extra step with setting up my 'Join'. I need to go from TEAMS(team_name, teamid) --> TEAM_PLAYER(team_ID, player_ID) --> PLAYER(player_id)
I tried a lot of different UI options and checked the internet + youtube for solutions, but the problem is that nobody wants to do multiple joins. The tables are connected to each other in SQL server with primary and foreign keys.
Can somebody give me a hint on what to do next? Thank you! 🙂
With kind regards,
Mitchel
