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
