Dependant drop downs

[Calumboath]

Hi, 

I have a power app which has 3 drop down menus. The second and third drop downs rely on the one before it. It links to my SharePoint but because the 3rd drop down has 3/4 options for each 2nd drop down value, the second drop down has a list of 3/4 of the same option in the drop down. Is there a way in which only 1 of the same option will, appear in the dropdown? Thanks. 

[jcfDaniel]

Hi,

A Switch should work. Something like this on your second Dropdown Items:

Switch(
FirstDropdown.SelectedText.Value,
"Option A", ["Option 1", "Option 2"],
"Option B", ["Option 3", "Option 4"]
)

Then, do something similar to dropdown3

Switch(
SecondDropdown.SelectedText.Value,
"Option C", ["Option 5", "Option 6"],
"Option D", ["Option 7", "Option 8"]
)

Maybe showing the second only when the first has a selection and the third when the second has a selection also will make you UX a bit nicer.

[Calumboath]

Thanks for your help mate much appreciated. Do I need to change the coding for my first dropdown? I currently have 'Sort(Distinct('SharePointList',Title), Result, Ascending)' - it doesn't like the switch coding the way you explained.

I am fairly new to power apps and still learning so apologies if I seem thick. If I have 4 secondary options for option A will I need to go right up to Option 4 in the brackets?

[jcfDaniel]

Hi,

Your first dropdown can be as is. You can enter as many options inside the brackets as needed.