Filter userprincipal name in 'multiple lines of text column' from Sharepoint List

[Anonymous]

Hello

I have a multiple lines of text column containing email ids(could be 5 or 20 or 50 or even more ids) separated by a comma.

I would like to set up a user role so that only those rows are visible to the user which contain the logged in users email id and rest of the rows are hidden. 

For example : 

User with email id "test7@test.com" should be able to view only row 2.

ID	AllEmails (Sharepoint List multiple lines of text column)	Data Details
1	test1@test.com,test2@test.com,test3@test.com,test4@test.com,test5@test.com,	Data1
2	test1@test.com,test2@test.com,test3@test.com,test4@test.com,test5@test.com,test6@test.com,test7@test.com,	Data2
3	test1@test.com,test2@test.com,test4@test.com,test5@test.com,test6@test.com,test15@test.com,test16@test.com,	Data3
4	test1@test.com,test2@test.com,test4@test.com,test5@test.com,test6@test.com,test15@test.com,test16@test.com,test17@test.com,test31@test.com,test32@test.com,test42@test.com,test43@test.com,test44@test.com,test45@test.com,test46@test.com,	Data4
5	test1@test.com,test2@test.com	Data5

[V-lianl-msft · Accepted solution]

Please try to create RLS like below:

[ID] in SELECTCOLUMNS(FILTER('Table',SEARCH(USERPRINCIPALNAME(),'Table'[AllEmails (Sharepoint List multiple lines of text column)],,0)>0),"ID",'Table'[ID])

[Anonymous]

Hi @amitchandak 

I have the reporting dashboard with bar graphs and pie charts.

And would like to limit the data visible based on which user has logged in.

I have tried the solution you have shared but i am getting the below error:

[amitchandak]

@Anonymous , use text filter

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview

or create measure

countrows(filter(Table, search("test7@test.com",Table[all email],,0) >0))

And use it with ID