Hello all,
Right now, I have a simple search function that filters a table before having a person searching through. I want to add a second filter on top of that, using data from another table. The commonality between the two tables is the name of the person. How would I apply a second filter and attribute it to the initial conditions of the first filter so it filters out right?
Search(
Filter(
'Test List',
'Column A' = "Manager"
),
Filter( // This does not work
'Test Data 2',
'Status' = "Yes"
),
TextSearchBox1.Text,
"{Name}"
)
