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

[fess]

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.

[cchannon]

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

[fess]

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]

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

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

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

[rampprakash]

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

[fess]

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!!

[rampprakash]

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]

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 · Accepted solution]

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

[Krishna09]

Hello @Ram7 ,

it is bit tricky for me to understand. can you explain in detail please. I am looking to get multiple records of multiple columns the history data back to database or download in excel. The environment, table and column are audit enabled.

Thank you