FILTER WITH 3 DROPDOWNS ON A GALLERY

(0) Share

Report

Posted on by Gorilla_8

I have a gallery that I need to filter by 3 dropdowns.

- One depends on the other to filter.

1 - The first would be the "regional" is a text-type field, and begins to filter through it

2 - The second would be "grupo" and it filters after some item is filtered by the one above (or it can be vice versa)

3 - It would be the litigation that appears only if the "regional" filter has some options selected.

This only filters depending on the "grupo" filter

Anyway, filter:

"grupo" and "regional" does not matter which one to start ... However "litragem" filter can only be filtered if the "grupo" filter is activated

Here a simple screenshoot:

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
In Item of the gallery:
Filter(Your Gallery, Regional = dropdownRegional.Selected.Value && Grupo = dropdownGrupo.Selected.Value && Litragem = DropdownLitragem.Selected.Value))

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Thanks for the reply, and how do I show all data without the filter selected?

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

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Replace the formula by :

Filter(Your Gallery, dropdownRegional.Selected.Value in Regional && dropdownGrupo.Selected.Value in Grupo && DropdownLitragem.Selected.Value in Litragem ))

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

Like
a
(0)

Report
Copy link

Link copied!

Sorry,
is not the good solution,
I'm looking for the right answer.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

I offer you this solution

I suppose that Litragem is a numeric.

IF(IsBlank(DropdownLitragem.Selected.Value),
Filter(Your Gallery, Regional = dropdownRegional.Selected.Value && Grupo = dropdownGrupo.Selected.Value),
Filter(Your Gallery, Regional = dropdownRegional.Selected.Value && Grupo = dropdownGrupo.Selected.Value && Litragem = DropdownLitragem.Selected.Value)))

In each list you add the "" value.

Was this reply helpful? Yes No