Get error message for the action 'on failure'

[olgaoszcz]

Hi, 

I'm trying to set up error handling in one of my flows. I have 'Create file' action and then 'Exacute strored procedure' on failure. First issue i noticed is if my 'create file' failes but the stored procedure is executed, in the run history it still says Flow was succesfull. I don't think thats informative enought - something still failed and it should be visible in the run history.

You can't just say it run successfully, when one of the steps failed...

Second issue I have is that I have the information on which step of my flows failed but I would also like to get the error message flow provides.

It would make life so much easier to have the error message avaliable as a dynamic content... Does anyone had a similar problem? Any ideas on how to work around it?

[Anja1]

Hello Power Automate community!

As @Pstork1  described, the expression returns an error message if an error occurred within the scope:
result('Name_of_the_scope')

Don't use:  results('Name_of_the_scope')

It took me a while to figure this out myself 😉

It is described e.g. here by Alex Shlega:
https://www.itaintboring.com/power-platform/power-automate-scope-action-what-does-it-have-to-do-with...

[MichelH]

Hi @tapan 

No there is no way to get the error message AFAIK, except by testing all the underlying actions.
This is strange/silly since this 'global' error is often available in the run history outcome.

So while it is there, it is just not exposed to the programable part of flow. 

Too bad, maybe you want to put this on the idea list, if not already there.

[Anonymous]

Your solution got me really close - but the issue may have been system updates that changed the command.  It is not action(), but actions(), and you need the .body. in there.

Here is your solution based on current code and a reference link for Docs:

Command in [Compose]: actions('{your_action_name').outputs.body.message

Here is the link to the Power Automate 'actions' code command (all flow code commands!):

Reference guide for expression functions - Azure Logic Apps | Microsoft Docs

Hope this helps others resolve their errors faster.

Note: Set the next action in the flow 'Configure run after' to 

[maxpower45255]

One way to get the message/result of the action is to use: body('actionName')['message']. NB: You must replace the spaces with underscores in the actionName.

[Hidayati]

{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
null
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
null
null
null
null
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
null
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}
{"Message":"error!","Result":"failure"}

[Clifferton]

That looks like an incredibly helpful error log /s.

Did microsoft recently change error reporting. I used to use the try/catch to ensure that failed operations did not stop my flow, and that the flow did not report as failed, but recently, my flow with try/catch is throwing failure status for flows when the failed action is inside my try scope.

Any ideas?

[MichelH]

Hi @Clifferton, 
For quite some time now, I wrap everything that can fail in a scope control.
The next component's runafter property makes it finish normally.

[Clifferton]

Right, I have a test that might fail inside a scope, with run after set for the following scope. but when it fails the entire flow is marked as failing too. I'll keep looking.

[Pstork1]

Make sure that after the failure run after scope you add a terminate action set for Succeeded or that you merge the failed scope back into the main flow path.  If the flow ends on a run after failed the flow will be marked as failed.  But you can reset that using a Terminate action.

[Clifferton]

Thanks, I didn't have a terminate control in the final scope. I'll see if that works better.

[Pstork1]

Make sure you set the Terminate to Succeeded.  Its Failed by default.

[Pavel_NaNoi]

This is probably a little late, but if you're out there still struggling with getting just the error message of the action that failed out of a scope of like 20 actions, here's a simple method I've recently created so that you could always get it out:

An explanation of how this works:

- First action is a scope

- Second action only runs if the scope throws an error

- This second action, takes the result of the scope using the "result()" action, however since its an array of only one item, that being the entire message, we can't dig into its contents easily, thus we first have to join it first into a whole string but then we can split back into a list of strings that are split by "," and this luckily splits the text up perfectly as each line in result() ends with a ",' and gives us each and every line in result() as just an item in an array.

- With this, we move onto the third action, an Filter Array action, in here we just give it our array output and simply ask it to go through each item in the array and look for the text "message", if it finds it, it gives us the output.

The reason this all works is because any error in power automate is always in the following format:

"error": {

        "code": BadRequest,

        "message": "Exception message here",

}

So we just need the "message" part out.        

And that's basically it, this removes any need for a for each loops coincidentally as well, making our life much easier.

The only limitations this has is if the message is either:

a. Extremely long, nothing we can do about that and you're at the mercy of Microsoft's exception handling.

You'll need to create a separate business exception case for cases like this.

b. If there's multiple "Message:" messages, it will print them out too, whether relevant or not. It will still work but just have extra unnecessary information in the way, you may be able to filter this out further however.