Answered

How to filter a gallery with multiselect combobox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RickJ 58 on at

Like (0)

Report
Copy link

Link copied!

This works for a single selection in a combobox, but if multiselect is turned on and multiple are select it only returns results for the last selection, not all selections.

Any further help, I figure it would need a ForAll or something to loop through all the selections of the combobox.

Was this reply helpful? Yes No