cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
haleem
Level: Power Up

Set item level permission in list using Flow

Hi,

 

Let me know if we have an option in Flow to set item level permission while adding a new item in list.

 

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Byrdwatcher1966
Level: Power Up

Re: Set item level permission in list using Flow

35 REPLIES 35
Perumal
Level 10

Re: Set item level permission in list using Flow

I think, its not available. Row level permission update is not possible with Flow.

Community Support Team
Community Support Team

Re: Set item level permission in list using Flow

Hi Haleem,

 

Item level permission could be managed within SharePoint itself and cannot be modified in flow.

 

Regards,

Mona Li

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Craig_Debbo
Level: Powered On

Re: Set item level permission in list using Flow

That's too bad because updating item permissions is exactly something that flow could be used for. Example, if item is 'approved' then update permissions to read-only for creator. Flow would be perfect for this.

Oh well, without flow we're back to Sharepoint Designer/Workflow.

Re: Set item level permission in list using Flow

I totally agree. Having to use the 'old' workflows to set permissions is regressive.

 

Setting permissions should be one of the first things that was available with Flow! I understand where MS are going with this but again they miss out the most fundamental things that users need.

Megasween
Level: Powered On

Re: Set item level permission in list using Flow

I agree,  I really need this capability to use the flows 100%.

2076192
Level: Powered On

Re: Set item level permission in list using Flow

I agree 100%. Need more focus on productivity and less focus on social media. Social media has been covered, now give us real tools to get work done.

Anonymous
Not applicable

Re: Set item level permission in list using Flow

Agreed. Setting an items permissions is essential in an approval workflow. Please give us this capability!!!

Power Automate Staff liviuo
Power Automate Staff

Re: Set item level permission in list using Flow

Please use https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas to post or vote on ideas. Flow team reviews this topic and the most popular ideas are considered as candidates for new features.

abdul
Level: Powered On

Re: Set item level permission in list using Flow

One way to do it shown here,

https://www.youtube.com/watch?v=_-vvlPXv8rc

Re: Set item level permission in list using Flow

Hi Abdul,

 

Thanks for the heads up. It's a great video by Paul, I'm going to give it a go.

Did you succeed yourself in making it work?

 

C

abdul
Level: Powered On

Re: Set item level permission in list using Flow

Still working through it as there are a few things that are not clear and so I have to work them out for myself... however it is a good learning experience and well worth the effort, because the video provides good examples of using the SharePoint REST APIs from within flow... which is handy to know anyways...
Craig_Debbo
Level: Powered On

Re: Set item level permission in list using Flow

Thanks for posting this video. This will be rough for the citizen developer if they have to jump through tokens, app permissions, http POST requests to set a list element permission.

 

I hope that Microsoft is working on techniques to either simply this or to adjust the flow settings to accommodate different rights.

 

Apparently you can call Azure Functions from Powerapps/Flow so it might be easier to write the code once to get-a-token and set-list-permission and then just call this azure-function from your flow. (sorry you can see that I'm biased to write code rather than create flows Smiley Happy)

Super User
Super User

Re: Set item level permission in list using Flow

It is now possible with the help of Plumsail SharePoint (Third-party connector), which is a part of Plumsail Actions product with a fair price.

 

There is an action, called Change Permissions that gives you the ability to:

  • Grant Permissions on Site
  • Remove Permissions from Site
  • Remove All Permissions from Site
  • Restore Permissions Inheritance for Site
  • Grant Permissions on List
  • Remove Permissions from List
  • Remove All Permissions from List
  • Restore Permissions Inheritance for List
  • Grant Permissions on Item
  • Remove Permissions from Item
  • Remove All Permissions from Item
  • Restore Permissions Inheritance for Item

Here are a couple of examples of Flows:

Set item level permissions (break role inheritance and assign permissions)

Create site by custom template and grant permissions

 

SharePoint_RC
Level: Power Up

Re: Set item level permission in list using Flow

Rest calls can be made from flow, and item permission is possible from rest api.

1. Rest calls to reset permissions:

http://spsite.pro/Blog/Post/3/SharePoint-2013-REST-API-%E2%80%93-How-to-set-Unique-Permissions-%28It...

2. Integrating custom API

https://flow.microsoft.com/fr-fr/blog/integrating-custom-api/

 

Hope this will help you!!!

 

Re: Set item level permission in list using Flow

Hi SharePoint_RC

Thanks for your links.

 

I'll have a to set aside some serious time to try this out. Would prefer a more user-friendly option as time is not on my side here!

Craig_Debbo
Level: Powered On

Re: Set item level permission in list using Flow

As a platform for 'citizen developers', having to jump into REST, tokens, and the graph/SP API are not baby steps. Given that a primary user is the PowerApps developer I hope that Microsoft is still considering a dedicated collection of 'high-level' flows to support list/doc permissions.

Byrdwatcher1966
Level: Power Up

Re: Set item level permission in list using Flow

Re: Set item level permission in list using Flow

Hi Byrdwatcher,

 

Yours looks a little clearer than what I've read so far so will set some time aside to try it. As I keep saying, along with others it would be nice to see this wrapped....

 

C

 

 

vinhta
Level: Power Up

Re: Set item level permission in list using Flow

I think, its not available. Row level permission update is not possible with Flow.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,646)