Get list of SharePoint files with unique permissions

(0) Share

Report

Posted on by Jronash

827

Hello all,

I'm looking for a way to get a list of files with unique permissions in a given SharePoint library. The same list that you would see if you went to "Library Settings" > "Permissions for this document library" and then click on the banner that says "Some items of this list may have unique permissions which are not controlled from this page. Show these items."

Does anyone know of an API endpoint that would produce this list?

Thanks.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (2)

Report
Hi @Jronash,

You could use the HasUniqueRoleAssignments property and filter on items which have a true value for that property.

Below is an example.

Btw, I tried to apply the filter directly in the REST API request, but that did not seem to work. That is why I used a filter array action afterwards.

Uri value for the Send an HTTP request to SharePoint action.

_api/web/lists/getbytitle('Documents')/items?$select=FileLeafRef,HasUniqueRoleAssignments

Expression for From field in Filter Array:

outputs('Send_an_HTTP_request_to_SharePoint')?['body']['value']

In the criteria I use:

item()['HasUniqueRoleAssignments']

is equal to true

Was this reply helpful? Yes No
Jronash 827 on at

Like (1)

Report

Thanks @Expiscornovus - this works great.

Out of curiosity, how did you know about the HasUniqueRoleAssignments attribute? I'm always looking for good documentation.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (2)

Report

Hi @Jronash,

I have worked with SharePoint since its 2003 version, so that probably helps 😜

But joking aside, some old documentation is in these kind of situations still useful. Some concepts like securing objects is still pretty similar as in older versions, ISecurableObject.HasUniqueRoleAssignments Property

Was this reply helpful? Yes No
DEAFWING 3 on at

Like (0)

Report

i was about to say the same thing - if you'v eworked on lists and libs for a while, it is common knowledge but it is documented in the api doc

Was this reply helpful? Yes No
dereinhera 2 on at

Like (0)

Report

Hi, great solution. How could I enhance it that it also show the users who have the unique permission and also show it for folders and not only files?

Best regards
Ralf

Was this reply helpful? Yes No
smorley 546 on at

Like (0)

Report

I don't want to step on anyone's toes, but SharePoint sees a folder as a document, so if you test it, and you give a folder unique permission it should show up.

Was this reply helpful? Yes No