Tracking Email Status for Multiple Workflows in Alteryx 2023.1

Hello Alteryx community,

I hope you're all doing well. I'm currently working with Alteryx Desktop Designer version 2023.1 and have a scenario where I run approximately 10 workflows consecutively using the scheduler. Each of these workflows generates a report that needs to be sent via email. I've configured the Alteryx Email Tool with Microsoft SMTP settings for sending these emails.

My challenge is to create a mechanism that provides me with a consolidated report of the email sending status for each of the 10 workflows. Specifically, I would like to know if the email was successfully sent ("Yes") or not sent ("No") for each workflow. The desired output format is a tabular representation, which shall be embedded within the body of an email either at a predetermined specific time or upon the culmination of all 10 workflows.

Thank you in advance for your help!

Reporting

Accepted answers

dwstada

There is a CReW macro called "Runner" which can run a workflow and output something on successful run or run with errors.

When your email fails to send, this should lead to an error, right?

So you could use one workflow with 10 runners for your workflows, add a formula tool to the runner outputs which would add a column saying which workflow that is and if it failed to send (coming from the failure output) or sent correctly (success output) - union everything together, put it in a table, and send via email to you

e.g.

email runner.PNG

All comments

dwstada

There is a CReW macro called "Runner" which can run a workflow and output something on successful run or run with errors.

When your email fails to send, this should lead to an error, right?

e.g.

email runner.PNG

sudhakaran-rajan

have you resolved this ?

Amit_G_Limbasia

Yes It helps me in my situation

KGT

That log that is displayed when running the workflow on designer is also written out to disk (specified in settings). One possible option is to pick up all those logs and parse them for the report. The Runner tools are not supported on Scheduler/Server, and so may have issues.

Adding that option in case someone else is now looking at the same.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703