Power Automate Delete Trigger - Fetch deleted record attributes value

[AdelSabic]

If you are using Power Automate Flow with MS Dataverse Delete trigger and trying to find a way to retrieve attributes value from a deleted record, you are in the right place!

ISSUE DESCRIPTION

MS Dataverse Delete trigger is triggered post action. That means that record values are already missing from the database when trigger is triggered. Therefore, if you want to reuse some value that was part of that record, you will not be able to.

HOW TO DO IT

REQUIREMENTS

• Audit needs to be enabled globally in environment
• Audit need to be enabled on entity you are targeting

IMPLEMENTATION

• You need to get last Audit record related to deleted record.
  • OData example: /audits?$filter=_objectid_value eq '{{ DELETED_RECORD_ID }}'&$orderby=createdon desc&$top=1
• This call will return Audit record with changedata attribute
• changedata value is stringified JSON object which will contain changedAttributes array
• Parse this JSON object and you'll get last existed values in oldValue object key value of changedAttributes array

Hope this helps.
KUDOS to @zdeneksrejber

[MANEnterprise-Joseph]

hello, thanks for this helpful guide.
Quick question, how can I use the "OData example: /audits?$filter=_objectid_value eq '{{ DELETED_RECORD_ID }}'&$orderby=createdon desc&$top=1" in my flow if my trigger is the deletion of the Dataverse record ('When a row is added, modified or deleted' action with Change Type set to Deleted)

[AdelSabic]

Hello Joseph,

I will try to put it in steps:

1. You should use "When a row is added, modified or deleted" Dataverse trigger with "Change Type" set to Deleted. This will trigger your flow when record is deleted from entity.
2. Include "List Rows" Dataverse action which will fetch records from "Audits" table. In this action you will include OData filter from example. This will return you latest audit log for the record.

Rest of the instructions on how to pull out data you need are provided in the post above.

Hope this helps,

Greetings,
Adel Šabić