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.
A Switch should work. Something like this on your second Dropdown Items:
"Option A", ["Option 1", "Option 2"],
"Option B", ["Option 3", "Option 4"]
Then, do something similar to dropdown3
"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.
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?