Forum Discussion

George Sharp's avatar
George Sharp
Copper Contributor
Jun 14, 2021
Solved

Sharing Sharepoint list items and item level permission

Hey there, I decided to have a go at using PowerApps to put one of the forms my school uses online. Right at the start I thought i'd customise a Sharepoint list's form rather than build entirely in ...
  • ChrisWebbTech's avatar
    Jun 14, 2021
    SharePoint permisisons are a pain when it comes to making apps and limiting permissions. This is why when they made sql connectors premium tier it made a bunch of people upset cause we used to be able to create apps and use PowerApps to handle the security since the app had admin rights to the data, but you could manage who could do what in the app.

    With SharePoint it's all based on the logged in user so it becomes difficult. I've gotten around a similar scenario here but it requires a bunch of permission modifications via Power Automate flows. So essentially you need to setup a list for collecting the form data where everyone has access too. Then move that data to another library no one has access too, then use the grant access sharepoint action to add the creator and any other users / supervisors to access the item. This way only those people and anyone with full access permissions can see the items.

    That's basically the only work around. You could use one list, and use flows, but I don't think edit is enough when utilizing item level permission setting, you have to use HTTP rest calls to somehow grant full control access to the individual item to the "other" people. It's possible just harder IMO.

Resources