Notifications
Announcements
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.
The table you are looking for is called Audit. Table documentation here including definitions for all readable and writeable columns.
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.
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/
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/UCnGNN3hdlKBOr6PXotskNLABlog : 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!!
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 🙂
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!
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/
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 717 Most Valuable Professional
Michael E. Gernaey 329 Super User 2025 Season 2
Power Platform 1919 268
