Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

How to roll back the changes when failure of flow

(0) ShareShare
ReportReport
Posted on by 4

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.

 

 

2018-12-19_1329.png

 

Thanks,

Phani.

  • rajsekhar311 Profile Picture
    4 on at
    Re: How to roll back the changes when failure of flow
    Thanks for your reply. I will try with the controls you mentioned.
  • Community Power Platform Member Profile Picture
    on at
    Re: How to roll back the changes when failure of flow

    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?

  • rajsekhar311 Profile Picture
    4 on at
    Re: How to roll back the changes when failure of flow

    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.

  • v-bacao-msft Profile Picture
    on at
    Re: How to roll back the changes when failure of flow

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,658 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow