cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fess
Helper III
Helper III

How to find Audit trail of column changes in custom Dataverse Table

As subject indicates, could you please let me know where I can find the Audit trail? I have enabled auditing for certain columns in a custom table.

 

I'd like to connect Power BI/Automate to it for example & capture the changes.

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
rampprakash
Super User
Super User

Hello @fess,

 

You can write an Custom Connector to achieve the same, in the custom connector you can use 

 

RetrieveAttributeChangeHistoryRequest 

to retrieve records accordingly 

 

 RetrieveAttributeChangeHistoryRequest attributeChangeHistoryRequest = new RetrieveAttributeChangeHistoryRequest
 {
 Target = new EntityReference(EntitySchemaName, RecordId),
 AttributeLogicalName = AttributeSchemaName
 };

 

Link for Audit Retrieval Records Example : https://coderscollection.wordpress.com/2017/12/27/how-to-get-audit-details-from-ms-crm-c-net/

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

View solution in original post

8 REPLIES 8
cchannon
Super User
Super User

The table you are looking for is called Audit. Table documentation here including definitions for all readable and writeable columns.

fess
Helper III
Helper III

Could you please direct me to where I can find this 'Audit' table? I am looking in 'Tables' under 'Data' in PowerApps in the right environment. Thanks.

bipinshan
Super User
Super User

Hi,

 

Audti table is not listed under Data->Tables in power apps maker portal.

 

However you can access the Audit table data from Power BI using following option -

Open Power BI Desktop-> Get Data-> Power Platform->Common Data Service (legacy)->Provide URL and Login with yor credential->Select Audit table as show below

bipinshan_0-1639468413415.png

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: https://xrmdynamicscrm.wordpress.com/

rampprakash
Super User
Super User

Hello @fess,

 

1. Navigate to https://make.powerapps.com

2. select the appropriate environment

3. Expand Dataverse

4. Open the Table --> Click Setting by clicking ...(3 dots) --> Make Sure Auditing is enabled

5. Click on Fields and Make Sure AUDITING is Checked(CheckBox)

6. If any changes made in 4 or 5 Click Publish All customization

7. Then click Data and Create a Record --> Once Record Created --> Click Related --> Click Audit log.

 

There you can able to see all the messages and Field Changes.

 

Thats 🙂

 

Hope this can help https://www.youtube.com/watch?v=09V0IMGlG6Y

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

thanks. do you know of a way to pull the records that have had a change to an (auditable) column in the Dataverse table into Power Automate for email notifications? The Power Automate will be triggered when the Dataflow has finished refreshing & the Dataflow will result in some changes to the auditable column. Thanks!!

Hello @fess,

 

Please find the below link to get Auditing and sending email https://www.bythedevs.com/post/get-record-change-history-of-audited-entities-in-power-automate

 

Hope this helps 🙂

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

 

fess
Helper III
Helper III

thanks a lot. do you know if it's possible to do same after a dataflow has refreshed trigger instead? the dataflow will update multiple records & i'd like the process to work step by step instead. is it possible to get a list of records in JSON, etc format where there has been change in the auditable column from automate? thanks a lot!

rampprakash
Super User
Super User

Hello @fess,

 

You can write an Custom Connector to achieve the same, in the custom connector you can use 

 

RetrieveAttributeChangeHistoryRequest 

to retrieve records accordingly 

 

 RetrieveAttributeChangeHistoryRequest attributeChangeHistoryRequest = new RetrieveAttributeChangeHistoryRequest
 {
 Target = new EntityReference(EntitySchemaName, RecordId),
 AttributeLogicalName = AttributeSchemaName
 };

 

Link for Audit Retrieval Records Example : https://coderscollection.wordpress.com/2017/12/27/how-to-get-audit-details-from-ms-crm-c-net/

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (1,666)