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

hi, instead of using specific email addresses here,


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



  IN( USEREMAIL(), INDEX(AppSettings[DistroList] ,1) ), "UPDATES_ONLY",



1 Like