cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cooper33
Level 8

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
cooper33
Level 8

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
cooper33
Level 8

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 283 members 5,468 guests
Please welcome our newest community members: