Answered

Combo box fields change based on selection

(0) Share

Report

Posted on by EMA03356

221

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'"

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
@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"] )

Was this reply helpful? Yes No
Daniel48 46 on at

Like (0)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No