Power Platform Community Forum Thread Details

Hello all,

There are various threads regarding cascading dropdowns but I cannot find the answer so far, so here we go.

I have two custom tables in dataverse: Clubs and Players.

The Players table has a lookup column, which points to Clubs (one club has many players).

Now, on a form I would like two dropdowns; lets call them dropClubs and dropPlayers

dropClubs should display all the clubs.
dropPlayers should display only the players that are linked to the selected club in dropClubs.

I have populated dropClubs by simply pointing to the Clubs table in its properties.

The problem is how do I now make dropPlayers filter based on the selected item in dropClubs. Whatever I try from various videos etc, seems to be invalid. I have also looked at the depends on, but got nowhere.

I have got it working as a test using collections, where I just create the collections via test buttons on screen. For example in the items of dropPlayers, I have used Filter(colPlayers, Club = Dropdown1.Selected.ChoiceID). However, the data should come from these dataverse tables.

I must be missing something fundamental. Should I be using collections populated from the dataverse tables? Something else?

Thanks in advance.

Categories:

Building Power Apps