Unanswered

Creating an Audit Trail for my App. SharePoint Get Item equivolent for Dataverse in Automate

(0) Share

Report

Posted on by TheStewie

I have a suite of apps that interacts with a central database. I now want to add an audit trail. for this. I've done it successfully in SharePoint Lists by using Power Automate as follows:

1. Trigger: When an item is created or modified (in central database)

2. Get Item (from central database)

3. Create Item (in audit database)

How do I do the same or similar using Dataverse Tables instead of SharePoint Lists?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Jonathan Manrique 2,687 on at

Like (0)

Report
Copy link

Link copied!

Hi @TheStewie

To do this it is the same mechanism, instead of lists you will have tables that when an element is created or modified allow you to obtain the item and you can create the record of your audit table.

What you should evaluate and if you are not duplicating an own audit functionality that dataverse brings

Manage Dataverse auditing - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
TheStewie 4 on at

Like (0)

Report
Copy link

Link copied!

While that does some of what I need, I'd prefer to do what I exampled - if somebody could give me Power Automate equivalents, that would be better

Was this reply helpful? Yes No
Jonathan Manrique 2,687 on at

Like (0)

Report
Copy link

Link copied!

Hi @TheStewie

It's exactly the same thing you did, only you have to change the sharepoint trigger to the dataverse trigger and the sharepoint actions to the Dataverse ones.

Was this reply helpful? Yes No
TheStewie 4 on at

Like (0)

Report
Copy link

Link copied!

The dataverse trigger is the same, but the actions are different, can only get items with ID - I want it to automatically know the ID like Sharepoint does. It seems there should be some extra steps to do this but I've not been able to work out what they are

Was this reply helpful? Yes No