Security filters between two tables

[Christowin_Raj]

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.

[LeventK]

help.appsheet.com

Limiting Users to Their Own Data

You can use Security Filters to control which records a user can see and update.

[sunandha]

Try with the below expression in security filters

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