Unanswered

Multiple Filters for one Gallery?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am struggling to add multiple filters to two different galleries. One of the galleries needs to have a dropdown, a combobox linked to a person column, and a date range function. The other needs to have two text fields and a date range function. I know how to set up the different filters with their contents (the names, dropdown choices, etc), but can't figure out how to filter a gallery with them.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (0)

Sort by

turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,
Here is an example of what you would use in your Gallery Items property.

Filter(List/Collection, File=Dropdown2.Selected.File Or Title=Dropdown2_1.Selected.Title)
File and Title are my column names. You can use And/Or between the 2.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the help; however, I think I am still doing something wrong.

This is what I have rn:
Filter('Itafos NCR List_1', ITP=ITPFilter.Selected.ITP or Name=NameFilter.Selected.Name)

and I get this error:

Also I have two questions:
How would I format this if I wanted to add a date range filter option?
Would the filters work properly if I used 'or' and they only imputed one of the filters? For example, if they only wanted to filter the name category.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(1)

Report
Copy link

Link copied!

Try capitalizing Or.
Using Or should work if they only use one.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, that cleared up the error, however the gallery is still blank and doesn't display options.

Also how do I add a date range?

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

If you just set the gallery to 'Itafos NCR List_1' does it populate?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes it does

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

Add one filter at a time and Type it in to make sure ITP try's to autopopulate. It may need Selected.Value

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have tried doing it this way but it doesn't populate anything. Also when I use selected.value it gives me an error saying my types aren't compatible for comparison.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

Nothing tries to populate? Do you have your dropdown tied to the datasource?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah I do. I know its linked, because the options show up.

Was this reply helpful? Yes No