Answered

Filter Gallery with Dropdownbox

(0) Share

Report

Posted on by Robertjde

392

Hello everyone, I would like to filter my gallery with the help of the dropdown boxes and if these are empty all results from my database should be displayed.

Database = Sharpointlist

As soon as I try to use several filters, nothing is displayed.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Robertjde ,

Firstly I have to assume that the existing code you posted works as this is an unusual method of filtering with a date, but if so,

Filter( Parameter_Check_Results, If( IsBlank(Dropdownl_2.Selected.Result), true, StartsWith( Datum, Dropdownl_2.Selected.Result ) ) )

should do the job.

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.

Was this reply helpful? Yes No
Robertjde 392 on at

Like (0)

Report
Copy link

Link copied!

how can I best filter the gallery? I want to use all the dropdowns. Can you tell me that @WarrenBelz

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Robertjde ,

You did not include the name of all your drop-downs or the fields they match, so you will have to change the below code to suit. Also .Value may be different depending on the Items of the drop-down.

Filter( Parameter_Check_Results, If( IsBlank(Dropdownl_2.Selected.Result), true, StartsWith( Datum, Dropdownl_2.Selected.Result ) ) && If( IsBlank(Dropdownl.Selected.Value), true, StartsWith( Linie, Dropdownl.Selected.Value ) ) && If( IsBlank(Dropdownl_3.Selected.Value), true, StartsWith( Schicht, Dropdownl_3.Selected.Value ) ) && If( IsBlank(Dropdownl_4.Selected.Value), true, StartsWith( Status, Dropdownl_4.Selected.Value ) ) )

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.

Was this reply helpful? Yes No