Need to autoselect two combo box field items based on prior combo box selection

[tcaito]

I would like to have two combo box fields show a certain value when a prior combo box has a certain value chosen. 

First combo box users would select is "Type of Program" and if they select "Manual Calculation" I want to be able to have "Program Measure" and "Payout Level" combo boxes to both display by default "Manual Calculation". However, if the user selects an option not named "Manual Calculation", I would like the default value of "Program Measure" and "Payout Level" to not display and still be able to choose the appropriate selection for their program.

This is how I would like for this to display

I've been learning Power Apps when I can, unfortunately this part is stumping me. Any help is appreciated!

[mmollet]

Switch(ComboBox.Selected.Value, // this may need to be ComboBox.Selected.FieldName depending on your items

"Manual Calculation", // if the value in the combobox is this

"Manual Calculation", // set the value of this combobox to this

Parent.Default // defaults to this value if no switch case is valid

)

[tcaito]

Am I entering - Switch(ComboBox.Selected.Value,"Manual Calculation",Parent.Default) in the Default Selected Items field? New to this, I'm not quite understanding the // part, it seems like you're trying to explain that way (thank you!). 

Also would I be renaming "ComboBox" the field where I am supposed to be pulling the information from, for example 'Type of Program Value'?

[mmollet]

I apologize for the confusion! In power apps the '//' is the start of a comment. This is just used to explain something or make notes while also letting Power Apps compiler know that it isnt code to run but just a note. For example:

Filter(YourList, Status = "open") // filters the list to show only entries with open status

The green will be ran as code and the red will be seen as a comment and not be ran as code.

To answer your other question about where to put this code. This would go in the Combobox's Default property. This goes here b/c we want it to default to a certain value based on another value in the other combobox. 

In one of my apps i have the following code:

If(ClockIn_EntryTypeValue.Selected.Value = "Paid Time Off", "General")

If the user selected Paid Time Off for the Entry Type drop down then the category dropdown will use that code to default to General

[tcaito]

Thanks for the explanation. Unfortunately it doesn't seem to be working for me. For more specifics, I've labelled the combo box for "Type of Program" as 'DD Type of Program'.

I was hoping the default could be set up as an IF statement reading out like the following:

If('DD Type of Program'.SelectedItems.value="Manual Calculation","Manual Calculation",Parent.Default)

In my head I'm thinking, If the combo box has "Manual Calculation" chosen, the default field for Program Measure and Payout Level (separate fields) would default to "Manual Calculation" as the choice. It seems as it may be simple in my head, it seems power apps doesn't quite work that way, which is ok.

[mmollet]

Here is my test on my end. This is an app that is in production currently. Is this what you are wanting? 

[tcaito]

Yes, that is what I want. The only thing that's different for me is that I'd want to leave the option blank when not a "Manual Calculation". 

[mmollet]

TypeOfProgramDD.OnChange -> If(Self.Selected.Value = Blank(), Reset(Dropdown3_1);Reset(Dropdown3_2);)

TypeOfProgramDD.Items -> [Blank(),"Option 1","Option 2","Manual Calculation","Option 4","Option 5","Option 6"]

TypeOfProgramDD.Default -> Blank()

OtherDD.Default -> If(Dropdown3.Selected.Value = "Manual Calculation", "Manual Calculation", Blank())

OtherDD.Items -> [Blank(),"Option 1","Option 2","Manual Calculation","Option 4","Option 5","Option 6"]