Answered

How to filter Gallery view using three dropdown list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone,

I currently have an app using a filter for two dropdowns from two lists and a text input with the following logic and it works how it should:

If(IsBlank(State.Selected) 
Or IsBlank(City.Selected),

Filter('dwv.Location',
 'Job Key' in 
 Filter(Search('dwv.Location', TextInput1_1.Text, "Job_Name"),
 'State' = 'State'.Selected.State_name).'Job Key' 
 Or'City' = City.Selected.'City_Name'),

Filter('dwv.Location',
 'Job Key' in 
 Filter(Search('dwv.Location', TextInput1_1.Text, "Job_Name"),
 'State' = 'State'.Selected.State_name).'Job Key' 
 And 'City' = City.Selected.'City_Name'))

However, I'm trying to add in a Zip code dropdown as well, but haven't been able to connect all three within the filter function so that if:

A) All dropdowns are blank, the app displays all data entries.

B) Each individual dropdown can work both independently and together

Any help or ideas would be awesome!

Thanks,

Jacob

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

See if this comes close. Replace the names of the columns and dropdowns with your values.

With({schd: Search('dwv.Location', TextInput1_1.Text, "Job_Name") }, Filter('Job Key' In schd.'Job Key', drp_City.Selected.Result = Blank() Or City = drp_City.Selected.Result, drp_State.Selected.Result = Blank() Or State = drp_State.Selected.Result, drp_zip.Selected.Result=Blank() Or Zip = drp_zip.Selected.Result ) )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
What ended up working:
With({schd: Search('dwv.Location', TextInput1_1.Text, "Job_Name") }, Filter(dwv.Location, drp_City.Selected.Result = Blank() Or City = drp_City.Selected.Result, drp_State.Selected.Result = Blank() Or State = drp_State.Selected.Result, drp_zip.Selected.Result=Blank() Or Zip = drp_zip.Selected.Result ) )

@Drrickrypthank you for your help!

Was this reply helpful? Yes No