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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get Files (Properties ...
Power Automate
Unanswered

Get Files (Properties only) - SharedWithUsers

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,768 Most Valuable Professional on at

    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.

    hasuniqueroleassignments.png

     

    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).

     

    outputs_sharinglinksusers.png

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard