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