Are updates allowed? Formula Issues

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”

rec

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.

This expression is malformed:

image

image

user1@mydomain.com and user2@mydomain.com are examples; replace them with something appropriate for your need.

2 Likes

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 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.

I agree! Just got to get that expression working.

1 Like