web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate List the users the opp...

Power Automate

Answered

List the users the opportunity (Dynamics 365 sales) is shared with

(0) Share

Report

Report

Posted on by DiePic

465

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.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Expiscornovus 33,767 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,767 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @diepic,

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>

Was this reply helpful? Yes No

Join the conversation