Initiate Email or Process Based on Field [Count]

[mmvcans]

I'm trying to "send email" if [Count]>=1 (or DONT "send email" if [Count]<1) and in parallel "run process" if [Count]<1 (or DONT run process if [Count]>=1). Problem is the email tool puts itself at the end of the flow so I end up with a warning message: No Messages were sent because the workflow has an error.

Attaching a snippet of the workflow

Message tool 1 uses parameters: Before Rows where exp true - [Count]<1; error and stop passing through. Message tool 2 uses parameters: Before Rows where exp true - [Count]>=1; error and stop passing through. 

Does anyone know a quick fix to this other than using a workflow event with email even after error setting enabled? I'm trying to avoid sending an email if the process runs successfully (ie, [Count]<1). 

This flow will also be loaded to server (I'm new to that suite) so if there's an easier way to use scheduler for this intended touchless process, instead of doing backflips in the designer, happy to entertain those ideas.

[mceleavey · Accepted solution]

Hi @mmvcans ,

simply put your email tool in a macro and then into a container. Attached a Control Parameter to the lightning bolt on the container.

When you attach your control parameter you will get an action tool.

Configure the tool as follows:

Your macro should look like this:

In your workflow, use a count records tool to count how many records are going into the macro, feed this into the control parameter. Feed the rest of the data into the macro. This macro will replace the email tool in your workflow.

Effectively, this is disabling the container if there are no records.

Hope this helps,

M.

[OllieClarke · Accepted solution]

Hey @mmvcans if you didn't want to go @mceleavey's macro route, you could also create a field of your recipients in a formula tool, then a simple filter before the email of [Count]>=1 would prevent any records going into the email tool. As your recipients are now reliant on a field in your data set, no emails would be sent. 

Hopefully that makes sense :)