What I need is for anytime a process fails, the actual error details data to be written into a SQL table.
How should this be done?
Hey @vinit_598
You can add the particular action where you are getting the error in a scope action.
Then make a parallel branch after the scope action.
So on the left side, the flow will go normally and on the right side, add a compose and add the result of the scope to it. Syntax of expression: result('Scopename') [Note: Default-> result('Scope')]
Then after this go to settings of the right hand side compose and change its run after property to failed.
After this use parse json and pass the outputs of the above compose in the generate for sample of parse json action. After that you can add the status that you are getting from in the sql action and save it to your database.
From result function, you get many important things like action name, inputs and outputs of the action. Final status successful or failed. And many other things as well.
WarrenBelz
146,552
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional