Dear:
I am a bit complicated, as I need to limit the access of some tables according to the mail that is in a different table.
I have a table called “ASSOCIATES” where there are users that belong to different “DEPARTMENTS”. In my case, I need to limit the access to some tables to Francisca, since she belongs to the “ATTENTION” department (See the following picture).
I need her to not be able to see the data in the table “PROVEEDORES”.
I don’t know how to do it from the security filters menu.
Solved! Go to Solution.
Try:
IN(
USEREMAIL(),
SELECT(
ASOCIADOS[CORREO],
("ATENCION" = [DEPARTAMENTO])
)
)
Try:
IN(
USEREMAIL(),
SELECT(
ASOCIADOS[CORREO],
("ATENCION" = [DEPARTAMENTO])
)
)
It worked perfectly for me. Now I will understand the logic behind it so I can apply it in other cases. Thank you very much indeed
User | Count |
---|---|
41 | |
25 | |
23 | |
19 | |
15 |