Dynamic Rename xlsx file and combine output into sheets in CSV

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.

Dynamic Rename xlsx _ combine sheet in CSV.yxmd

Developer

Dynamic Processing

Accepted answers

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.

Dynamic Rename xlsx _ combine sheet in CSV.yxmd

All comments

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.

Dynamic Rename xlsx _ combine sheet in CSV.yxmd

Hi @k3pineapple , you can also try this,

In formula tool

Configuration for output tool

Output

Attaching the workflow along.

Thanks!

k3pineapple_Dynamic Rename xlsx _ combine sheet in CSV_Updated.yxmd

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

Quick Links

Tags

This months top contributors

erich_shiino 280