web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to list the access...

Power Automate

Unanswered

How to list the access rights for the documents and folders in a SharePoint Document Library.

(0) Share

Report

Report

Posted on by MD-09011334-0

6

Hello, in a SharePoint Online Document Library, files and folders have been stored and in addition to the normal site access rights, some documents and folders have been shared with users and have different access rights. Is it possible to have a report or with all the folders and files in the library and the corresponding list of authorized users for an immediate and general check, or a column with the list of users or groups with whom the document has been shared?
Thank you.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try:

Uri:

_api/lists/getbytitle('YOUR LIST OR LIBRARY NAME')/RoleAssignments?$expand=Member/Users,RoleDefinitionBindings

Was this reply helpful? Yes No
MD-09011334-0 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response, DJ Jamba.

I tried your suggestion and it works well. However, in the log output, the access groups are listed but not the users with whom a folder or file has been shared. In the meantime, I found that from the 'Site Usage' menu at the bottom, there is 'Run Report' which produces a CSV file with the list of files or folders shared with specific permissions. Is it possible to generate the same report with a Power Automate flow and save everything in a SharePoint list?

Thank you.

Was this reply helpful? Yes No

Join the conversation