Flow Failure Notifications 01-17-2023 10:52 AM

[takolota]

Get email alerts with direct links to the flow run any time your flow fails by adding this set of actions to the end of your flow.

Either download the template attached to this post & copy the Scope in the template, or copy the Scope action's code, navigate to the My clipboard tab on a new action and press Cntrl + V to get this Scope as a new action option.

Scope Code To Copy & Paste Into Your Flow

{"id":"fd3dfdb1-5fc7-4bb4-b830-978bffcb68b9","brandColor":"#8C3900","connectionReferences":{"shared_office365users":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_office365users/connections/4492902ae6154e088865fbb98252807a"}},"shared_office365":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_office365/connections/shared-office365-02d46624-0d5c-40fe-89f0-c5df-8c7ffde7"}}},"connectorDisplayName":"Control","icon":"data&colon;image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"Scope_Failure_Notifications","operationDefinition":{"type":"Scope","actions":{"Compose_Flow_run_link":{"type":"Compose","inputs":"@concat('https://us.flow.microsoft.com/manage/environments/', workflow()?['tags']?['environmentName'], '/flows/', workflow()?['name'], '/runs/', workflow()?['run']['name'])","runAfter":{},"metadata":{"operationMetadataId":"304e2c8e-c6d8-4bd0-ac4d-57951dd57763"}},"Get_my_profile_(V2)":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_office365users","operationId":"MyProfile_V2","apiId":"/providers/Microsoft.PowerApps/apis/shared_office365users"},"parameters":{},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{"Compose_Flow_run_link":["Succeeded"]},"metadata":{"operationMetadataId":"16453b92-e67e-40aa-acf4-fbd90183a4f0"}},"Send_an_email_(V2)_Failure_notification":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_office365","operationId":"SendEmailV2","apiId":"/providers/Microsoft.PowerApps/apis/shared_office365"},"parameters":{"emailMessage/To":"@outputs('Get_my_profile_(V2)')?['body/mail']","emailMessage/Subject":"Your @{workflow()?['tags']?['flowDisplayName']} flow failed","emailMessage/Body":"<p>Check your flow.<br>\n<br>\n<a href=\"@{outputs('Compose_Flow_run_link')}\">Flow Run Link</a>&nbsp;</p>"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{"Get_my_profile_(V2)":["Succeeded"]},"metadata":{"operationMetadataId":"bd4b39c2-3462-4a00-b21d-d8ac056f00d2"}},"Terminate_Mark_flow_run_failure":{"metadata":{"operationMetadataId":"c3050a38-c258-4145-b3fa-4d5e80d70b67"},"type":"Terminate","inputs":{"runStatus":"Failed"},"runAfter":{"Send_an_email_(V2)_Failure_notification":["Succeeded"]}}},"runAfter":{"Compose_(All_Your_Flow_Actions_Here)":["Failed","Skipped","TimedOut"]},"description":"Set this Scope's Configure run after settings to \"has failed\", \"is skipped\", and \"has timed out\".","metadata":{"operationMetadataId":"072e1b99-2b98-4cdc-bb50-f9ef10d9a137"}}}

watch?v=u9GhlSofXAI

[Fulab]

Hi, Great solution, thanks. I have a bit of a follow up to this. Trying to figure out a way to create a dashboard with info/visuals on success/failure rate etc for all the flows and so was wondering if you had any suggestions for this. I guess there would be an additional step taking a count of whether it indeed did succeed or fail.

I’ve tried looking into something built in but all things seem to point to PowerBI which I’m trying to avoid due to cost and requirements being a simple dashboard. Ideally something cost effective already in the power platforms/automate space. An example would be similar to creating a dashboard in the azure  monitor space looking at logic apps.

I’m new to the power platforms space and any pointers would be greatly appreciated.

Thanks.

[takolota]

@Fulab 

Yes, you sound like you have a good idea of how to implement it, count a success at the end of each flow & add a count of failure in the failure scope for if the scope/notifications are triggered.

As for visuals, I’m not as familiar with all options there like anything built in to Power Automate, but if there isn’t anything built in & you have access to Power Apps, then there are some simple graph options available in Power Apps that you could connect a success & failures dataset to. 

[hassancseku]

Hi, Thank you for the details. It helps a lot. I am using your flow with my flow. But after any failure of my flow, i am getting 7 emails in my inbox which should be one. Any suggestion? 

[takolota]

@hassancseku 

Can you send a picture of your flow set-up?

[hassancseku]

Here is my flow

[takolota]

@hassancseku 

I see it’s a For a selected file trigger. Were multiple files selected when you last ran it? Did that trigger multiple flow runs?

[Ajbutterfly87]

Where is this video at? I have searched but cannot find it. Thank you.

[takolota]

@Ajbutterfly87 

This one?

https://youtu.be/u9GhlSofXAI

[Ajbutterfly87]

Yes, I guess the composed part is just whatever falls before it. Thank you.

[Scott_K_Fraley]

I WISH it was that simple. I've added a new blank Scope and the My Clipboard thing is NOT working. / Will NOT let me do a paste.  😞

Going to watch the video and hope it shows me that I've done something wrong or.. something.