cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver III
Resolver III

How to filter gallery on Combo Box selection(s)

I am trying to get a combo box that may have between 0 and several selections to filter a gallery. The combo box is connected to a SharePoint choice field (radio). 

The Items property in the combo box is this: 

Distinct('SP List', ChoiceFieldName.Value).Result

DisplayFields and SearchFields are each ["Result"]

 

The Items property in my Gallery is this:

Filter('SP List', If(CountRows(ComboBox1.SelectedItems) > 0, ChoiceFieldName.Value in ShowColumns(ComboBox1.SelectedItems,"Result"), true))

There is no issue with the formula (except for a delegation warning). The combo box gets items as expected. However no filtering occurs on the list; it just shows all items regardless of what is in the combo box. Any resources or suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver III
Resolver III

Re: How to filter gallery on Combo Box selection(s)

Yikes was pointing forumla to the wrong combo box... The Items property mentioned above works: 

Filter('SP List', If(CountRows(ComboBox1.SelectedItems) > 0, ChoiceFieldName.Value in ShowColumns(ComboBox1.SelectedItems,"Result"), true))

View solution in original post

1 REPLY 1
Highlighted
Resolver III
Resolver III

Re: How to filter gallery on Combo Box selection(s)

Yikes was pointing forumla to the wrong combo box... The Items property mentioned above works: 

Filter('SP List', If(CountRows(ComboBox1.SelectedItems) > 0, ChoiceFieldName.Value in ShowColumns(ComboBox1.SelectedItems,"Result"), true))

View solution in original post

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,283)