Filtering with dropdown

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have to filter my Gallery based on the drop down

this is how i filter but it works only if i use only when i use one Dropdown.

How can I use both dropdown?

If (Dropdown2.Selected.Result = "All" And Dropdown1.Selected.Result = "ALL" ,Filter(AddColumns(Org,"helper_Org",If(Varselected in oals.Id ,"true")),helper_OrgNameLand),Filter(AddColumns(Org"helper_Org",If(Varselected in oals.Id ,"true")),helper_Org="true",'IDLand: LandName'.Value = Dropdown2.Selected.Result And kmOrg = Dropdown1.Selected.Result ))

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,740 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I am not exactly sure on your logic here, but is this what you are trying to do?

Filter( AddColumns( Org, "helper_Org", If( Varselected in oals.Id , "true", helper_OrgNameLand ) ), ( Dropdown2.Selected.Result = "All" || LandName'.Value = Dropdown2.Selected.Result ) && ( Dropdown1.Selected.Result = "ALL" || kmOrg = Dropdown1.Selected.Result ) )

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank u @WarrenBelz but it is not showing All results
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

this is filtering: If (Dropdown2.Selected.Result = "All" ,Filter(AddColumns(Org,"helper_Org",If(Varselected in oals.Id ,"true")),helper_OrgNameLand),Filter(AddColumns(Org"helper_Org",If(Varselected in oals.Id ,"true")),helper_Org="true",'IDLand: LandName'.Value = ))

And this is also working If ( Dropdown1.Selected.Result = "ALL" ,Filter(AddColumns(Org,"helper_Org",If(Varselected in oals.Id ,"true")),helper_OrgNameLand),Filter(AddColumns(Org"helper_Org",If(Varselected in oals.Id ,"true")),helper_Org="true", kmOrg = Dropdown1.Selected.Result ))

how can i use both dropdowns together?
WarrenBelz 156,740 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

What results are you expecting that are not being shown ? The item I am confused on is helper_OrgNameLand and how that fits in the first filter as it is in the filter, but is not compared with anything.

Filter( AddColumns( Org, "helper_Org", If( Varselected in oals.Id, "true" ) ), helper_OrgNameLand && helper_Org="true" && ( Dropdown2.Selected.Result = "All" || 'IDLand: LandName'.Value = Dropdown2.Selected.Result ) && ( Dropdown1.Selected.Result = "ALL" || kmOrg = Dropdown1.Selected.Result ) )

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