Unanswered

Get Dataverse Deleted Row values

(1) Share

Report

Posted on by NTButlerNBC

Hi all!

I'm fairly new to Power Automate, and am trying to build a flow that manages email subscriber lists in marketing system according to records in a database. I'm hoping to use a Dataverse table.

On the Dataverse trigger "When a row is added, modified or deleted", is there any clean way to actually get the full row data of a row that is deleted? I can obviously get the ItemInternalId, but I need some of the actual row data (i.e. a subscribers email address) in order to perform the clean up action of the subscriber lists. I do not have the ability to mark the subscriber records in the marketing system with the ItemInternalId, so I do need the row data.

One way I know could work is to maintain a separate copy of the table, and cross-check data in the copy to get what I need, but that seems like a redundant and fairly ridiculous solution.

Cheers!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

eric-cheng 5,171 on at

Like (0)

Report
Hi @NTButlerNBC ,

There isn't an easy way to get it unfortunately as by the time the flow is triggered, the record is already deleted. There are a few things you can look at:

Perform soft deletes (i.e. update a field / column with a deleted status)
Create a plug-in during the pre-condition of the event here
Enable auditing and see if you can retrieve it from the relevant tables here
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
ml_kitsap 9 on at

Like (2)

Report

While this answer is technically correct, it proves that the delete side of this trigger is nearly worthless. I'm disappointed!

Was this reply helpful? Yes No
Craig_Humphrey 186 on at

Like (7)

Report

I agree with @ml_kitsap The delete trigger becomes useless.
Perhaps if the trigger actually contained all the fields of the deleted item - instead of nulls - then it would be useful!

Was this reply helpful? Yes No
CW 1,044 on at

Like (0)

Report

What else would you expect with their stuff? Actually, I'd be totally shocked if it was useful. Much of their stuff is typically only completed to 75% so it stands to reason, most functional, everyday, expected functionality would be 'accidentally on purpose' be missed. In which case we're directed to dump such requests into the rabbit-hole abyss aka UserVoice.

Was this reply helpful? Yes No
cantareroj 53 on at

Like (0)

Report

Completely agree!.

Was this reply helpful? Yes No
jsneed 2 on at

Like (0)

Report

If using Dynamics 365 you can use a legacy workflow to access data from a record that is triggered when it is deleted.

Was this reply helpful? Yes No
Tim Robinson 50 on at

Like (0)

Report

a useful blog post here with information about using Dataverse auditing to retrieve the information (DISCLAIMER: I haven't tried this out)

https://www.expiscornovus.com/2023/09/19/get-dataverse-row-changes/

(if that link stops working you should hopefully be able to google "Expiscornovus Get Dataverse row changes")

Was this reply helpful? Yes No