cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Calumboath
Helper II
Helper II

Dependant drop downs

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. 

3 REPLIES 3
jcfDaniel
Super User
Super User

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.


Regards. JD.
Calumboath
Helper II
Helper II

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
Super User
Super User

Hi,

 

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


Regards. JD.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,456)