I have a filter on PowerApps in the custom gallery

(0) Share

Report

Posted on by Gorilla_8

I have a filter in the powerapps gallery...

I have 3 dropdowns...

The first is called: "Regional", the second: "Grupo" and the third: "Litragem"...

So ... The first one if it is blank shows all the data in the gallery, if it selects any value, it shows the data and the second filter, and so it shows the values of the first and second filter, which I haven't been able to do so far is when the third filter is activated ...

The third filter does not show exactly the results of the 3 dropdowns ....

I want it to show the values of exactly the 3 filters if they are activated, or if not the two filters, or just the first filter.

My database is CDS

My code:

If(IsBlank(dropdownRegional)&&IsBlank(dropdownGrupo);Metas;Filter(Metas; Regional = dropdownRegional.Selected.Result && Grupo = dropdownGrupo.Selected.Result || Litragem = dropdownLitragem.Selected.Result))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Vijay Tailor 2,961 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Gorilla_8 ,

For the below mentioned Issue,

you can try with the below approach.

1st Approach -

Add 3 Toggle and set the Default value based on condition like below
if(IsBlank(Dropdown2.Selected.Value),true,false)
Do the Same for all 3.

Hide them.

Now Filter the Data based on Toggle Value.
Like First Toggle always true so Show All the Data.
if(Toggle1.Value=true && Togle2.Value=true && Togle2.Value=true,Filter(Filter code goes here),Toggle1.Value=true && Togle2.Value=true,Filter(Filter code for 2 selected Drop Down goes here),DisplayAllData)

Another Approach is you can implement all possible combination Condition for Selected DropDown.

Thanks,

Vijay

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(1)

Report
Copy link

Link copied!

@VijayTailor

I am impressed with your logic, it worked correctly here!

Thank you very much!

Was this reply helpful? Yes No