error handling while insertion or updation through flows

[Murari]

Hi All,

    I want to handle any type of errors while inserting or updating . Please help me on this. Is it possible to add validations

@CFernandes : Please guide me on this.

[CFernandes]

@Murari For SQL inserting, I did not try much of Error handling.

But for other connectors I used Scope(try catch finally) for handling error in my Power Automate.

https://sharepains.com/2018/02/07/power-automate-try-catch-finally-flow/ 

I hope it helps.

[ScottShearer]

@Murari @

First, try setting the retry policy for the action - it defaults to 4 and you can increase it.

Take a look at the "Run after" feature available with any action.  You can set an action to run only if the action before it failed, succeeded, etc..  In your case, you might set a variable inside of a loop.  Set the loop to run until the variable is Yes - see my example below.

Alternatively, you can have the insert/update run outside of a loop.  Have an action immediately after it that runs only if the insert/update fails and take action as appropriate (log it somewhere, send an email, etc.).