cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shwetachettiar
Frequent Visitor

Filter second Combo Box choices based on selection in first Combo Box

Hi, 

I went through a couple of combo box related threads but couldn't find one close to my current issue or the ones I tried didn't work for me. 

 

I have two choice columns in my SharePoint list, as follows (for example):

AppTable.PNG

 

 
 

 

 

So, if I select 'Cherry' in my first combo box, the second combo box will filter with choices including the word 'Cherry', i.e. only 'Cherry Pie' and 'Cherry Smoothie' will be visible to be selected in my second combo box. 

 

I tried the following, but it didn't work: 

If("Cherry" in combobox1.selected.value, Filter(datasource,"Cherry","Combo Box 2"), Filter(datasource," ","Combo Box 2"))

 

Thank you in advance for any help with this. 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@shwetachettiar 

Put this code in the Items property of ComboBox2.

 

Filter(
    Choices(your_datasource_name.your_column_name),
    StartsWith(Value, ComboBox1.Selected.Value)
)

 

Note: I decided to use StartsWith instead of Search because the value from ComboBox1 always appeared at the start of the phrase in ComboBox2.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

2 REPLIES 2
mdevaney
Super User
Super User

@shwetachettiar 

Put this code in the Items property of ComboBox2.

 

Filter(
    Choices(your_datasource_name.your_column_name),
    StartsWith(Value, ComboBox1.Selected.Value)
)

 

Note: I decided to use StartsWith instead of Search because the value from ComboBox1 always appeared at the start of the phrase in ComboBox2.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Thank You so much, it works!!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,967)