Populating a combobox in a form based on selection in another combobox within the form

[JimboSey]

Hello,

I have a form in my App, within it are several fields, two of which are comboboxes from choices columns in my SP list.

The first combobox has several choices for 'Issue'. Now depending on the issue choice selected for example 'broken link' I want to default combobox 2 (Priority), to default to 'Urgent' if broken link is selected at combobox 1. 

Then I want to employ same to all the other choices in combobox 1 to default combobox 2 to whatever priority I tell it to on selection at combobox 1.

Thank you.

[AmDev · Accepted solution]

Hi @JimboSey 

If you have a lot of potential scenarios, you could try a Switch statement like as follows and add this to the 'Default SelectedItems' property of your combobox2:

Switch(ComboBox1.Selected.Value,

"broken link", "Urgent",

"severed link", "normal priority",

"bruised link", "low priority"

)

You can add as many switch cases here as you like.

Hope this helps

[C-Papa]

Hi, try the below in the DefaultSelectedItems

If("broken link" in ComboBox1.SelectedItems,["Priority"])

to do another just add on to the end, e.g.

If("broken link" in ComboBox1.SelectedItems,["Priority"],If("SecondSelected" in ComboBox1.SelectedItems,["SecondResult"]))

[C-Papa · Accepted solution]

@AM if you do it this way it's likely that you will need to wrap the values into square brackets [] e.g.

Switch(ComboBox1.Selected.Value,
"A", ["A"],
"B", ["B"],
"C", ["C"]
)

[JimboSey]

This worked great when adding the [] as @C-Papa suggested. Thanks both.