How to stop workflow if file not found

Question

I have a workflow and  that is scheduled. I  have used DYNAMICE INPUT tool to import last updated file but the problem is  sometime source data not updated due to technical issue and workflow run with previus day updatd file which  is incorrect. I want a condition if file name ( workview reprot mm.dd.yyyy) if not found then workflow stop.

craigja · Accepted Answer

2 Options

* If you know the filename and that it has the date at the end, then use a formula tool to build up the filename and pass that into the dynamic input, then if todays file is not there, it wont run and will error
* Use the Directory tool, get a list of all files in the directory, filter the files to look for one with todays date in the filename or created date, again, if no file for today, the workflow will error

DanM · Accepted Answer

@prpanw Take a look at the Message tool. You can create exactly what you are looking for. What you will do is create an error message in the tool based on your requirements as you mention after your Input Tool. So you'll have a second stream coming out of the Input tool. Then in your workflow configuration window (click on the canvas) in the Runtime settings you will see that you can cancel the workflow upon an error. This will then stop the workflow based on your message tool which is creating the error.