Conditional Email of workflow exceptions

[Pradeep66]

Hi Community, 

Greetings of the day!

I have a workflow and it has many containers defining the processing steps to achieve requirement. we also have exceptions defined at every step of processing(Containers). Now this workflow runs every 20 mins from gallery to fetch latest data from files. My question is how do we enable these emails notification at start of the day and at the end of the day itself. In other words, at first run and last run of the day   ( containers again from workflow) 

this is to check at start and end of the day for any exceptions. 

I know, we can do it with a separate workflow with schedules defined so. 

But can we achieve using same workflow?

thanks & regards

Pradeep Koppaka.

https://www.linkedin.com/in/pradeep-koppaka-57ba0953/

[JagdeeshN]

Hi @Pradeep66 ,

Thinking out loud here. The email tool only sends an email if there is a record coming through as input.

Have you tried using the filter tool to only process a record as true if the current time is equivalent to your start time and end time during the day? And feed this as an input to the email tool, thereby sending emails only during those custom defined time windows.

[Felipe_Ribeir0]

Hi @Pradeep66 

Here i use this trick:

1)Provide the workflow with the datetimes that you want to send the email

2)Provide the workflow with the execution datetime

3)Combine append and filter to see if the datetime of current execution is close enough to the datetime that you need to send the email to allow or not the email to be sent

[gautiergodard · Accepted solution]

Hey @Pradeep66 

To confirm, are these exceptions generated using an email tool or the event's notifications which show any errors within the workflow?

If you are using an email tool, I'd recommend placing a filter with a time condition right before your filter. Something like:

If [INSERT FIRST SCHEUDLE TIME] >= datetimeadd(datetimenow(),-5,minutes) AND [INSERT FIRST SCHEUDLE TIME] <= datetimeadd(datetimenow(),5,minutes) then ='T'

elseif [INSERT LAST SCHEUDLE TIME] >= datetimeadd(datetimenow(),-5,minutes) AND  [INSERT LAST SCHEUDLE TIME] <= datetimeadd(datetimenow(),5,minutes) then ='T'

ELSE 'F'

endif

In this instance the first and last runs would be calculated based on a fixed variable you could create, stating what the first schedule of the day is and the last. The formula provides a +/- 5 minute buffer given I dont know how long your workflow typically takes to run, but you can edit as you see fit!

Hope this helps!

[Pradeep66]

I have nearly 10+ exceptions defined in workflow. Just to avoid multiple emails I am writing all exceptions to a excel file and then emailing excel file once a day to users. 

here again we have 1 problem.

output tool is writing headers to sheets even if there is no data.

[JagdeeshN]

@Pradeep66 ,

Please checkout the below discussion thread for the output issue and see if it fits your usecase.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-not-create-output-when-no-recor...