Table Expression for Adds, Updates and Deletes - SWITCH

Hi, I am trying to work out a formula so that certain users have specific read/write access to a certain table e.g. “READ_ONLY”, “UPDATES_ONLY” etc.

Basically the users are kept in two tables (separate to the table I am setting this rule up for), I tried different variations of the SWITCH formula to get it to work as well as IF and CONTAINS but couldn’t get it to work.

Basically any user contained in Table 1 should be able to “UPDATES_ONLY”, while users contained in Table 2 will be able to “ALL_CHANGES”, all other users are “READ_ONLY”.

“Users From Table 1”, “UPDATES_ONLY”,
“Users From Table 2”, “ALL_CHANGES”,

Any help would be much appreciated, thanks!


  IN(USEREMAIL(), Table 1[Email]),
  IN(USEREMAIL(), Table 2[Email]),

With appropriate substitutions for Table 1[Email] and Table 2[Email].

See also:

1 Like

Thanks Steve, that seems to have done the trick!

Much appreciated


1 Like