
Announcements
I'm looking to enable a scenario in Dynamics 365 where users are notified if a Case record is shared with them.
I can successfully connect to the Case record via the Dataverse connector and retrieve the Case record details, however theres no relevant output that references the shared recipients, which I assume is because the sharing action simply creates a one to many relationship with the system users themselves (or another related table)
My question is what table should I be querying to find this information and how could build a trigger from it?
I assume something along the lines of;
If Case record is modified
Check the required table for the share recipients
Grab their details and send an email
Hi @o3ag,
You could use the POA entity. It is not available in the dropdown, but you can use the principalobjectaccessset as a custom value for the table name in your Microsoft Dataverse action.
Alex Shlega has written a nice blogpost about this approach:
Below is a screenshot of a list rows action which is using that table.