Security on SharePoint list

[jamesjson]

Hi,

I am going to create a form and use PowerApps/flow to store the information (maybe somewhere like a SharePoint list). Is there a way for the requestor of the form to access their information without letting them view other people's information? This form will be used throughout the company and people will use it multiple times. I want people to only access their information. Is there a way to restrict this or another solution?

Thanks!

[mohsinkhalid]

A different approach could be utilizing CDS to store the data and then applying record level security to it. I will let the sharepoint experts speak on the SharePoint side.

[PURNA429]

Hi @jamesjson ,

There are couple of thoughts from my end :

1. Setting up permissions on list items by breaking the inheritance from parent using Power Automate.  Below is a link which has a sample of setting up item level permissions. ( Thanks to Siddarth for writing up this article )

Setting up Item level permissions in Power Automate 

2. Other option : This is just a work around to hide the data from users but cannot be considered as solution  . 

• Make the list as non-searchable ( Go to List settings and turn off search )
• Create a Personal View on the list ( as a admin/owner  ) through which admin can see all list items
• Delete all existing default list views .
• Create one more public view say for example "My Requests" with filter as "Created by=[Me]".
• Add this list on to a Site Page/Home Page as a Webpart and share it with users. So users wont have option of accessing the list ( until unless they are familiar with SP List items and their url functioning ). 

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .

Thanks

Purna

Blog