Input file when uploaded to folder

Question

Hi,

We have a folder and if a file is uploaded within that folder within 60 seconds of the workflow being run, we want it to select that file and continue with the rest of the workflow.

It will be the only file in the folder, if nothing is in the folder we want the workflow to end.

Please can anyone suggest how I could complete this?

Jessica7 · Answer

Hi,

Thank you for this, do you know how I would keep this going, I want it to check maybe 100 times to see if the file has been added to the folder and then if not error and if a file has been added use that file through the dynamic input as you stated to use that file?

I was thinking I will need an iterative macro, but I'm not sure how to create it using these tools?

Robin_McIntosh · Answer

@Jessica7 - Here's one way of doing it.

Use the Directory tool to find all the files in the specific folder.  In this example, I'm finding all files with .xlsx extension.

Then use the filter tool with a custom filter of DateTimeDiff based on Now and the file creation timestamps.

Lastly, based on true result, you can then pass your resulting file (fullpath) to the Dynamic Input.