Tracking Email Status for Multiple Workflows in Alteryx 2023.1

[Amit_G_Limbasia]

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!

[dwstada · Accepted solution]

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.

 

[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.