Adding Error Handling Mechanism in Flow

[AkshayManke]

Hi Everyone,

I am building a flow with Error Handling Mechanism by referring to Reza's tutorial here: (16) Error Handling in Power Automate flows | Try Catch Scope Action - YouTube

I have created a scope where group of actions gets performed and in next step I have created another scope where i have added actions as below 'Filter Array', 'Create HTML Table' and 'Send Email' to send email when the flow fails. Below some of the snaps for reference.

Below the snap where i have configured the error handling part.

But in the email i am getting the error message at the scope level and not the action level. I mean i want the error message of the specific action which has failed and not the scope. Below the email presently i am getting.

Can anyone please help that how can i get the action error message in the third column instead of the scope error message?

Thanks in advance.

Akshay

[SudeepGhatakNZ]

You can add error handling both at a scope level or inside the scope. You must have added it at a scope level.

[AkshayManke]

Hi @SudeepGhatakNZ,

In case if i add it inside the scope then also it is showing the same error message which is at the scope level. 

If i add inside the 'Apply to Each' action then it is sending number of emails regardless of actually failed items, because it is looping for every item in the 'Apply to Each' action.

I need a solution where the error handling mechanism should stay out of the scope, but it should precisely mention the error message from the scope or inside any specific 'Apply to Each' loop.

Thanks and Regards,

[SudeepGhatakNZ]

Place the email action below the the action that errors out and then set the Run after condition on the email action to "On failure".

Doing so, the email action will only run when the action failed and you can capture the exact error from the body of the failed action.

[AkshayManke]

Tried this as well just now but not working out as expected.

[SudeepGhatakNZ]

Is it sending multiple emails or is the error message not accurate?

[AkshayManke]

I have both observations.

[AkshayManke]

I am still looking for the solution on this please. can someone please help?

Thanks and Regards,

[Chriddle]

I think you are looking for the result function.

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#...

[AkshayManke]

Hi @Chriddle, thanks for the help however i am using the same result expression to get the details. However i have 'Apply to Each' loop and the error i am getting inside the loop. When i am using the result expression it is giving the error at the scope level and not at the 'Apply to Each' level, hence i am not able to get the exact error details. I have specified the case in my first message in the thread. Is there any way using i can get the error details which are there in side a specific 'Apply to Each' action which is inside a scope.

Appreciate your help.

Warm Regards,

[Chriddle]

Not in a generalized way addressing the Fetch scope.

However, addressing the Apply to each works:

result('Apply_to_each')

[AkshayManke]

Thanks @Chriddle, will test and will get back to you in in next 5 hours.

Warm Regards,

[AkshayManke]

Hi @Chriddle, I tried to get the results from 'Apply to Each' as the flow is not accepting the result parameters Create_item. However, I am getting the results, but it is giving the entire output in JSON format. Below the snaps. I tried to get the result when the Apply to Each Failed but not getting the output in expected format. Can you please help what additional expressions i should add there?

Regards,

Akshay

[Chriddle]

I created an example flow that has an Apply to teach with an action that might fail and some actions to grab the interesting parts of the result:

In the Apply to each there is an action with the division 1/items('Apply_to_each'), that will cause an error in the second and forth run.

ActionNameResult is a Filter action that filter the result('Apply_to_each') for items with the action name:

{
    "inputs": {
        "from": "@result('Apply_to_each')",
        "where": "@equals(item()?['name'], 'ActionThatMightFail')"
    }
}

FailedActions is a Filter action that filters the items for errors:

{
    "inputs": {
        "from": "@first(body('ActionNameResult'))?['outputs']",
        "where": "@equals(item()['status'], 'Failed')"
    },
    "metadata": {
        "operationMetadataId": "dc56afb6-0de6-4f93-9509-62a5e02654e1"
    }
}

ErrorMessages is a Select action that grabs only the error messages:

{
    "inputs": {
        "from": "@body('FailedActions')",
        "select": "@item()?['error']?['message']"
    }
}

Output:

[
  "Unable to process template language expressions in action 'ActionThatMightFail' inputs at line '0' and column '0': 'Attempt to divide an integral or decimal value by zero in function 'div'.'.",
  "Unable to process template language expressions in action 'ActionThatMightFail' inputs at line '0' and column '0': 'Attempt to divide an integral or decimal value by zero in function 'div'.'."
]

Hope that helps 😉

[AkshayManke]

Thanks a lot @Chriddle, I will try that and will get back to you tomorrow.

Warm Regards,

Akshay

[Chriddle · Accepted solution]

As usual there is a better solution with XPATH:

ErrorMessages is a Compose action:

xpath(
	xml(json(concat('{"root":{"action":', result('Apply_to_each'),'}}'))),
	'//error/message/text()'
)

Output

[
  "Unable to process template language expressions in action 'ActionThatMightFail' inputs at line '0' and column '0': 'Attempt to divide an integral or decimal value by zero in function 'div'.'.",
  "Unable to process template language expressions in action 'ActionThatMightFail' inputs at line '0' and column '0': 'Attempt to divide an integral or decimal value by zero in function 'div'.'.",
  "The execution of template action 'ActionthatCantFail2' is skipped: the 'runAfter' condition for action 'ActionThatMightFail' is not satisfied. Expected status values 'Succeeded' and actual value 'Failed'.",
  "The execution of template action 'ActionthatCantFail2' is skipped: the 'runAfter' condition for action 'ActionThatMightFail' is not satisfied. Expected status values 'Succeeded' and actual value 'Failed'.",
  "The execution of template action 'ActionthatCantFail2' is skipped: the 'runAfter' condition for action 'ActionThatMightFail' is not satisfied. Expected status values 'Succeeded' and actual value 'Failed'."
]

[AkshayManke]

Hello @Chriddle,

Now it is working exactly as expected. Thanks a lot @Chriddle for helping there. Have a nice rest of the day ahead.

Regards,

[Maisum]

@Chriddle can we get any other info related to error besides the error messages through XPath?

[Chriddle]

Here, xpath() is just a way to collect the information provided by the result() function.

If the information you want is in the output of the result() function, you can find it using xpath().