Multiple choice dropdown select multiple items depending on another multiple choice field too

[SOL24]

Hi,

How do I make a multiple choice dropdown select several Items depending on another multiple choice field?

Example:

I have the Dropdown1 with the following values:

Planning - values

Planning - market

Planning - sales

Execution - Data

Execution - Risks

Marketing - social

Marketing - Enviroment 

I need the Dropdown # 2 called Result to show the following:

1. If in dropdown 1 select:
Planning - market           and

Marketing - social

Only show in dropdown # 2:

Planning
Marketing

[v-xiaochen-msft · Accepted solution]

Hi @SOL24 ,

According to your description, I've made a test for your reference:

1\ Add a combo box control 'ComboBox1' and set its Items property to:

["Planning - values","Planning - market","Planning - sales","Execution - Data","Execution - Risks","Marketing - social","Marketing - Enviroment"]

Set 'ComboBox1' 's Onchange property to:

ClearCollect(Test,{Value:""});Clear(Test);If(Or("Planning - values" in ComboBox1.SelectedItems.Value,"Planning - market" in ComboBox1.SelectedItems.Value,"Planning - sales" in ComboBox1.SelectedItems.Value),Collect(Test,{Value:"Planning"}));If(Or("Execution - Data" in ComboBox1.SelectedItems.Value,"Execution - Risks" in ComboBox1.SelectedItems.Value),Collect(Test,{Value:"Execution"}));If(Or("Marketing - social" in ComboBox1.SelectedItems.Value,"Marketing - Enviroment" in ComboBox1.SelectedItems.Value),Collect(Test,{Value:"Marketing"}));Reset(ComboBox2)

2\ Add a combo box control 'ComboBox2' and set its Items property to:

["Planning","Execution","Marketing"]

Set 'ComboBox2' 's DefaultSelectedItems property to:

Test

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.