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

Announcements

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,480 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

Forum hierarchy changes are complete!

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

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard