Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Security on SharePoint list



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?



Resolver II
Resolver II

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.

Resolver II
Resolver II

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 .





Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,873)