Filter a Gallery with 2 Dropdowns and 1 Combobox with Blanks

(0) Share

Report

Posted on by PeterParker

Hello thogeter,

i have a problem the filter a Gallery with 2 Dropdowns and 1 Combobox with Blanks.

Now, i have a running Filter with one Combobox and One Dropdown.

And i add all Collections for the dropdown an "All" for the Selection.
Exampel:

ClearCollect(Coll_Herkunft;{Value:"Alle"};Choices(tbl_Ziele.Herkunft))

The Collection is from a Sharpoint list, my problem in the Dropdown is. I cant set the default value to "All".

This is my actual code for the Filter (Gallery) withe Blanks (1 Dropdown, 1 Combobox)

I want to Change from Blanks in "All" and add a 3 Filter.

If(IsBlank(Dropdown_Status.Selected.Value); If(IsBlank(ComboBox_Bereiche.Selected.Result);tbl_Ziele;Filter(tbl_Ziele; Bereich.Value in ComboBox_Bereiche.Selected.Result));Filter(

If(IsBlank(ComboBox_Bereiche.Selected.Result);tbl_Ziele;Filter(tbl_Ziele; Bereich.Value in ComboBox_Bereiche.Selected.Result));Dropdown_Status.Selected.Value = Status.Value))

So, i have no idea.

Regards Peter

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PeterParcker ,

If it is the DefaultSelectedItems of the Combo Box you need

{Value: "Alle"}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
PeterParker 53 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz thanks.

this is my try to filter.

Filter(tbl_Ziele;Herkunft.Value = Drop_Herkunft.Selected.Value || Drop_Herkunft.Selected.Value=Blank() && Status.Value = Dropdown_Status.Selected.Value || Dropdown_Status.Selected.Value = Blank() && Bereich.Value in ComboBox_Bereiche.Selected.Result || ComboBox_Bereiche.Selected.Result =Blank() )

the filter only works if all three filter conditions are met. How can I change it so that the filter only works under one condition?

Regrads Peter
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PeterParcker ,

Just a bit of bracketing

Filter( tbl_Ziele; ( Herkunft.Value = Drop_Herkunft.Selected.Value || Drop_Herkunft.Selected.Value=Blank() ) && ( Status.Value = Dropdown_Status.Selected.Value || Dropdown_Status.Selected.Value = Blank() ) && ( Bereich.Value in ComboBox_Bereiche.Selected.Result || ComboBox_Bereiche.Selected.Result =Blank() ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps