SharePoint Permissions with Power Automate

Рет қаралды 19,369

Күн бұрын

This video will show you how you can manage SharePoint list /library permissions using Power Automate.
You will learn:
00:00 Introduction
02:28 Break Role Inheritance on SharePoint List or Library
09:24 Break Role Inheritance on a List item, Folder, or file
13:30 Grant permission on Folder, item, or file
18:09 Reset List or library permission ( Inherit permission from Parent)
Thank You

Пікірлер: 52

@davidc9652 3 жыл бұрын

Thank you, Deepak. You explain things very clearly. Can't wait to try this.

@DeepakShrivastava 3 жыл бұрын

So nice of you. as always 😀

@DanielADamico 3 жыл бұрын

Awesome video! Thanks for sharing!

@DeepakShrivastava 3 жыл бұрын

Thanks for watching!

@seegeat Жыл бұрын

I enjoy your contents, deepak, thank you

@arlypunag9706 2 жыл бұрын

Thanks for explaining this on a noob level like me. Now I can try this on my flow in SP. New subscriber here btw. More power to you Deepak!

@DeepakShrivastava 2 жыл бұрын

Thanks for the sub and watching.

@AprilDunnam 3 жыл бұрын

Interesting intro song choice 🙂

@DeepakShrivastava 3 жыл бұрын

very unique, isn't it 😆 also, the choice of experts😉

@sreekanthbelle4522 2 жыл бұрын

thankyou deepak for this great lecture also pls upload more videos on power automate

@DeepakShrivastava 2 жыл бұрын

Thank you 🙏🏻

@shwetambarasingh 5 ай бұрын

Hi Deepak, very well explained video. I am trying to create a view on SharePoint library to see who (SharePoint groups) has the permissions. I already have the SharePoint Groups created where different group of people have different permissions level- read/ write. I am trying to create a flow so to retrieve this in a column on SharePoint

@jaspreetsingharora7070 9 ай бұрын

Could you please provide the links for uri and header value. I was trying your flow but I have to type all of that which could lead to errors. Amazing flow. Thanks.

@aaaaa601 10 ай бұрын

Hello , can a user add an item on a folder , with folder with read Only, ? Ths

@DeepakShrivastava 10 ай бұрын

If folder is read only and item inside, it is inheriting the permissions you won't be able to add.

@boniercharline7438 2 жыл бұрын

Hello, I am looking for advice: I have given access to a folder to the person who fills in a form. However, when I go into the documents of my PS I have access to this file myself. How can I give access only to the person who fills in the form and so that no one else can access it? Is it possible to use this technique (Break Role inheritanceon a folder) following the creation of a file ?

@pythonblac130 Жыл бұрын

damn, had to stop halfway cause eventhough this seems to be the only video on the internet that's straight forwards, i just can't read the things you keep pasting, is it possible to share file of the various commands that you pasted like someone else asked earlier? i've spent more time trying to figure those out than the actualy length of the video

@Ychhenghak 2 жыл бұрын

Can help if I want to use sharepoint list to assign tasks to my team; however, i don't want them to access all data in the list. Is there anyway to assign permission to only specific person when task is assigned to them? So that everyone can only view and edit their tasks

@javo5507 2 жыл бұрын

Hi Deepak! In my scenario, each row has a field with a mail address. Any idea how could be the flow to let that user edit and see only his/her list items?. I guess that "Apply to each" action then inside a "Grant access to an item or folder" action and picking the mail field as ID in order to assign the permissions dynamically, but not clear how.. Please do you have any idea or suggestion?, if could you kindly detail it a bit, it would be great. Thank you for sharing knowledge Deepak!

@s.b.9037 2 жыл бұрын

Many thanks Deepak! Do you also know a way how to provide site permissions to users (for the whole sharepoint site) using power automate?

@DeepakShrivastava 2 жыл бұрын

Thanks for watching. you can use following rest api : /_api/web/roleassignments/addroleassignment(principalid=, roledefid=1073741827)

@romanlukas7898 2 жыл бұрын

Thank you so much, your solution is great)

@DeepakShrivastava 2 жыл бұрын

Thank You!

@antoniocosta9335 2 жыл бұрын

Hi Deepak. Great video and thank you for sharing ways to automate processes. Is it possible to remove and apply permissions to existing subfolders for specific access groups. I have 1000+ main folders and 3 subfolders within each main folder. I need to provide each subfolder to a specific group of users but they cannot see the other 2 subfolders. I know it can be done manually but that will take me forever to do. Hoping power automate can perform the task without me manually adding the groups to each subfolder.

@AMindGame 2 жыл бұрын

Can you add a list of the commandes uses in the descriptions?

@danielrumbak2530 3 жыл бұрын

Hi Deepak, thank you for making this video available. Very important information here. Is there documentation that give more commands and information on the Sharepoint API? For instance- revoking a permission to an item and declaring a record? Thank you again.

@DeepakShrivastava 3 жыл бұрын

Thanks for watching. Check this link - docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/sharepoint-net-server-csom-jsom-and-rest-api-index It

@boldpurevdorj72 2 жыл бұрын

Hello Deepak, Can you show me how to set item level permissions based on column value? i.e if I have column "Manager" which is person or group type. And when I choose the Manager on this column so only that mentioned person can see that list item.

@DeepakShrivastava 2 жыл бұрын

You can use the same approach as I mentioned in my video. Just add another condition before you set permission to check the column value.

@gunasekaran4288 2 жыл бұрын

@ Deepak how to reach you to get clarfication.

@roya2045 3 жыл бұрын

Hi Deepak I have a query, I have Office 365 Business basic & Business Standard licenses. I wanted to know does share point require development like its done in web development. I am completely new to this concept but I have seen some organizations using intranet websites, is this developed in share point? & does this require back end database. The share point app that i have in my Office 365 is online when I open that its plain without much data & content. Kindly clear my doubt its a request

@DeepakShrivastava 3 жыл бұрын

For SharePoint online you don’t need any backend database to setup a intranet until you want to create a separate data store. For any SharePoint site you can SharePoint lists and library to store data.

@strategik365 2 жыл бұрын

Nice video - thanks

@DeepakShrivastava 2 жыл бұрын

Glad you enjoyed it

@mad-max-music- 2 жыл бұрын

Hello Deepak, Such a great video. explained very well. Could you please let us know, how to share to the SharePoint Groups with Contribute/Custom created permission levels.

@DeepakShrivastava 2 жыл бұрын

Thanks for watching. You can use this rest api to add a group to item with contribute permission: _api/lists/getByTitle('LISTNAME')/items()/roleAssignments/addroleassignment(principalId=, roledefId=1073741827)

@GrandeSalva 2 жыл бұрын

Hi. Is it possible to assign permission to users not present in that channel/site?

@DeepakShrivastava 2 жыл бұрын

Yes you can. using the same logic.

@kmuralikrishna1582 2 жыл бұрын

Really appreciate bro... Can you assist on my query please First of all I want to check document library is inherits from its site or does the document library has its own unique permission.. I want to check it's status .. Assistance please

@DeepakShrivastava 2 жыл бұрын

Thanks you. You can use _api/Web/Lists('')/RoleAssignments API to get al list permissions

@kmuralikrishna1582 2 жыл бұрын

@@DeepakShrivastava thank you do we have any creat log file in powerautomate facility ... Like in powershell I would like to write and create list name and list hasuniquepermission status. Thank you

@GamingisourDestiny 10 ай бұрын

Hi deepak, great video by the way. But i wanted to know if it's possible to break the inheritance for Owners too?

@DeepakShrivastava 10 ай бұрын

You should be able to but just remember if you change permission for Owner, they won't be able to go back and access the item.

@GamingisourDestiny 10 ай бұрын

@@DeepakShrivastava Currently I'm trying to break the inheritance for Sharepoint list item to view only but i'm not able to achieve that for owners. For other user it's working fine but not for Owners. So if possible can you make a video regarding this or give a work around on how i can achieve view only access for owners also. Thanks.

@DeepakShrivastava 10 ай бұрын

@GamingisourDestiny I would add it to my list . Was out for a while now back so you will find some videos on this topic

@GamingisourDestiny 10 ай бұрын

@@DeepakShrivastava If possible can you make ASAP. I know i'm being needy here but It's because i'm really desperate here. As i've a deadline here and i don't know what needs to be done.🥲

@kunalpardhi496 2 жыл бұрын

can you tell me how to BREAK INHERITANCE IN FOLDERS SUBFOLDERS AND ITS FILES.

@DeepakShrivastava 2 жыл бұрын

To break permission on a particular folder , you should use following API - _api/web/GetFolderByServerRelativeUrl('/Document Library Title/FolderName')

@mad-max-music- 2 жыл бұрын

in the URI u can pass the folder ID as manually