Multiple select filters of gallery

(0) Share

Report

Posted on by MiguelDeNeve

Dear powerapps community,

I am searching for a solution for a filter for my gallery.

I have the following:

A gallery of an form. The form itself is about new employees and their onboarding proces.

Some of these questions of the form were multi selects. Like 'in which department will the new employee start?'

In my gallery i can find the list of the new employees, name, department and so on.

It is easy to make a filter on name, which is just an input, the title collum.

But it seems a lot harder to make a filter on the multi select collum.

As you can see here, i have the gallery and above 2 options for filtering. A searchbox for the title (the name of the new employee) and a multi select box

Multi select.png

But if i change the formula of the gallery, where i should normally put the filter function, i get an error on the '=' sign.

But i have no idea why or how.

Is there any solution or maybe an alternative way to filter the gallery on department (Afdeling in Dutch).

Thank you in advance

Greetings,

Miguel

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MiguelDeNeve ,

If you want to search the data from Datasource based on multiple columns and display it in the gallery I recommend you to use the Search function instead of Filter. Here is the syntax of search function in power apps:
Search(Employee, SearchInput.Text, "column1", "column2", "column3")

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
MiguelDeNeve 88 on at

Like
a
(0)

Report
Copy link

Link copied!

My datasource is Sharepoint.

And what i am searching for is the following.
My form is called 'Instroom Medewerker'
The second column has the name 'Afdeling' (Department) (name in the form is 'Functie/afdeling')
The combobox above it has all the Departments in it: Choices('Instroom Medewerker'.'Functie/afdeling')

If i click in the combobox on a certain department, like 'Inbound', i would like to see all the employee lines who work in the department (or 'Afdeling' in dutch) of 'Inbound'.

If i use the search box, i have this: Search('Instroom Medewerker'; Zoekbox.Text;"Title")
(Here somehow only "Title" works, but not the real name of the Column "ThisItem.'Naam nieuwe werknemer'")

But i can not seem to extend the searchbox function. That's why i'm using this combobox with the choices of the department.

Was this reply helpful? Yes No
MiguelDeNeve 88 on at

Like
a
(0)

Report
Copy link

Link copied!

I have now done this, on my gallery:
Search(
Filter( 'Instroom Medewerker'; 'Functie/afdeling' = CbFilter.Selected.Value);
Zoekbox.Text;
"Title"
)

'Instroom Medewerker' is my formname as also the source for the gallery.
'Functie/afdeling' (Dutch for Department is the column
CbFilter is the combobox with the choice menu of all the departments.

Zoekbox is the searchbox.

But somehow it doesn't work.
Yet, i follow a step by step guide of Reza Dorrani on youtube: https://www.youtube.com/watch?v=5dSk5iOgT68

Can anybody help with what i am doing wrong?

Was this reply helpful? Yes No