Dynamically manage Item security level in SharePoint | Power Automate and Power Apps

Learn how to grant access to sharepoint items to different deparments based on the department they belong to. We show how give access to View and Edit

The first 5 minutes show an introduction to the use case, solution and SharePoint items security concepts. Skip to 5:31 to see the actual solution being devleoped.
0:00 - 2:15 Use case and solution explanation
2:16 - 5:30 Items security concepts basics
5:31 - 8:33 Setting up access Matrix
8:34 - 14:45 Flow part 1: Trigger, remove access, share with creator
14:46 - 19:16 Flow part 2: Get security group(s) for related department
19:17 - 27:30 Flow part 3: Send HTTP request to share item with security group(s)
27:31 - 29:25 Create an app in Power Apps and see permissions automatically applied to records
29:26 - 29:38 Good bye

Blog referenced in the video:

https://powergi.net/blog/use-power-automate-to-grant-item-level-permissions-in-sharepoint/

Method: POST

URI: _api/web/Lists(‘list-guid’)/GetItemById(‘item-id’)/ShareObject

Body:

{
"includeAnonymousLinkInEmail":false,
"peoplePickerInput":"[{\"Key\":\"c:0t.c|tenant|{group-id}\",\"DisplayText\":\"{group-name}\",\"IsResolved\":true,\"EntityType\":\"FormsRole\",\"EntityData\":{},\"MultipleMatches\":[],\"ProviderName\":\"Tenant\",\"ProviderDisplayName\":\"Tenant\"}]",
"propagateAcl":true,
"roleValue": "role:{role-type-id}",
"sendEmail": false,
"useSimplifiedRoles": true
}

OData queries in SharePoint:
https://powergi.net/blog/ultimate-guide-to-odata-query-filters-in-sharepoint/

Follow Graciela on Linkedin: https://www.linkedin.com/in/maria-graciela-martinez-865a758a/

Follow us on Linkedin: https://www.linkedin.com/company/power-gi

Our website: https://powergi.net/

Видео Dynamically manage Item security level in SharePoint | Power Automate and Power Apps канала Graciela @ Power GI