CurrentUserEmail

Returns the current user's email address.

Usage

CurrentUserEmail()

Example

An admin has a column of sales representative emails in a deals dataset (called [Rep Email]), and wants to implement email-based Row-Level Security (RLS) using this formula in a new column:

CurrentUserEmail() = [Rep Email]

The above only returns True when the email of the user currently viewing the data matches the value in the [Email] column, so this column can be hidden and filtered to include only True values for RLS.

Was this page helpful?

Yes No