Multiple select filters of gallery

[MiguelDeNeve]

Dear powerapps community,

I'm searching for a solution for a filter on my gallery.

It uses a combobox to act as a filter multi select. Based on department, so if i would click on a certain department in the combobox, i would like to see only those department lists in the gallery.

I have the following:

1. Gallery of a form

- The form itself is about new employees and their onboarding process.

- Some of the form questions are multi selects. Like 'Which department?', 'Which role?', ...

- Datasource of the gallery is 'Instroom Medewerker'

2. Datasource

Datasource is sharepoint list.

3. Form

The form is called 'Instroom Medewerker'

What i already have

1. Searchbox (Zoekbox)

Zoekbox is the name of the searchbox

The gallery item property has the following:

Search(
Filter( 'Instroom Medewerker'; 'Functie/afdeling' = CbFilter.Selected.Value);
Zoekbox.Text;
"Title"

)

2. Combobox

The item property of the combobox has the following: 

Choices('Instroom Medewerker'.'Functie/afdeling')

CbFilter is the combobox with the choice menu of all the departments.

I have tried

I'm following a step by step guide of Reza dorrani on youtube https://www.youtube.com/watch?v=5dSk5iOgT68

See gallery1 attachment

My gallery item property has the following:

Search(
Filter( 'Instroom Medewerker'; 'Functie/afdeling' = CbFilter.Selected.Value);
Zoekbox.Text;
"Title"
)

What i am searching for/what i need

To click on the multiselect combobox, select a department, see in the gallery only the rows with that specific department.

'Instroom Medewerker' is my formname as also the source for the gallery.

'Functie/afdeling' (Dutch for Department) is the column i want to be filtered

But somehow it doesn't work.

Can anybody help with what i am doing wrong?

Greetings Miguel

[WarrenBelz · Accepted solution]

Hi @MiguelDeNeve ,

Assuming CbFilter is a multi-select combo box and 'Functie/afdeling' is a Text field, this should work

Search(
   Filter( 
      'Instroom Medewerker'; 
      'Functie/afdeling' in CbFilter.SelectedItems
   );
   Zoekbox.Text;
   "Title"
)

 If 'Functie/afdeling' is a single choice field, you need this

Search(
   Filter( 
      'Instroom Medewerker'; 
      'Functie/afdeling'.Value in CbFilter.SelectedItems
   );
   Zoekbox.Text;
   "Title"
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[MiguelDeNeve]

Thank you very much for the quick response!
The first solution does indeed work perfectly! 🙂

Now i'm gonna follow the guide further on to see if nothing is selected from the combo box, the whole list is visible.

Thank you again Warren 🙂

[WarrenBelz · Accepted solution]

@MiguelDeNeve ,'

Using the first one

Search(
   Filter( 
      'Instroom Medewerker'; 
      IsEmpty(CbFilter.SelectedItems) ||
      'Functie/afdeling' in CbFilter.SelectedItems
   );
   Zoekbox.Text;
   "Title"
)