Get SharePoint library permissions

[shanemeisnerdhg]

I took this over from someone else so don't ask why they did it or the headache I have will be transferred to you 😉

We have a SharePoint site that has over 4,000 Client Document Libraries, most only have a couple documents.
All Libraries have Unique permissions.  

I need to get a list of who has Full control of each Document Libraries.

Once I get that, then I plan to move the documents to a different library and break the permissions on the individual files based on who had Full control in the current library.

I have started the flow to go to the site and get all Lists and Libraries. Then inside a Apply to each, I have a Send an HTTP request to SharePoint.

The API: _api/web/lists/getByTitle('VarLibName')/RoleAssignments returns some data, but not the names that have access.

Once I get past this part and get all the documents moved with the correct permissions, I plan to build a Power app with two galleries.. One that shows them the client name that they have documents access, and then clicking on the client name will display the documents for that particular Client.

Any thoughts?

[v-bofeng-msft]

Hi @shanemeisnerdhg :

You can find the corresponding user according to the PrincipalId(GroupID) returned by 

_api/web/lists/getByTitle('VarLibName')/RoleAssignments

The Result:

Best Regards,

Bof

[shanemeisnerdhg]

@v-bofeng-msft  - Thanks for the help. unfortunately, that returns the Groups, but what I need are Individual Users.
Plus it returned some errors for me. example - It returned the group that has access to the Library:

But then also errored out on what I can only assume is because it tried to lookup the user as a group:

It seems just getting a list of who has access to a Library, and what permissions they have, isn't as easy as it should be.

I may have to revert to using ShareGate to create a report of all the libraries with permissions, store that as an excel file and use that to move the files to the new library with permissions.