cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
m0le
Level: Powered On

Two drop down menu filter

I am trying to filter out gallery via two drop-down menus:
Capture.JPG

For a static filter like below it`s working fine:

If(
    Dropdown1.Selected.Value = "Site Services - Available" && Dropdown2.Selected.Value = "Birmingham",
    Filter(
        'Laptop List - UK',
        Office.Value = "Birmingham" && Location_x002f_Status.Value = "Retired"
    )
)

Now I got 8 cities in dropdown menu2 and 4 different status. in drop-down menu1 So I assume I need to use variables.
can someone help me how the code should look like?  For the gallery filter.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Two drop down menu filter

Hi @m0le,

You are making this far more complicated than it needs to be.  The filtering of the gallery is done at the level of the gallery and not by prefiltering the datasource  The items property of the gallery should be 

Filter('Laptop List - UK', "Office Value" = Dropdown2.Selected.Value && Location_x002f_Status.Value = Dropdown1.Selected.Value)

This should work as long as the column names are correct.  I have a question about whether Office Value is the correct column name.  The syntax seems off. 

2 REPLIES 2
Super User
Super User

Re: Two drop down menu filter

Hi @m0le,

You are making this far more complicated than it needs to be.  The filtering of the gallery is done at the level of the gallery and not by prefiltering the datasource  The items property of the gallery should be 

Filter('Laptop List - UK', "Office Value" = Dropdown2.Selected.Value && Location_x002f_Status.Value = Dropdown1.Selected.Value)

This should work as long as the column names are correct.  I have a question about whether Office Value is the correct column name.  The syntax seems off. 

m0le
Level: Powered On

Re: Two drop down menu filter

You are right thanks. I have complicated it Smiley Very Happy


Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 42 members 4,937 guests
Please welcome our newest community members: