Dynamic Input Tool Error

[Will-G]

Hi,

I've created a workflow to read the latest file in a folder and the sheet from the current month in that file (see workflow image). The Dynamic Input Tool part has an error saying "Can't find the file: ..." (see image of the configuration). Please could anyone help with this?

The files in the folder are of the form "01 FileName_Aug 2021" and "02 FileName_Sep 2021" etc. The sheets are 3-letter month abreviations and 2-number years (e.g. Jan 21, Feb 22 etc.). So overall the workflow aims to read the latest file and the current month sheet.

Many thanks,

Will

[Will-G]

Thanks for spotting the full path part. I've done this and changed the dots to underscores and still have the same message.

I've looked how the regular output tool reads this and added quotations marks and a $ to try and make it match. But still no joy!

[atcodedog05]

Hi @Will-G 

Dont do the 2nd step just do the first step.

Assign proper column in dynamic input tool.

Dont change dot to underscore.

@messi007 awesome job of spotting it 🙂👍