Announcements
Hi all
I need to have the list of users with whom the opportunity is shared (table PrincipalObjectAccess).
I think to make this with power automate, but I've not idea how to ...
Thanks in advance for any help or Idea.
Hi @diepic,
I would start with a list rows like below and a Filter query on the opportunity row id. After that you can explore the response and create a Fetch xml query which retrieves all necessary details.
Found a Dynamics thread which showed that you can also use the Users table and get related data from there. You can filter on your opportunity. Thanks to Andrew, https://community.dynamics.com/365/sales/f/dynamics-365-for-sales-forum/467207/retrieve-data-from-poa-table
Below is an example fetch xml query
<fetch> <entity name="systemuser" > <attribute name="internalemailaddress" /> <attribute name="systemuserid" /> <attribute name="fullname" /> <link-entity name="principalobjectaccess" from="principalid" to="systemuserid"> <filter> <condition attribute="objectid" operator="eq" value="@{variables('OpportunityId')}" /> </filter> </link-entity> </entity> </fetch>
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 250 Super User 2026 Season 1
Expiscornovus 222 Most Valuable Professional
Haque 174