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.
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?
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.
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
WarrenBelz
146,658
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional