Assign role to user based on multiple mail column

[Ramyzo]

Greeting guys , 

i have a quick question , my client changed his extraction of data he wants to allow the user to see only offer that have access to it. 

to get this information i have a column name "access". 

The problem "access" column have a list of emails ! 

Example :   Access  = "[xxxx@xx.com] , [bbbbb@bbb.com]"  as you can see the column access could have more than 1 email. 

any trick i can use in the RLS ? 

in the previous version of the data it was simple there was only 1 mail in the column  so all i need to use the USERPRINCIPALNAME() but now the column contain more than 1 mail ! 

Thanks all in advance 

[v-lid-msft · Accepted solution]

Hi @Ramyzo ,

We can create a RLS rules using CONTAINSSTRING function to meet your requirement:

CONTAINSSTRING([Access],USERPRINCIPALNAME())

If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.

Best regards,