Hello.
I want control what a user will see from some table based on another table that can define roles.
My problem is some rows from a table have a column called "Grupo" and on user control table I want limit the view of the user by the "Grupo".
I try this expression, but no sucess 😞
IN(LOOKUP(USEREMAIL(),"Cadastro de Usuarios","E-MAIL","Processos Grupo"), LIST(Processos[Grupo]))
Someone can help me plz?
Solved! Go to Solution.
Probiere:
Contains(LOOKUP(USEREMAIL(),"Cadastro de Usuarios","E-MAIL","Processos Grupo"),[Grupo])
:
Probiere:
Contains(LOOKUP(USEREMAIL(),"Cadastro de Usuarios","E-MAIL","Processos Grupo"),[Grupo])
:
OMG howwww? I swear that probaly try this! Smiles
Tks very much my friend. Works perfect!
User | Count |
---|---|
43 | |
29 | |
29 | |
14 | |
14 |