Forum Discussion
RLS based on user login
i have 2 excels 1. domain, conatins the user, email, dept and company to which it belongs 2. main excel , contains the data for each dept in the companies i want to define RLS based on the fi...
Hello, Anonymous,
in your RLS settings to your RLS table, write [EMAIL]=USERPRINCIPALNAME().
Then create a new column which weill be concatening Company and Dept together (this is optional, you can use as the key any of those withour creating new one), do it in your MAIN Excel and your RLS table, then create relationshisp Many to Many but don't make it both, but RLS filters MAIN EXCEL, key column is the new one.
and then whenever you use Company or Dept, use it from the RLS tabel as dimension.
YESS this is worked perfectly. Thank you vojtechsima
Anonymous Glad, it's working, kudos appreciated. thank you