Combo box fields change based on selection

[EMA03356]

If something is selected in my combo box, I would like another combo box to change choices based on the first selection. 

I have the following formula but am getting this error: 

If(ComboBox1_1.Selected="Cables",["Poorly Routed", "Missing Wraps", "Servo Cables Not Tightened", "Not Secured Properly"],'null'"

[LaurensM · Accepted solution]

Hi @EMA03356,

.Selected will result in a record output. You will need extend this with either .Value or .ColumnName (referring to the correct column name)

If(
    //.Value see above
    ComboBox1_1.Selected.Value = "Cables",
    ["Poorly Routed", "Missing Wraps", "Servo Cables Not Tightened", "Not Secured Properly"],
    //Added an array format and removed the single quotes
    ["null"]
)

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

[EMA03356]

If(ComboBox1_1.Selected.Value = "Cables",
["Poorly Routed", "Missing Wraps", "Servo Cables Not Tightened", "Not Secured Properly"],|| (ComboBox1_1.Selected.Value = "Cabinets",
["Poorly Routed", "Missing Wraps", "Servo Cables Not Tightened", "Not Secured Properly"],
["null"])

I'm trying to do a second one for an OR statement and it doesn't like the syntax, can you help?

[LaurensM]

Hi @EMA03356,

When having multiple possible matches for the same input value, you may want to use a Switch function instead:

Switch(
    //Combobox1_1 value as input
    ComboBox1_1.Selected.Value, 
    "Cables",
    //If it equals Cables show:
    ["Poorly Routed", "Missing Wraps", "Servo Cables Not Tightened", "Not Secured Properly"],
    "Cabinets",
    //If it euals Cabinets show
    ["Poorly Routed", "Missing Wraps", "Servo Cables Not Tightened", "Not Secured Properly"],
    //Else
    ["null"]
)

(Should the options change often, you may want to use a table to store them instead with a LookUp column towards the table of dropdown1_1)

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

[EMA03356]

Does switch work if I have up to 8 options I will be adding? 

[LaurensM]

@EMA03356 that is not an issue as long as your options are meant to be matched with ComboBox1_1.Selected.Value.

Switch(
    //Combobox1_1 value as input
    ComboBox1_1.Selected.Value, 
    "Cables",
    //If it equals Cables show:
    ["Poorly Routed", "Missing Wraps", "Servo Cables Not Tightened", "Not Secured Properly"],
    "Cabinets",
    //If it euals Cabinets show
    ["Poorly Routed", "Missing Wraps", "Servo Cables Not Tightened", "Not Secured Properly"],
    //Adding additional options is shown below
    "Option3",
    ["Opt3 value"],
    "Option4",
    ["opt4 value"],
    //Else
    ["null"]
)

[Daniel48]

@LaurensM Is there a way to edit this switch statement to reference different columns in a SharePoint from one file, instead of the static selections?

Switch(
    //Combobox1_1 value as input
    ComboBox1_1.Selected.Value, 
    "Cables",
    //If it equals Cables show:
    ------'datatable'------ 'specific coulumn1'----
    "Cabinets",
    //If it euals Cabinets show
    ------'datatable'------ 'specific coulumn2'----
    //Adding additional options is shown below
    "Option3",
    ["Opt3 value"],
    "Option4",
    ["opt4 value"],
    //Else
    ["null"]
)

something like this  instead of the static output 
I'm experimenting with a master datalist that has all the data for my dropdowns in different columns so I can dynamically retroactively change that data on the fly