Help with Combo Box Switch Formula

(1) Share

Report

Posted on by Caleb62881177

789

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

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

Was this reply helpful? Yes No
Caleb62881177 789 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No