Unable to create an alert when workflow status is "Stopped (error)"

(1) Share

Report

Posted on by MBates237

211

Hi All,

I've attempted to set up alerts for when a workflow has an issue and the status becomes "stopped (error)"

However, when setting up the alert "stopped (error)" is not a value I can specify

If I use "Failed" I don't get an alert for "stopped (error)".

How can I create an alert for the "stopped (error)" status?

I have the same question (0)

All responses (4)

Answers (1)

GirishS 27,827 Moderator on at

Like (0)

Report

Hi MBates,

Can you check the value of status field in the WorkFlowWorkItemTable against the workflow instance id - I think there will be no work item created against your workflow instance.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (0)

Report

Hi MBates237,

The issue with this form is that there are multiple data sources used where the alerts can create a trigger for only one of the tables used as data source. It is now showing all fields from the Workflow work items table where this status field is part of the Workflow tracking status table.

In the workflow configuration, you can setup notifications when a workflow instance gets stopped. This would be the recommended way for your requirement.

As an alternative, you can consider using business events and use Power Automate to send an email alert. This might need some development to trigger an event when the workflow instance gets in a stopped state.

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

hi MBates237

I would suggest enabling notification from Workflow Configuration instead of creating Alert notification.

This might help you : docs.microsoft.com/.../workflow-faq

Thanks,

Was this reply helpful? Yes No
Verified answer

Gino Roesems 14 on at

Like (1)

Report

This post is from a while ago, but I can give the solution I use to generate an alert rule for stopped workflows, across all workflows and without having to set it separately in each workflow.
The trick is to query the WorkflowTrackingStatusTable table through the 'systablebrowser' and that way you can set the alert rule you want.

https://.......dynamics.com/?mi=SysTableBrowser&tableName=workflowtrackingstatustable&cmp=...

Was this reply helpful? Yes No