How to cycle all SharePoint folders and get access permissions for each?

(0) Share

Report

Posted on by Volt26

169

Hello,

How to cycle all SharePoint folders and get access permissions for each?

I want to do this to keep an eye on who has access to what. I will save the results in an excel file. We use local sharepoint security groups but we can't easily figure out on what folder each group has access to. The power automate I would like to create would solve this issue.

Thank you!

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

chiaraalina 1,125 on at

Like (0)

Report

How to cycle all SharePoint folders and get access permissions for each?

Hi

You’ll have to use the SharePoint REST API via Send an HTTP request to SharePoint”action.

1. Get all folders:

_api/web/lists/getbytitle('Documents')/items?$select=Id,FileLeafRef,FileRef,FSObjType&$filter=FSObjType eq 1&$top=5000

FSObjType eq 1 = Folders only

2. Parse JSON

3. Apply to each loop and inside
_api/web/GetFolderByServerRelativeUrl('@{items('Apply_to_each')?['FileRef']}')/ListItemAllFields?$select=Id,HasUniqueRoleAssignments,RoleAssignments/Member/Title,RoleAssignments/Member/PrincipalType,RoleAssignments/RoleDefinitionBindings/Name&$expand=RoleAssignments/Member,RoleAssignments/RoleDefinitionBindings

Let me know if it helps!

Was this reply helpful? Yes No
Volt26 169 on at

Like (0)

Report

How to cycle all SharePoint folders and get access permissions for each?

I got step 1 and 2 but I have no idea how to do step 3... it looks like a copy-paste code but I've never done that in power automate.. The UI requires to enter stuff without code...

Was this reply helpful? Yes No