+7

Display Dataverse audit history in a canvas app

Stephen Turner 2 years ago updated by Abdelaziz Ben 2 weeks ago 1

If audit logging is turned on for a Dataverse table you can view which fields were changed and what they were changed to or from. This can be added as a standard tab in a Model driven app. This can't be added in a canvas app, just showing the rows from the Audit table gives includes AttributeMask field that is a comma separated list of column number and data, which even the docs say not to use.

MS Docs: Retrieve the history of audited data changes - Power Apps | Microsoft Learn

Native Dataverse audit works well in model-driven apps, but it’s hard to reuse elsewhere and not practical to query directly (especially with fields like AttributeMask).

My approach is to rebuild the audit experience via a custom API + PCF, while enforcing field-level security dynamically (masking values when needed).

I’m using MongoDB mainly for scalability and cost (large/long-term audit storage), but the same pattern can absolutely work with Dataverse only — Mongo is just an optimization layer, not a requirement