Dynamic Rename xlsx file and combine output into sheets in CSV

[k3pineapple]

Hi All,

I have some obstacles to dynamic rename the .xlsx files , I tried on my flow in .CSV it works. I would like to dynamically rename xlsx file, because it can combine my output into different sheets, but CSV cannot.

Additionally, I do not want to dynamically rename the sheet tap, but only the file name, but my flow seems will change that as well, needs to be fixed. 

My flow has attached below.

Thank you for your time. :)

[gabrielvilella · Accepted solution]

For Excel files, you need to create the full path within the formula, then use this field on the output data to replace the entire path.

[grazitti_sapna]

Hi @k3pineapple , you can also try this,

In formula tool

Configuration for output tool

Output

Attaching the workflow along.

Thanks!

[k3pineapple]

Thank you for the awesome idea, but I do not want to change the sheet name, but only the file name

[grazitti_sapna]

@k3pineapple in that case you will have to specify the full path in the formula tool as mentioned by @gabrielvilella . You can use my post for future references in case you need to work with sheets. Glad that we could help!

Thanks!

[k3pineapple]

@grazitti_sapna Thank you for your idea.