retrieve data from POA table

(0) Share

Report

Posted on by DiePic

448

Hi all

I need to retrieve data from principalobjectaccess (POA) table, but the dataverse connector dont recognize the name of the hide table.

in most post that I've read, I find that I should use the CDS connector and CDS (current environment) connector, but I'm not able to find them in my list of connector .... maybe I mistake something with translation in italian??? ....

I'm working with dataverse db on Dynamics 365 sales.

Thanks for any help or suggestion.

Categories:

Leads or Opportunities

All responses (9)

Answers (1)

DiePic 448 on at

Like (1)

Report

RE: retrieve data from POA table

Attached the steps to obtain the users from table POA (hoping that can be usefull)

thanks a33ik
DiePic 448 on at

Like (1)

Report

RE: retrieve data from POA table

Hi a33ik and thank you for reply.

now all it's working ... the error was in the name of table:

"principalobjectaccess" instead of "principalobjectattributeaccess"

thanx for your patience.
Verified answer

a33ik 84,319 Moderator on at

Like (3)

Report
RE: retrieve data from POA table

Try to use the following FetchXml filter instead:

8 corresponds to systemuser table.You can check this as a list of object type codes for OOB entities - msdynamicscrmblog.wordpress.com/.../
DiePic 448 on at

Like (0)

Report

RE: retrieve data from POA table

Hi Bipin Kumar

as i've said, I'm new in D365, please can indicate some example or something for dummies?

thanks in advance
Suggested answer

Bipin D365 28,962 Moderator on at

Like (1)

Report

RE: retrieve data from POA table

Hi,

How about invoking below oob action from power automate

RetrieveSharedPrincipalsAndAccessRequest

See below link on how to perform bound and unbound action

learn.microsoft.com/.../bound-unbound
DiePic 448 on at

Like (0)

Report

RE: retrieve data from POA table

thanks a lot a33ik ,

how you have understood for sure, I'm new in D365Sales ...... my need is "retrive all the user whom the opportunity is shared to send them a mail".

There is the possibility to have a complete example for dummies or have a link with a step by step guide... or something similar?

Thanks for your courtesy and your patience.

p.s.

I need 2 condition in your xml similar like this, but it give me always an error on the 2nd condition:

<link-entity name="principalobjectattributeaccess" from="principalid" to="systemuserid">
<filter type="and">
<condition attribute="objectid" operator="eq" value="bd9d5e13-0ec5-4da3-8a43-3e771f05b27a" />
<condition attribute="principaltypecode" operator="eq" value="systemuser" />
</filter>
</link-entity>
DiePic 448 on at

Like (0)

Report

RE: retrieve data from POA table

Hi @Ramprakash Duraisamy

I dont want manage data in table POA, I want retrive all the user whom the opportunity is shared to send them a mail
Ram Prakash 2,285 on at

Like (0)

Report

RE: retrieve data from POA table

Hi,

May i know why you want to Retrieve POA Table ?

Note:

Please make sure when ever you are trying to Remove Values from POA Table it will break the Relationship with Table and It will remove Existing Share and Assign Access.

Its not Recommend to the update manually.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : www.youtube.com/.../UCnGNN3hdlKBOr6PXotskNLA

Follow me on Twitter : @rampprakashd

Blog : microsoftcrmtechie.blogspot.com
Suggested answer

a33ik 84,319 Moderator on at

Like (2)

Report
RE: retrieve data from POA table

Hello,

I remember your previous question so I will reply using info that you provided before. PrincipalObjectAccess table is not directly queryable but you can use it in links. Here is the query that you can use to query users with who record is shared with:

Here is how you can use that fetchxml query in Power Automate:

Obviously, you will have to replace '00000000-0000-0000-0000-000000000000' with the Id of the record.