granular level row level sec for multiple users

(0) Share

Report

Posted on by Mishatandon

119

Hello commuity,

I have a column in sharepoint which is the data source and has a column 'Email id'. This column can have 1 email id of the user and can also have 10 different email id's of different users.

I want to implement row level security basis this column, so if I have 2 users / email ids in column 'Email id' then these 2 users should be only be able to see these items.

I can make it work for 1 user but not able to make it work for multiple users / email id's in the column.

If anybody can guide or help?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Mishatandon ,
Providing your email column is less than 2000 items, you can collect it and use the In Filter - so at App Onstart
Set(vUserMail,User().Email); ClearCollect( colEmails, YourEmailListName ); Set( vAllowed, !IsBlank( Lookup( colEmails, vUserMail In YourEmailFieldName, YourEmailFieldName ) ) )
The Variable vAllowed will be true if in the list, false if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Mishatandon 119 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz! I will test and come back to you.
Mishatandon 119 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked fine @WarrenBelz

Thanks!