Set item level permission in list using Flow

[haleem]

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.

[Perumal]

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

[v-monli-msft]

Hi Haleem,

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

Regards,

Mona Li

[Craig_Debbo]

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.

[cardinalpipkin]

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]

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

[2076192]

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]

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

[liviuo]

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]

One way to do it shown here,

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

[cardinalpipkin]

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]

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]

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 )

[anton-khrit]

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]

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!!!

[cardinalpipkin]

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]

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 · Accepted solution]

Hi,

I did this via Flow and wrote about it here: https://noellawlor.wordpress.com/2018/01/18/setting-sharepoint-item-list-permissions-with-flow/

[cardinalpipkin]

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]

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