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 |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |