Use Gmail distro list in allowing/preventing access (add, update, delete)

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"

  )
  

1 Like