Power Platform Community Forum Thread Details

I have a flow that uses Teams, Outlook and Office 365 connections.

In addition to the flow logic, it also sends a notification to the flow owner if the flow fails, however if the failure is due to connection authentication issues (for example when connections requires re-authentication due to a password change), also the notification action fails since it's using the same Teams connection. Is there any other way of notifying the user that would not have this kind of problems?

Categories:

Building flows

Because of how unreliable the e-mails from Microsoft are to send flow failure notifications, I created a workflow to run daily to get a list of all failed flow runs and send it to the team that manages our flows. I am not sure why you would want to notify an end user unless they are the owner of the flow. If you need to notify the end users, you'll need to figure out how to adapt this to do so.

This is the basics of the flow:

At a scheduled time each day, the flow runs to get the failed runs from the prior day,
It queries the Dataverse table that stores the flow run history.
The condition checks to see if there were any failures.
If yes, a Select action pulls relevant information from the failed run.
Formats it into an HTML table.
The compose action formats the body of the e-mail (this would not be needed if Microsoft would fix the issues in the new designer that mess up HTML e-mails).
Finally, send the notification.

This is the configuration of the Dataverse action:

Select columns: duration,endtime,errorcode,errormessage,flowrunid,name,starttime,status,triggertype,_workflow_value,_ownerid_value,workflowid,ownerid
Filter Rows: (Microsoft.Dynamics.CRM.Yesterday(PropertyName='createdon') and status eq 'Failed')
Sort by: createdon desc

This is the configuration of the Select action:

Flow (opens the failed flow run): <a href="https://make.powerautomate.com/environments/@{workflow()['tags']['environmentName']}/flows/@{item()?['workflowid']}/runs/@{item()?['name']}">@{item()?['_workflow_value@OData.Community.Display.V1.FormattedValue']}</a>
Date: formatDateTime(item()?['starttime'], 'MM-dd-yyyy hh:mm tt')
Duration: if(less(item()?['duration'], 1000), concat(item()?['duration'], ' ms'), formatDateTime(addSeconds('1970-01-01T00:00:00Z', div(item()?['duration'], 1000)), 'HH:mm:ss'))

The rest should be self-explanatory. Format the message you want to send and insert the HTML table into the body of the e-mail, and send it.