Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Sending emails based on conditions

Highlighted
Meteor

Hey Community. I am trying to send out emails that notify certain people when a piece of equipment gets an error code labeled "critical" but I'm getting stuck. I want to use more than just the filter tool because I don't want to be emailing out blank email attachments. What I have right now is a report that shows only the critical error codes and the event I scheduled will send that report. However, if there are no critical error codes, the report still gets emailed out but is blank. I need the workflow to run every 5 minutes so the recipient receives the notification almost instantly from the time the equipment logged the critical condition. What I don't want to happen is an email being generated every 5 minutes when the report is blank.

 

I've done some research and I think I need to use the Detour tool, but I am extremely unfamiliar with all of the interface tools and the developer tools and I'm hoping someone either has a different solution than those tools or can help me understand those tools and possibly apply the Detour tool to this workflow.

Alteryx
Alteryx

@Shelbey 

 

A possible solution would be to only send the email on a successful run of a workflow and triggering an error if there are no critical codes. Use the Count Records tool followed by the Message tool with the following configuration

 

data-validation.png

 

 

The configure the workflow to cancel running if an error occurs - this can be done within Runtime setting of the workflow

 

cancel-workflow.png

Highlighted
Meteor

Thank you! This was way easier than what I was trying to do! 

Labels