Combined filters

(0) Share

Report

Posted on by ddlamb

Hi,

I am struggling with a quite simple requirement.

My problem is, that I have a gallery with ~300 entries and I would like to filter this gallery in a very flexible way.

Therefore I defined several selection-fields (Dropdowns, checkboxes ...) to do the filtering.

Filter(Tabelle1;
Sel_Berufsbezeichnung.Text in Berufsbezeichnung;
Sel_Frau.Selected.Value in Frau ;
Sel_Mann.Selected.Value in Mann )

My problem is, that the filtering works too exactly 🙂 and always combines all the selection fields. If I leave one field blank, the filter returns no item im my gallery, because it takes the blank selection-field and comapes it to my values in the gallery ...

Only selection fields, that are <> " " should becombined and lead to a filter!

thanks a lot - I am sure, this is way too easy ...

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
You can use an Or condition in each of your filters so that it is only applied if the value is not empty. Something along the lines of

Filter( Tabelle1; Sel_Berufsbezeichnung.Text in Berufsbezeichnung; Sel_Frau.Selected.Value = "" Or Sel_Frau.Selected.Value in Frau; Sel_Mann.Selected.Value = "" Or Sel_Mann.Selected.Value in Mann )

Was this reply helpful? Yes No
ddlamb 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Carlos,

sounds good, but this does'nt exactly what it should ...

see my example in this mini-table ... (in reality there a far more columns and selections)

All columns are always filled!

Berufbezeichnung Mann    Frau
---------------------------------
1 Dentist    easy    easy
2 Nurse    easy    light
3 Physician    light hard
4 Architect    hard    easy

Mann = easy and Frau = "" should filter 1,2 as result
Mann = easy and Frau = easy should filter 1,2,4 as result

best regards
DD

Was this reply helpful? Yes No
Verified answer

ddlamb 71 on at

Like
a
(0)

Report
Copy link

Link copied!

I found the solution - perfectly explained!

https://powerusers.microsoft.com/t5/General-Discussion/Filter-gallery-based-on-multiple-dropdowns-Data-in-Google-Sheets/m-p/74105/highlight/true#M29789

Thanks!

Was this reply helpful? Yes No