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.
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.
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.
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.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156