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.
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.
Was this reply helpful?YesNo
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.
26
Share
Report
All responses (
Answers (
