Power Automate SharePoint Permissions and Security - Grant, Remove, and inherit with Flow

No video

Power Automate SharePoint Permissions and Security - Grant, Remove, and inherit with Flow

Рет қаралды 30,984

3 жыл бұрын

If you use SharePoint to store content or as a data source for your Apps then you need these actions to better lockdown your content. I show how to use the easy actions and then introduce a bit of Rest API fun at the end.
Power Platform training for SharePoint people at training.power...

Пікірлер: 92

@muyiwaishola3196 3 жыл бұрын

Thanks a lot, Shane! You've always been an asset to the PowerApps community.

@ShanesCows 3 жыл бұрын

I appreciate that!

@amberschiffer3844 Жыл бұрын

Yeeeeessss SO HELPFUL. Thank you! The reset to initial permissions is a lifesaver.

@ShanesCows Жыл бұрын

Glad it helped!

@tfs9272 2 жыл бұрын

Brilliant Shane... Really appreciate what you did. Been your follower for a few years now. Keep up the good work!!!

@DanielADamico 3 жыл бұрын

Great video! Love this quick video tips format! Thanks for sharing!

@ShanesCows 3 жыл бұрын

Glad you enjoyed it!

@oembol 3 жыл бұрын

Thanks again Shane, really useful. I use unique item permissions for drop down menu's in Power Apps to create role-based views. I'm all excited now to to try and build a front end interface for this in Power Apps to manage these type of permissions.

@ShanesCows 3 жыл бұрын

Awesome. Good luck

@wendymason3263 3 жыл бұрын

Shane this is AMAZING, thank you, thank you, and thank you!

@ShanesCows 3 жыл бұрын

Happy to help Wendy

@Mx81 3 жыл бұрын

I can just repeat you: that's pretty cool! Thanks!

@ShanesCows 3 жыл бұрын

Glad you like it!

@vinodvenkatasivaprasadsing9418 3 жыл бұрын

Nice one and it helps me, better watch this video speed at .75x bit Faster

@ShanesCows 3 жыл бұрын

Thanks 👍

@albertoneto6942 3 жыл бұрын

Great content mate! You have been crucial in my learning path with powerapps, now I’m taking it another level bringing some flow into it. I haven’t find any deep dive into those sharepoint http request here on the channel, noticed that you just mentioned a advanced powerapps videos where you go by those. Where I can find them? Thanks for making this videos! 💪🏼

@ShanesCows 3 жыл бұрын

Hey Alberto - I haven't done any HTTP SharePoint videos here yet. The only place I have been brave enough to cover them was in my Advanced Class that is here. training.powerapps911.com/courses/advanced-power-apps-and-power-automate

@ramisolipe7001 3 жыл бұрын

I have already started seeing your channel. It is perfect channel . Can I ask you to make videos for teachers, that would be great.

@ShanesCows 3 жыл бұрын

Rami I try to make videos for everyone :) Can you give me ideas of what you would like to see that is teacher specific?🐶

@ramisolipe7001 3 жыл бұрын

@@ShanesCows thanks for your efforts all the time. Basically, we give assignments to students. As a teacher, we need to make sure that: 1- the student submits the assignments on time. 2- If the student didn’t submit the assignment on time, then the teacher and the student counsellor should be alarmed. 3- If the students behaved badly during the class time, thin the teacher will be able to send a report email to the concerned counsellor 4- Students are able to ask questions about the assignment, and the teacher able to answer them. 5- …. And any other creative points , Please note that each student, counsellor and teacher has an email and we use MS Teams. Sorry for all these points 🐶

@woemoejack 2 жыл бұрын

So many options to set permissions through Flow but is it possible to simply GET permissions on an item? I don't know why this seems to be so difficult to achieve. It seems like from a reporting need this would be a no brainer to be available but I don't see a way to do it.

@rayromych5534 Ай бұрын

Thanks for another useful video! Got a question though - I presume I should change Item-level Permissions settings under list Advanced Settings to "Read items that were created by the user"?

@ShanesCows Ай бұрын

You can, that is another way to help lock things down. But if someone doesn't have any access then they can't see the file regardless of that setting.

@rayromych5534 Ай бұрын

@@ShanesCows Thank you, will give it a try :)

@nicerajnikant 2 жыл бұрын

Hi Shane, I really like your video. Is it possible, in powerapps when the user clicks on the submit button gives access to the SharePoint list and after updating or inserting the record remove the SharePoint list.?

@ShanesCows 2 жыл бұрын

Did you see my video on item level security? kzfaq.info/get/bejne/rK2DgdWbnZiuk30.html I think that is what you need.

@GuadalupeMay Жыл бұрын

Thanks, this is very helpful! If I'd like to set up permissions for a file within a library, is that possible? and Could we do that to a person based on a list or excel file? (like, give access to this file, to this specific person in the same row). Thanks in advance!

@ShanesCows Жыл бұрын

This action should work on files also. Here is another video covering the same topic if that helps. kzfaq.info/get/bejne/rNF3rbhjy5anh4k.html

@thomasschaub9474 3 жыл бұрын

Awesome tip! Thanks Shane!! 👊👊

@ShanesCows 3 жыл бұрын

You bet!

@Jj-wx4vi 6 ай бұрын

Thank you so much! Can I grant permissions to a sharepoint group? Rather than individuals. I have about 3 groups of 15-30 people I need to manage the access on only their files in a shared library

@ShanesCows 6 ай бұрын

This video will show you how to access SharePoint groups. It is harder but possible Power Automate SharePoint Groups with flow kzfaq.info/get/bejne/qLielchiqMy1Y2Q.html

@Jj-wx4vi 6 ай бұрын

@@ShanesCows you absolute legend! Thank you! 🙏🏻

@jl1399 Жыл бұрын

This video is very close to what i need but i want to grant permission based on emails from another list

@CarljohanAlkstal Жыл бұрын

Hi! Thanks for the tutorial. This is what I need. However, i'm wondering if there is a way to use another column than the "ID" column to manage accessess?

@juansepowerplatform 3 жыл бұрын

Thank you Sensei. Happy new years

@ShanesCows 3 жыл бұрын

Thanks Juan! 🐶🎉

@gerardlanphear9185 Жыл бұрын

Any ideas on how to manage these unique permissions with MS Graph?

@Microsoft365inPractice 2 жыл бұрын

Hi Shane, I am really enjoying your videos, and finding them useful. Thank you. As a long time SharePoint / Designer Workflow developer I find I continue to be confused about PERMISSIONS for Flow an for PowerApps. For example, how do we set up a Flow or a PowerApps app to update a list that the user cannot not (directly) contribute to? Do you recommend using a "service account" that will "own" the Flows and Apps? Can you point me to resource than can help my understand this, please? Thank you.

@jimhoeger5232 Жыл бұрын

Shane, exellent video, as usual. I have implemented this to manage access to SharePoint documents and everything works great!. However, my employer has informed me that I am not supposed to be using the HTTP connector, and the use of this connector may soon be blocked in my environment. I have desperately looked for another way to restore the inherited rights to a SharePoint file without success. I would appreciate any suggestions.

@munkybutler1 Жыл бұрын

Hi Shane, thanks again for another great video. Is it possible with Power Automate to grant access to an entire SharePoint list (all items) to a single user?

@ShanesCows Жыл бұрын

I am pretty sure you can but you would have to call the REST API. I don't have a video on it but I am 100% sure it is possible.

@munkybutler1 Жыл бұрын

@@ShanesCows Thanks for getting back to me. I got around it by creating a SharePoint Group with access to the SharePoint list. I then created a flow using Send an HTTP request to SharePoint action to add the user to the SharePoint group. Credit to kzfaq.info/get/bejne/bs1yfrejmM7Rhok.html

@user-mo5to4gl3l Ай бұрын

hi shane! how can i use this connector but only for a file or folder and not for an item or a list? thank you! love your videos they are so useful!

@ShanesCows Ай бұрын

Files are Items so same step. Folders... I am not sure but I would approach them like an item also and if that doesn't work then ask ChatGPT 🤩

@tenisviejos 3 жыл бұрын

Thank you, Shane. These quick tips are really useful and help a lot to set dynamically all permissions needed... I guess the flow should run w/ the credentials of the list owner to change permissions, so running it from powerapps would not give the expected results... In that case, what would you recommend? trigger the flow directly from SharePoint triggers? I'm loving this quick tip format!

@ShanesCows 3 жыл бұрын

Yeah, in my head the trigger would be when an Item is created and the creator/owner of the flow would be a list owner. 😀

@AndrewCurran83 3 жыл бұрын

Excellent video Shane, thanks for these brilliant quick tips. Is it possible to do similar to control granular access to specific columns (fields) on SharePoint Lists based upon specific values?

@ShanesCows 3 жыл бұрын

I don't think it is. 😐

@IndiaZindabadh 3 жыл бұрын

Coooool Trainer...with coool Techniques..

@ShanesCows 3 жыл бұрын

Thanks! 😃

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

Many thanks for the great tutorial Shane :) I have been searching for a way with Power Automate to provide a user site permissions on sharepoint (respectively add the user to a certain group) and not only provide item permission. Do you know how I could achieve this?

@ShanesCows 2 жыл бұрын

I think you would have to use the Group API. This video doesn't show you exactly that but should get you in the ball park. kzfaq.info/get/bejne/qLielchiqMy1Y2Q.html

@jenniferwalsh9114 2 жыл бұрын

Hi, good video. Is there a way to use powerautomate to apply permissions to folders and site pages from a SharePoint list of permissions? The site is broken and if permissions are accidentally deleted, we want to reapply based on our permission list.

@manojkumarleo 2 жыл бұрын

Hi Shane, would request a video from you on auto access to the user when a new item is created. This is required when you are creating a list with people to update the entries themself you give access also to them so If we have a flow that gives access to them in a particular group then it will help more.

@ShanesCows 2 жыл бұрын

Try this video that applies that concept kzfaq.info/get/bejne/rK2DgdWbnZiuk30.html

@cthcheung2780 3 жыл бұрын

Good teaching Shane, I wonder any REST API can remove permission of specific user of a SharePoint folder? I google it, but no luck so far

@ShanesCows 3 жыл бұрын

I would think it is possible but I haven’t done it so not sure. 😑

@ciprianpopovici7532 3 жыл бұрын

Hello, i try to use this flow over a document library and a folder created automated using Powerautomate, but receive this message when i use Stop sharing an item or file- "The response is not in a JSON format". Can you help me? Thanks

@jl1399 Жыл бұрын

Can permissions be granted like this to a microsoft group?

@ShanesCows Жыл бұрын

Check out this video where I talk about using a security group and managing from the app. kzfaq.info/get/bejne/hpN4krh9tbSWcoE.html

@robertpapancsev8891 3 жыл бұрын

Hi Shane! Any idea why I got error 403 when trying to use "Stop sharing an item or folder" the same way you did? I use it for stop sharing a list item as you.

@jamesttait 3 жыл бұрын

Great video as always....I have groups based on content and want users to submit to a list for access, picking the content they want access too. problem is, I cant find where Flow will add people to a Group from a Sharepoint list. I have approvals running, so want to add this at the end. is it possible to add to a group?

@ShanesCows 3 жыл бұрын

You would have to use the rest api to do it.

@RameshKumar-kw9sc 3 жыл бұрын

How to add the users from employee type - F, P, A. So that those type of employees can access the list and its items. Instead of adding individual user name in the recipients tab.

@ShanesCows 3 жыл бұрын

Not sure. Sorry

@davidjimenez8952 3 жыл бұрын

Merry christmas 🎄🎁!

@ShanesCows 3 жыл бұрын

Merry Christmas right back at you David. Thanks! Did you see Chewy and I's holiday video? 😂 kzfaq.info/get/bejne/j8t8acydzavciWg.html

@boringuserhandle 2 жыл бұрын

Hi Shane. Great video. I am trying to achieve something similar to this. What I want is that every time a folder is created within a particular area of a sharepoint library, that it adopts a predefined set of permissions. In this case, I want to lock out a number of groups. Is this something that can be achieved with Flow? Any advice would be much appreciated!

@louiscutmore 3 жыл бұрын

Love it! Thanks!

@ShanesCows 3 жыл бұрын

You are so welcome!

@trousseauvincent3555 2 жыл бұрын

Hi Shane, great video thanks! Can we use an http request to remove a user's permission from a single sharepoint list item?

@ShanesCows 2 жыл бұрын

Yes this video shows that I am pretty sure.

@patrickvanderschoor1434 3 жыл бұрын

Great video! Is it also possible to grant access/share a complete site?

@ShanesCows 3 жыл бұрын

Not with an action but you could with the HTTP action

@jakubtracz7946 3 жыл бұрын

@@ShanesCows Hi Shane, could you please share some info more about it? I've been looking for a solution to grant access to the whole site only, beacause all the lists will be inheriting from it. Thank you in advance :)

@nikeneelan 3 жыл бұрын

Thanks for the video Shane. Is there any way to stop sharing a folder?

@ShanesCows 3 жыл бұрын

I haven't tried. What if you point it just at a folder. Does that work?

@nikeneelan 3 жыл бұрын

@@ShanesCows Thanks for the response. No, it doesn't work. I think it can be done using an HTTP request. I did not get time to try it out.

@5jxa 3 жыл бұрын

Oo thx 🙏🏼

@ShanesCows 3 жыл бұрын

Happy to help!

@yayak.9726 3 жыл бұрын

Thanks, love it, is there a way to do approval dashboard app! Like the manager when open the app will see all his pending approvals from different lists.

@ShanesCows 3 жыл бұрын

I think I talked about it in this video kzfaq.info/get/bejne/ap9_ZZtlycuzcX0.html