Tracking Data Changes in Power Automate Using Audit Logs

Why Enable Auditing?

Auditing in Microsoft Dataverse helps in maintaining a log of all data changes. This is important for:

• Maintaining a history of data modifications

• Meeting compliance and regulatory standards

• Troubleshooting data integrity issues

Enable Auditing in Dataverse

System Settings:

• Navigate to Power Apps admin centre (https://admin.powerplatform.microsoft.com/home) > choose your environment > Settings > Audit Settings

• Under the Auditing tab, ensure start auditing is enabled

• 

Enable Table-Level Auditing:

• Select the table (e.g., Account)

• Enable “Audit changes to its data” in the table properties (Advanced Options)

  

Enable Column-Level Auditing:

• Select individual columns (e.g., Telephone1)

Enable the “Enable Auditing” option

Create Power Automate Flow to Retrieve Audit Data

1. Trigger: Use When a row is modified for the table you are tracking.

   

2. List Audit Records:

   

   Query Expression:

    objecttypecode eq 'account' and _objectid_value eq 'triggerOutputs()?['body/accountid']'
   

   • Add a List rows Dataverse action

   • Use this OData filter query:

   • Sort by createdon desc

3. Parse Audit Data:

   1. Use a Parse JSON action:

      

      Content expression:

       first(outputs('List_rows')?['body']?['value'])?['changedata']
      

      Response:

       {
         "OldValue": {
           "field1": "Old Value 1"
         },
         "NewValue": {
           "field1": "New Value 2"
         }
       }
      

4. Extract Old and New Values:

   1. Use a Compose action with below expression:

      

       outputs('Compose')?['changedAttributes'][0]['OldValue']
      

       outputs('Compose')?['changedAttributes'][0]['NewValue']
      

Conclusion

Audit logs provide a transparent trail of changes made to data within Dataverse. When combined with Power Automate, they empower users to create intelligent flows that not only respond to changes but also reference historical data. This setup is particularly valuable for quality control, approvals, and governance automation.

We hope this guide helps you understand how to retrieve old and updated data using audit logs in Power Automate. Feel free to leave a comment or reach out for further assistance.