Error Mail Settings

[slckkrky]

Hello everyone

I developed a workflow and want to make sure in case source file is corrupted, it should not run or in case it runs, it shouldnot overwrite results file.

in my workflow;

1- The prevention and failure mail in "Workflow configuration - Events" works file. So if lets say source file is deleted or saved in different format, workflow doesnot execute and send the correct email. Mail contains "Workflow Execution Failed". This is working fine in my workflow.

2- In case source file format is fine however the data inside the file is deleted, hence no output is created, i want it to prevent overwriting empty data to the output file and send another mail stating that "Data Failed". 

3- If everything is as expected send a "Workflow Successful" mail.

Issue 1 - Is on point 2 where workflow doesnot overwrite to the output file as I wanted however it doesnot send the "Data Failed" email.

Issue 2 - Is this mail feature working only via Alteryx Gallery? I never made it work on Alteryx Desktop.

Anyone can help me solve that please?

Mail configuration is established and working fine, i marked the company credentials and mail in the sample workflow.

Thank you in advance

[HomesickSurfer]

Hi @slckkrky 

Move your message tool just before the final filter (or remove the filter altogether)....if no records, it will generate an error message and stop passing records through the tool.  Be more descriptive in the message.  Be sure to config your workflow to Cancel Running Workflow on Error.  Add a new email After Run With Errors event with %OutputLog% in the body.  The error will be shown to the recipient(s).

[slckkrky]

Thanks for your reply. However i also want a success email if everything works fine.

The mail from Events is working fine and also it stops the execution.

The mail with the mail tool after the filter is working fine when data and file is fine.

The mail with the mail tool after filter is not being sent. This is the issue i want to fix.

[HomesickSurfer]

Hi @slckkrky 

Your first event email will email if successful, no need for another on the canvas.

You don't need an email tool connected to the false on the filter if you have an error event.

[slckkrky]

Yes but I want to differentiate error mails hence trying to make the mail tool in canvas work.

Mail via events is for in case file is corrupt, deleted, format changed etc. In this case workflow will not run at all. Message says "Execution Failed".

Mail via mail tool in canvas is used for null output. In this case workflow will run and complete successfully but message should say "Data Failed".

Also if success mail is working in the canvas mail tool, why failure is not working? everything else is how i expected.

[HomesickSurfer]

Hi @slckkrky 

Your formula that creates the TEST1 field will always output, hence Count not ever being 0...

Deselect the TEST1 and others, filter a single field to omit nulls, then count...