Help with Combo Box Switch Formula

(1) Share

Report

Posted on by Caleb62881177

745

Hello Everyone,

I have two SharePoint List, two Combo Boxes and I want to concatenate the options from SPList2 based on the Options selected in SPList1.

All the Choice Columns are Multi select.

Example:

When you select Option2 & Option3 in SPList1 then with Switch formula you are able to select Option4, Option5 Option6, Option7, Option8 and Option9

I am currently using this Switch formula on the second Combo Box

Switch(ComboBox1.Selected.Value, "Name1",Choices([@'SPList2'].column_1), "Name2",Choices([@'SPList2'].column_2),"Name3",Choices([@'SPList2'].column_3))

I hope someone can help.

Categories:

Using Apps Using Formulas

All responses (3)

Answers (2)

Verified answer

DBO_DV 4,530 Super User 2025 Season 1 on at

Like (1)

Report

Help with Combo Box Switch Formula

This will just be the new name of the Column I named it Choice. This way I hoped it' clear whtas comming in there: The choice options.

You have to rename the columns, otherwise your table will have empty records.

Just test it let me know if it doesn't work.

If this helped solve your question, consider accepting it as Solution so others can find it as well. You can accept several posts as Solution.

If it helped in any other way consider giving it a like so we can keep supporting eachother.
Caleb62881177 745 on at

Like (1)

Report

Help with Combo Box Switch Formula

@DBO_DV - I am not sure what Choice after the comma.
Verified answer

DBO_DV 4,530 Super User 2025 Season 1 on at

Like (1)

Report
Help with Combo Box Switch Formula

Hey CU22080851-1,

How about you try this code in the first Combo Box in the OnChange property:

Clear(colFinalOption); ForAll( Self.SelectedItems, Collect( colFinalOption, Switch( Value, "Option1", RenameColumns(SPList2.ColumnChoice1,ColumnChoice1,Choice), "name1", RenameColumns(SPList2.ColumnChoice2,ColumnChoice2,Choice), "name2", RenameColumns(SPList2.ColumnChoice3,ColumnChoice3,Choice) ) ) )

colFinalOption is then the Datasource that you want to put into your second Combo Box.
You have to rename the columns, otherwise your table will have empty records.

If this helped solve your question, consider accepting it as Solution so others can find it as well. You can accept several posts as Solution.

If it helped in any other way consider giving it a like so we can keep supporting eachother.