web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / 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) ShareShare
ReportReport
Posted on by 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)
  • DJ_Jamba Profile Picture
    2,837 Super User 2025 Season 2 on at
    Try:

     
    Uri:
    _api/lists/getbytitle('YOUR LIST OR LIBRARY NAME')/RoleAssignments?$expand=Member/Users,RoleDefinitionBindings
     
  • MD-09011334-0 Profile Picture
    6 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard