Dynamic Input (with few rules)

[mohit9garg]

Hi,

I need your help to construct a Dynamic Input tool with few rules & conditions.

• In a sharedrive path (a fixed directory)
• we would have a folder (somewhere there) for last working day and that date would be the folder name; for example, if today's date is 25th May then folder name would be 20200522. But date format is not fixed.
• the file name would have 'xyz' but should not have 'pqr'; file name would also have the folder date. like 20200522; but again date format is not fixed.
• File format could be any excel format (.xls , .xlsb , .xlsx..)

Then workflow should process that file.

Kindly guide me.

Mohit

@grossal @DavidP 

[mohit9garg]

Thanks @grossal 

So I created a workflow as below-

But I am facing 3 issues-

1) Each file is appearing 10 times like below- 

I need only today's date (not future dates) and last working date. We can skip days' name (i-e, today's day & Last working day) if possible-

2) Then I applied a "FILTER" to filter out the required folder i-e, for last working date.

Hence, "Directory" should contain "last working date"-

3) Date Format is yyyymmdd. (today date is 20200622)

Please help.

Regards,

Mohit

[grossal · Accepted solution]

I probably should have said this, but the Generate Rows was only for the creation of sample data. Remove it in your workflow.

Use the DateTime Tool to convert the name to a date like this: 

Make sure to name the Field 'Date' (or rename it in the formula accordingly)

Best

Alex

[mohit9garg]

Hi @grossal, I created a workflow like this; which is working fine. Do you foresee any issue here-

Last Working Date's outcome after using 'DateTime' tool-

Filter Tool-