Two Filters for one column in power apps

Question

I'm trying this but not working

Filter(
  Employees,
  StartsWith("cr_city",TextInput1.Text ) && ("cr_city"= TextInput2.Text ))

also tried with Search and without StartsWith.. but no success.. I have two search boxes for city and the Gallery should load the both results.

what's the best(easy) way for this?

Answer 1

If you want the gallery to show the employees with city in TextInput1 or TextInput2, you should use the Or operator (Or or ||), not And (And or &&):

Filter(
    Employees,
    StartsWith("cr_city", TextInput1.Text) Or ("cr_city"= TextInput2.Text ))