How to use Power Automate flows to manage user access to SharePoint lists

Question

I have a SharePoint site with several lists each having their own set of permissions. Rather than manage reporting on the users who have permission, and changes to permissions manually in SharePoint, I would rather automate the process with Power Automate flows.

There are several steps/actions in Power Automate that I have been attempting to use:

Send an HTTP request to SharePoint This seems to be the most general approach, but I have not found a resource that lists the URI values that I need to provide to get (to collect a list of users) or post (to make changes).

Grant access to an item or a folder and Stop sharing an item or a file While these do not help with getting a list of the users, it seems that I could collect all the items in a list and use this action to update the separate permissions of each item. Unless, there is an ID value that represents the entire list?

If there is more information that would be helpful in providing an answer, please let me know.

learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/…

Skin
– Skin

2024-01-26 20:19:14 +00:00
Commented Jan 26, 2024 at 20:19 — Skin
– Skin, Commented Jan 26, 2024 at 20:19

Ganesh Sanap - MVP · Accepted Answer · 2024-01-27 14:13:34Z

Send an HTTP request to SharePoint action in Power automate flows works with SharePoint REST APIs.

Follow below Microsoft official documentations for SharePoint REST API endpoints related to permissions management:

If you understand how the SharePoint REST APIs work with SharePoint, above action gives more control to you for managing the permissions.

Check below documentations for Grant access to an item or a folder and Stop sharing an item or a file actions:

As per my knowledge, The Stop sharing an item or a file action breaks permission inheritance and removes permissions from all users and groups, except the ones with "Full Control".

Degan · Accepted Answer · 2024-02-16 18:22:39Z

To get a list of my SharePoint list users:

Send an HTTP request to SharePoint

I have used the URI:

_api/web/lists/getbytitle('NameOfMySharePointList')/Roleassignments?$expand=Member/users,RoleDefinitionBindings

Found at: Microsoft Learning I wish this was more comprehensive.

This brings back a JSON object, so I followed this request with a Parse JSON action to get an array. Using my object to have Parse JSON build a schema consistently failed.

I found this schema, that worked for me, at Getting SharePoint Permissions:

 {
    "type": "object",
    "properties": {
        "d": {
            "type": "object",
            "properties": {
                "results": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "__metadata": {
                                "type": "object",
                                "properties": {
                                    "id": {
                                        "type": "string"
                                    },
                                    "uri": {
                                        "type": "string"
                                    },
                                    "type": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Id": {
                                "type": "integer"
                            },
                            "Email": {
                                "type": "string"
                            }
                        },
                        "required": [
                            "__metadata",
                            "Id",
                            "Email"
                        ]
                    }
                }
            }
        }
    }
}

I wanted the Email Address, Display Name, and Role Name. So, I went through an Apply to Each on the array returned from Parse JSON using:

body('Parse_JSON')?['d']?['results']

For Email Address, a Compose using:

item()?['Member']?['UserPrincipalName']

For display Name, a Compose using:

item()?['Member']?['Title']

Role Name was more complex, an array of objects, so Compose on:

item()?['RoleDefinitionBindings']?['results']

Then Apply to Each on that Compose output, then another Compose on:

item()?['Name']

For my SharePoint lists, users only appear to have one role, but obviously, thus could return more than one.

To provide a user permission to use a SharePoint list:

Send an HTTP request to SharePoint

_api/web/lists/getbytitle('MySharePointListName')/Roleassignments/addroleassignment(principalid=['IDofUser'],roleDefID=['RoleID'])

To discover my RoleIDs: Get SharePoint Role Definition ID's

Very helpful in working through these issues: Microsoft Community

Collectives™ on Stack Overflow

How to use Power Automate flows to manage user access to SharePoint lists

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related