Power Platform Community Forum Thread Details

Hi All,

Greetings,

I want to send email notifications whenever a column in a Dataverse table is modified. To achieve this, I created a Power Automate flow that triggers on updates to the Dataverse table. As part of the implementation, I added below actions and expressions to capture the changes.

While testing the flow, I noticed that modifying any record in the Dataverse table results in duplicate data being retrieved—even when different fields are updated. The audit table consistently returns the same data attributes multiple times. After investigating, I found that the audit table takes a few seconds to reflect the latest changes when a custom Dataverse table is updated. To address this, I added a 10-second delay between the trigger and the audit table query.

However, despite this adjustment, the issue persists and I continuously receiving duplicate value.

I'm attaching the image and expression of power automate which i used.

Below is the filter expression I applied.

Audit Table filter:

createdon ge @{formatDateTime(triggerOutputs()?['body/modified'],'yyyy-MM-ddTHH:mm:ssZ')} and createdon le @{formatDateTime(addSeconds(triggerOutputs()?['body/modified'],5),'yyyy-MM-ddTHH:mm:ssZ')} and operation eq 2 and objecttypecode eq 'sourcing_study_service' and _objectid_value eq @{triggerOutputs()?['body/sourcing_study_serviceid']}

Compose action after audit list row action

json(first(outputs('List_rows_for_Sourcing_Study')?['body/value']))?['changeedata']?['changedAttributes']

Could someone help me identify what I might be doing wrong, or suggest a more effective way to implement this using the available actions in Power Automate?

Thanks in advance!

Categories:

Building flows