Error message when a pairing file in missing

[Saravanan13]

Hello All,

I have multiple files in a  folder. The workflow should pick a pair of files (1234Tax,1234App) & (5678Tax,5678App) & (1111Tax,1111App) and process in the workflow. The ask is when some files does not have a pair then error email should be sent to email recipients.

Can anyone assist.

[danilang · Accepted solution]

Hi @Saravanan13 

This should be relatively easy to do.  Once the first file is selected(\\server\share\1234Tax) use FileExists("\\server\share\1234App") in  a formula tool to see if the corresponding App file exists.  Use a filter to check the existence.  Connect the processing part of workflow to the True output and connect the False to an email tool.   If the target file exists, no records will be sent to the email tool.  If it does not, the email tool will fire. 

You'll need to take steps to ensure that processing part of your workflow can complete even with no input data.  If there's an error in the processing part, the email tool won't fire.  The Don't-Error-When-No-Input can be complex to design, so another option is to throw an error using a Message tool connected to the False output of the filter and add an After Run with Error event email.

Dan

[martman]

Looking for a way to pair up files based on the file name can you tell me how you paired your files up?