Export Audit data in excel file

(2) Share

Report

Posted on by ppl666

Hello.

I have a flow which exports Audit Logs of Dataverse tables to excel file (You can find it if you follow the link https://"YourEnvironmentUrl".dynamics.com/api/data/v9.1/audits

Everything is ok. But Changed data column has json value

How can I parse it? I just need to have Logical name of changed column, old value and new value if it is not null.

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

Smehra33 27 on at

Like (0)

Report

Export Audit data in excel file

After you get the JSON data in the “Changed Data” column, add another “Parse JSON” action to parse the content of that column.
You will need to use the schema that matches the structure of the “Changed Data” JSON. You can get the schema by copying a sample of the JSON data and using the “Generate from sample” feature in the Parse JSON action.

If this helps you in anyway please mark the post as verified answered.