How to include the Renaming tool in Blob Workflow

[KamenRider]

Hi,

I have a workflow where I am using blob to copy the template. I have successfully copy the template and the data on it and my only problem is the renaming part which until now I can't figure it out. For example the name of the file is Completed Accounts and I wanted it to be rename by adding the date today. I have tried the dos command but always give an error "Error Code 1"

I am asking someone to kindly help me solve this dilemma. I will be very much  grateful. Below is the structure of the last part of my worfklow.

 

Thanks and looking forward for everyone's assitance.

Kamen

[Christina_H]

In the Blob Output tool there is an option to rename the file using a field.  All you need to do is create the filename you want including the date, and use that when outputting the Blob.

[KamenRider]

Hi @Christina_H 

Thanks for the reply. Will it be possible to rename it as Datetimetoday + filename.xlsx? Please teach me how I am going to do it in my workflow?

Thanks and appreciate your response.

Kamen

[Christina_H · Accepted solution]

In your formula tool, create a file name field with the formula: ToString(datetimetoday())+" filename"

You don't need the extension.

Then in the Blob Output tool, select the option for Replacing File Name with Field, and select your new field.

[KamenRider]

Hi @Christina_H 

I think my problem is where to put or place the formula tool in my workflow. I placed it beside the output blob tool but somewhat gives me an error. I tried many ways but still not able to figure it out. My last try gives me an error "Specified range is not large enough for incoming data fields."

 

Please see below scenarios I made to give you more idea how can solve the puzzle. 

 

 

 

 

 

 Please advise where do I get wrong? and how I am able to correct this.

Thank you and looking forward for your continued assistance.

Kamen

[Christina_H]

@KamenRider The error you're getting is on the Output tool, not the Blob Output.  Is the Excel document being successfully copied with the new name you want?

I believe the error is due to the Preserve Formatting option.  The range you've specified isn't big enough for the data you're trying to export into it.  Try exporting to a new workbook, and compare the data range to your template to see what's going wrong.

[KamenRider]

Hi @Christina_H 

Thanks for the advise. I somewhat increase the range from S to Z. The template actually is A to Z however the range T to Z does not always contain data. I'm not sure if it has bearing as being a template but when I run the workflow it works fine. The Excel has been successfully copied and the new file name containing the date has been achieved.

Thank you for your assistance. Hoping to see you if I have inquiries.

regards,

Kamen