RLS for Multiple emails in a same row to see same data

[Anonymous]

Hi 
i have multiple emails in a same row, need RLS for the beow requrirement

example- apple,car,banana, ornages should see same set of data as below screenshot
                Pen,train, shop ,food should see same data when they open PBI report individually or login individually

> i have email column in only one table (from souce also there  is one table only , no joins or no relationships )

[Joe_Barry]

Hi @Anonymous 

I use

CONTAINSSTRING([Email], USERPRINCIPALNAME()) 

Joe

[weiqb · Accepted solution]

hi，you can use find function.