How to Access and Utilize Audit History for Flow in Dataverse?

(0) Share

Report

Posted on by real_gabagole

Hello Community,

Basically, my question is, where is the audit table and how to work with it? And is it even possible?

For context, I need to create a Flow that sets a field (let's call it HUMAN_CHECK) to TRUE so can make a view filtering by it, and humans can later manually go over these records and do some accounting work.

The tricky part now, is the conditions required to set HUMAN_CHECK to TRUE. Any record in the last three months that have had a specific set of accounting related fields modified, should have HUMAN_CHECK set to TRUE.

My first idea was to simply set a condition in my fetchXML to having ModifiedOn equal or greater to 3 Months in the past.
The issue here, is that this filter selects all modifications and there are just too many that are not relevant and the list the humans have to go over gets too big. There is also a specific field that is responsible for many of the modifications that are not relevant: ENDE.

I realized that the audit history tracks changes and data about which Field was modified. My Idea now was to use it so i can filter modified records where the change was NOT to the ENDE field. I searched everywhere and I can't for the life of me find out how to work with it.
I assumed there would be an audit table but I can't find it. Is there just no way to work with it with the dataverse actions? There's not much help in these docs besides a mention of API but I'm not sure about it as well.

Auditing (Audit) table/entity reference (Microsoft Dataverse) - Power Apps | Microsoft Learn

audit EntityType (Microsoft.Dynamics.CRM) | Microsoft Learn

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @real_gabagole,
You can access audit in flows by using the "Audits" table in List Rows action. The changedata property will contain the old and new values.

Here's a sample of the outputs:

{ "_objectid_value": "570f61a7-621d-418e-98bb-84b19e54c7a6", "_userid_value": "65cf1a65-8ee0-446f-b43c-a334f451f964", "versionnumber": 638317094169807400, "operation": 1, "createdon": "2023-09-30T15:08:07Z", "auditid": "36158023-a35f-ee11-9937-000d3ad04896", "changedata": "{\"changedAttributes\":[{\"logicalName\":\"organizationid\",\"oldValue\":null,\"newValue\":\"organization,23e75271-8e63-4f54-bdfc-9180bb3f5cd7\"},{\"logicalName\":\"onclickeventjavascriptparameters\",\"oldValue\":null,\"newValue\":\"[{\\\"type\\\":8,\\\"value\\\":null},{\\\"type\\\":12,\\\"value\\\":null}]\"},{\"logicalName\":\"context\",\"oldValue\":null,\"newValue\":\"1\"},{\"logicalName\":\"hidden\",\"oldValue\":null,\"newValue\":\"True\"},{\"logicalName\":\"onclickeventjavascriptfunctionname\",\"oldValue\":null,\"newValue\":\"XrmCore.Commands.Open.openNewRecord\"},{\"logicalName\":\"buttontooltiptitle\",\"oldValue\":null,\"newValue\":\"New\"},{\"logicalName\":\"statuscode\",\"oldValue\":null,\"newValue\":\"1\"},{\"logicalName\":\"visibilitytype\",\"oldValue\":null,\"newValue\":\"2\"},{\"logicalName\":\"origin\",\"oldValue\":null,\"newValue\":\"1\"},{\"logicalName\":\"buttonaccessibilitytext\",\"oldValue\":null,\"newValue\":\"New\"},{\"logicalName\":\"onclickeventtype\",\"oldValue\":null,\"newValue\":\"2\"},{\"logicalName\":\"type\",\"oldValue\":null,\"newValue\":\"0\"},{\"logicalName\":\"sequence\",\"oldValue\":null,\"newValue\":\"1000100010.0000000000\"},{\"logicalName\":\"buttonlabeltext\",\"oldValue\":null,\"newValue\":\"New\"},{\"logicalName\":\"buttontooltipdescription\",\"oldValue\":null,\"newValue\":\"Create a new {EntityLogicalNameMarker} record.\"},{\"logicalName\":\"contextentity\",\"oldValue\":null,\"newValue\":\"entity,84a5c837-6210-11e0-834f-1cc1de634cfe\"},{\"logicalName\":\"name\",\"oldValue\":null,\"newValue\":\"Mscrm.HomepageGrid.postfollow.NewRecord\"},{\"logicalName\":\"location\",\"oldValue\":null,\"newValue\":\"1\"},{\"logicalName\":\"isdisabled\",\"oldValue\":null,\"newValue\":\"False\"},{\"logicalName\":\"fonticon\",\"oldValue\":null,\"newValue\":\"$clientsvg:Add\"},{\"logicalName\":\"statecode\",\"oldValue\":null,\"newValue\":\"0\"},{\"logicalName\":\"contextvalue\",\"oldValue\":null,\"newValue\":\"postfollow\"}]}", "action": 1, "objecttypecode": "appaction", "transactionid": "5f1e9c1d-a35f-ee11-8df0-0022489333d6", "_regardingobjectid_value": null, "useradditionalinfo": null, "_callinguserid_value": null, "attributemask": "16,60,45,50,59,42,20,81,85,38,62,64,84,39,41,47,27,53,87,49,18,48" }

Hope this helps!

Was this reply helpful? Yes No
real_gabagole 16 on at

Like (0)

Report
Copy link

Link copied!

Hallo @EricRegnier ,
thank you very much for your reply! Unfortunately I had already looked there and couldn't find Audits in the list displayed by my List Rows action. My company language is German and so is the internal documentation and the language of the environment, so whenever I need to find something like this I go straight to my environment and search on the entities list (showing ALL) and try to find it by its logical name. I assumed it was either audit or audits because that's what it's called in the Microsoft audit reference, but there are no tables with that or similar logical names. I opened basically every table and checked their columns to see if I could find this audit table with no success. I'm wondering if there's anything I need to do to enable this table to be displayed in the environment or on an action in a flow. Or could it be related to the type of license or security role i have?
I saw another answer from you here Solved: Showing Audit History of each fields in Custom Ent... - Power Platform Community (microsoft.com), and if I try the API call, I get an answer (although incomplete, only the old and new value, without the user that modified the record ) so I assume it's not related to my account. Any further help would be greatly appreciated.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @real_gabagole, are you system administrator on that environment? Maybe you don't have the privileges to see the audits...

Was this reply helpful? Yes No
real_gabagole 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @EricRegnier, I'm not the system administrator but I can normally see the audits in the app as in the screenshot on my first post. I'm working together with the system administrator, and he can't access the tables as well, neither in a flow nor on the tables section in the environment.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It's normal that it's not in the table section since it's not really a table that is stored in Azure SQL like the other tables.

But you should see it in flow list, just to isolate is the system administrator also a global or power platform admin? If not, can you try to test with one of those accounts?

Was this reply helpful? Yes No
real_gabagole 16 on at

Like (0)

Report
Copy link

Link copied!

The system administrator is also a global admin

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Very weird and out of ideas. I would lodge a Microsoft support ticket at: https://admin.powerplatform.microsoft.com/support

Was this reply helpful? Yes No
real_gabagole 16 on at

Like (0)

Report
Copy link

Link copied!

I thought as well. Thank you very much forall your support @EricRegnier !

I'll lodge a support ticket as well

Was this reply helpful? Yes No