Customer experience | Sales, Customer Insights,...

How to get the old value and new value from audit entity using fetch xml query.

(0) Share

Report

Posted on by Rahul Rathore

How to get the old value and new value from audit entity using fetch xml query.

We are using the power automate for generate the pdf report for audit entity but we are not able to get the old value from audit using xrm.

All responses (2)

Answers (0)

Rahul Rathore 11 on at

Like (0)

Report

RE: How to get the old value and new value from audit entity using fetch xml query.

Hi Naveen,

Thanks for your reply. We are using this query to get the list from audit in Ms flow. I want the old value and new value with this query .

<fetch>

<entity name="audit" >

<attribute name="regardingobjectid" />

<attribute name="auditid" />

<attribute name="action" />

<attribute name="objectidname" />

<attribute name="createdon" />

<attribute name="objectid" />

<attribute name="attributemask" />

<attribute name="objecttypecode" />

<attribute name="userid" />

<attribute name="useradditionalinfo" />

<attribute name="useridname" />

<filter>

<condition attribute="objecttypecode" operator="eq" value="3" />

<condition attribute="createdon" operator="yesterday" />

</filter>

<link-entity name="opportunity" from="opportunityid" to="objectid" >

<attribute name="ig1_projectnumber" />

<attribute name="new_estprojectcompletion" />

<attribute name="ig1_bestsalesestimate" />

<attribute name="estimatedclosedate" />

<attribute name="ig1_salesstagenew" />

<attribute name="statecode" />

<filter>

<condition attribute="statecode" operator="eq" value="0" />

</filter>

</link-entity>

</entity>

</fetch>
Suggested answer

Naveen Ganeshe 3,393 User Group Leader on at

Like (0)

Report

RE: How to get the old value and new value from audit entity using fetch xml query.

Hello Rahul,

Please check below links:

https://www.bythedevs.com/post/get-record-change-history-of-audited-entities-in-power-automate

https://yaweriqbal.com/2021/01/01/querying-audit-history/

https://community.dynamics.com/crm/b/passiondynamics/posts/retrieve-audit-history-changes-for-a-particular-field-attribute-of-a-record