Dropdown Dependent Values

[Ceejay26]

Hi all. I know this topic has been posted a lot of times already.

I have 2 dropdowns, Dropdown1 and Dropdown 2.

Dropdown2 values are always these: 
["Blue",
"Red",
"Green",

"Yellow",
"Cyan",
"Magenta"]

I chose the Dropdown1 value as "Primary Colors of Light",  the only available options in Dropdown2 should be "Blue", "Red", and "Green". The yellow, cyan, and magenta shouldn't be options. But if picked the "Primary Colors of Pigment" in Dropdown1, "Yellow", "Cyan", "Magenta" should be the options for Dropdown2. No blue, red, and green.

Hope the problem is clear.

Very important additional note: I am aware of making a sharepoint list as a datasource for this, but I want to shy away from that solution. One of our pain points is that there are lots of datasources for our powerapp, it's hard to track all these lists and whatnot. Also, I want to make the items for dropdowns in-house, meaning they are located in the control itself as part of a formula.

I tried putting a formula on the Default property of Dropdown1, but it is only a single item. In the end all the other options are still there.

I also tried putting this formula on the Items property of Dropdown1
[If(Dropdown1.SelectedText.Value="Primary Colors of Light","Blue"Or"Red"Or"Green")]
The returned value is False (lol, expectedly)

I am looking into creating a Collection to replicate a Sharepoint list as a datasource. If all else fails, I will just smash this company laptop I guess. Lol jk, Sharepoint list it is.

Thank you for your help. Hope I got my point across.

[v-bofeng-msft · Accepted solution]

Hi @Ceejay26 ,

You could set the dropdown2's items property to:

Switch(
    Dropdown1.SelectedText.Value,
    "Primary Colors of Light",
    ["Blue","Red","Green"],
    "Primary Colors of Pigment",
    ["Yellow","Cyan","Magenta"]
)

Best Regards,
Bof

[Ceejay26]

Thanks! Accepted it as a solution. Though do you happen to have any info about the limitation of the Switch function? I stumbled upon a site that says it only allows 25 cases. The official documentation doesn't have any info about the limits.

[stavrama]

Hey @Ceejay26 ,

I don't think that my approach is as elegant as @v-bofeng-msft but i used the following:

Assuming that you have a Sharepoint list with 2 drop down columns connect them on the form and set on primary drop down column:

Items: Choices([@'SPList'].1stDropdownColumnName)

then on 2nd dropdown that has dependencies from first set the following:

Items: If(dropdownboxname.Selected.Value = "Selection1" , ["2ndDropdownSelection1", "2ndDropdownSelection2","2ndDropdownSelection3"], dropdownname.Selected.Value = "Selection2" , ["2ndDropdownSelection4", "2ndDropdownSelection4", "2ndDropdownSelection5", "2ndDropdownSelection6"])

Update: 2nddropdownboxname.Selected