Unanswered

How to roll back the changes when failure of flow

(0) Share

Report

Posted on by rajsekhar311

Hi All,

Is there any possibility to roll back the actions performed before the flow failure? In the below example I want to roll back the "Insert row" action as "Insert row 2" has failed. Appriciate your help here.

Thanks,

Phani.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rajsekhar311,

I am afraid I really don't really understand what "roll back" you mentioned here means.

If you want sql table to return to the state after the Insert row action is executed, obviously you don't have to worry about it.

Because if the Insert row 2 action fails, it will not do anything with sql table.

Best Regards,

Barry

Was this reply helpful? Yes No
rajsekhar311 4 on at

Like (0)

Report
Copy link

Link copied!

Hi Barry,

Thanks for your reply.

roll back means, I want to revert all the changes that are happend with particular flow. If you can refere my example, if something fails at "Insert row 2", I know it will not do anything in sql but what about "Insert row" action which is already committed in SQL? I want to revert the "Insert row" changes also.

Actual requirement is, I have an entity (Invoice Container) in CRM with 4 currency fields. I have to create a separate SQL record for each currency field from the Invoice Container record. So if something fails at 4th curreny field I want to revert the changes which means nothing should be inserted into SQL. Hope you understand my requirement.

Thanks,
Phani.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

You want to use some sort of transaction... when one of the steps fails then do not commit anything.
It sounds great and you really have to request this feature...
Perhaps you can fix this with the SCOPE control? When the scope fails then perform the undo actions of all the things you have done based on the 'Configure run after' settings?

Was this reply helpful? Yes No
rajsekhar311 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply. I will try with the controls you mentioned.

Was this reply helpful? Yes No