hi, instead of using specific email addresses here,
SWITCH(USEREMAIL(),
“name1@mycompany.com”, “ALL_CHANGES”,
“name2@mycompany.com”, “UPDATES_ONLY”,
“READ_ONLY”)
Can I use our email distros?
Thank you.
There’s no way built-in way to integrate a distro list, but you can use other expressions besides SWITCH() to determine table permissions.
You could export the list and save it to a row in the app, then compare the logged-in user’s USEREMAIL() with the list.
Something like this might work if you create an AppSettings
table with a single row to hold the [DistroList]
.
IFS(
USEREMAIL() = "admin@customdomain.com", "ALL_CHANGES",
IN( USEREMAIL(), INDEX(AppSettings[DistroList] ,1) ), "UPDATES_ONLY",
TRUE, "READ_ONLY"
)
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |