Help control users data

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]))

Quatz_0-1688758187878.pngQuatz_1-1688758216354.png

Quatz_2-1688758235148.png

 

Someone can help me plz?

 

Solved Solved
0 2 100
1 ACCEPTED SOLUTION

Probiere: 

Contains(LOOKUP(USEREMAIL(),"Cadastro de Usuarios","E-MAIL","Processos Grupo"),[Grupo])

View solution in original post

2 REPLIES 2

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! 

 

Top Labels in this Space