Power Platform Community Forum Thread Details

I hoped to use the "Get Files (Properties only)", and extract the "SharedWithUsers" from the json output to create a list of files and access rights of those files in a sharepoint document library. Unfortunately it appears that the "SharedWithUsers" not only contains current users, but also include people with whom the file has been shared in the past and has had their rights removed.

Is there a better way to go about this issue, or are there some way or indicators that can be used to reduce the current list of people with access?

Any pointers are greatly appreciated.

Categories:

General topics

Hi @BeyondInfinity,

You could use REST API requests to check if files have unique roleassignments. If they do you can retrieve those with individual request via an apply to each loop. Not ideal, but it might work.

Below are a couple of screenshots of an example.

1. First few steps to retrieve the items and filter for the ones which have unique role assignments.

2. In the second part an apply to each loops through the body of the Filter Array action and for each item ID it will retrieve the existing role assignments and members.

3. With another Filter Array and a Select only the SharingLinks item is retrieved and the users property (with the list of users which this item is currently shared with).