Im trying to set an expression to limit permission for users & admin
I set the following expression:
IFS(IN(Useremail(), MAIL[MAIL CUADRILLA]),“ADDS_AND_UPDATES”, IN(Useremail(), Supervisores[Email]),“READ_ONLY”,),
,“READ_ONLY”
the problem is when i try to make an “ADD” with a [MAIL CUADRILLA] email that has “ADDS_AND_UPDATES_” allowed.
I get the following error.
idk why, maybe the expression is not compatible?
I try with a “SWITCH” expression and i receive another issue…
ie:
SWITCH(USEREMAIL(),
“user1@mydomain.com”, “UPDATES_ONLY”,
“user2@mydomain.com”, “ALL_CHANGES”,
“READ_ONLY”)
when i make the test the only rule applies is the “READ_ONLY” all the others permissions i set just getting ignore by the app.
Maybe im doing something wrong? I follow some post about this… but i cant find the solution.
Idk why expression is the best to set permissions in the “Updates allowed” section.
Solved! Go to Solution.
I agree! Just got to get that expression working.
This expression is malformed:
user1@mydomain.com
and user2@mydomain.com
are examples; replace them with something appropriate for your need.
thanks for the advice, what is the correct method to build up this expression?
IFS(IN(Useremail(), MAIL[MAIL CUADRILLA]),“ADDS_AND_UPDATES”, IN(Useremail(), Supervisores[Email]),“READ_ONLY”,),
,“READ_ONLY”
I agree! Just got to get that expression working.
i build the expression from this site:
The only way i reach to make some “filters based on useremail” is setting
IN(Useremail(), usertable[emailcolumn])
in every each “ADD” button to make the add button hide from some users.
but i think the best way is setting userroles or with “All updates allowed” but this last i didnt understand how works at this moment.}
seems like “All updates allowed” expression boxs works differently from other expression boxes.
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |