cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

How to filter a gallery with multiselect combobox

Hi all,

 

I have a sharepoint list with a Choice-column called "Practice" it has 11 different choices. I wish to filter a gallery based on the choices, but I would like to use a combobox to choose different "Practices" and sometimes more than one:

 

FilterProblem1.JPG

 

 

I have found the IsMatch() function. However, I am experiencing some issues with the function. I can write the below formula:

Practice.Value = IsMatch(cbPracticeFilter.Selected.Value, "",Contains)

 

But ideally, what I want is to filter so that ALL the choosen from cbPracticeFilter (the combobox) should be matched towards the Practice.Value.

 

How do I do that? Is there another way to do this in an easier way?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: How to filter a gallery with multiselect combobox

Try:

Filter(Datasource, Practice in cbPracticeFilter.Selected.Practice)
 
OR
If(IsEmpty(cbPracticeFilter.SelectedItems),Datasource,
Filter(Datasource, Practice in cbPracticeFilter.Selected.Practice))
 
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

1 REPLY 1
Highlighted
Community Champion
Community Champion

Re: How to filter a gallery with multiselect combobox

Try:

Filter(Datasource, Practice in cbPracticeFilter.Selected.Practice)
 
OR
If(IsEmpty(cbPracticeFilter.SelectedItems),Datasource,
Filter(Datasource, Practice in cbPracticeFilter.Selected.Practice))
 
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

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,632)