Security filters between two tables

Hi Community

I had two tables table1(Order), table2(Location)
In table 1 there is a column [Name] that is a Ref, in table 2 there is 2 columns [Name] that is a Ref and [email] column by which we can log in into the App.

How to filter the data of table 1 for each user that matches in table 2 the same value of column [Name] form table 1.

2 Likes

Try with the below expression in security filters

IN([Name_Column],SELECT(Table_Name[Name_Column],[email]=USEREMAIL()))

2 Likes