Seeing who a record is Shared With

(2) Share

Report

Posted on by Bahalzamon

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.

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No
Suggested answer

HandeMV on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CU15070746-0 on at

Like (0)

Report
Copy link

Link copied!

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.

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

Was this reply helpful? Yes No
24HourDynamics 2 on at

Like (0)

Report
Copy link

Link copied!

If you use PowerBI it will be simple you can create a report in Power BI and embedded in Dynamics Dashboard:

https://crmengineer.blogspot.com/2024/11/how-to-list-shared-dynamics-records-and.html

Was this reply helpful? Yes No