Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Seeing who a record is Shared With

(2) ShareShare
ReportReport
Posted on by

I have records in a table that are User level permissions and I want them to be able to share/assign them as needed.

I am wondering if there is a way to have a column in the view showing the staff that have access? Rather than going one record at a time and clicking on share to see if it has been shared.

  • 24HourDynamics Profile Picture
    24HourDynamics 2 on at
    Seeing who a record is Shared With
    If you use PowerBI it will be simple you can create a report in Power BI and embedded in Dynamics Dashboard:
     
  • CU15070746-0 Profile Picture
    CU15070746-0 on at
    Seeing who a record is Shared With
    In the SQL query for the view, you can join the table containing the staff access information with the table/view containing the records. This way, you can retrieve the necessary data for each record along with the corresponding staff members who have access.
  • Suggested answer
    HandeMV Profile Picture
    HandeMV on at
    RE: Seeing who a record is Shared With

    Hi,

    Information about Shared records and users is present in "Principle Object Access table" which you can use to retrive information. To view this table data, you can use SQL 4 CDS tool in Xrm toolbox. Then can create power bi Report or something to view everything at one place.

    Please mark verified if this resolves your issue.

  • Verified answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: Seeing who a record is Shared With

    Hi Bahalzamon,

    Unfortunately, there is currently no OOB method to do this, or you will need some customization.

    As you may be aware, information relating to the Sharing of records in Dataverse/Dynamics 365 is held in the PrincipalObjectAccess(POA) table. 

    https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/principalobjectaccess?view=dataverse-latest 

    There is one column named principalId, which stores the GUID of the user or team with which the record is shared.

    And one column named objectId, which stores the GUID of the record that has been shared

    pastedimage1684474520807v1.png

    Maybe you can create one custom column on your table, then you can retrieve POA table to get user id.

    https://powerusers.microsoft.com/t5/Using-Connectors/Dynamics-365-retrieving-record-share-recipients/td-p/1232540 

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans