Hello Community!
Is there a way to create a new Excel workbook in a recurrence flow? I need a new workbook created once a week if this is possible.
Thank you,
Noah
Then I would use XLSX vs CSV
Hi,
Add .xslx after your outputs in the file name field of your create file action.
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
@SamLed
Here is a screenshot of my flow and all it returns into my files on OneDrive is a text document. Is there something I am doing wrong? The Compose actions are just to get the Monday date and Friday date of any given week and the MonFri is (Monday Date) to (Friday Date) so that I can name my workbook that weeks date range.
I used the file content of the Template workbook for file content in the create file action. Why did it only return a document?
OOOps! My fault!
In such case please follow @SamLed advise, as soon as you handle an excel file as a template, you can just create a new file taking the file template as the content basis.
Assuming you are working with a Sharepoint site / Teams:
Some time ago I published a post on how can you create an Excel file from a template and add rows to a Table, all in a single flow
https://anyonecanautomate.com/power-automate-y-el-hechizo-para-crear-archivos-excel-1c5d20002287
Hope this helps!
Hi @caseyisaac,
CSV file format is not an Excel native one, Excel can deal with CSV files but it won't convert it into Excel format until you save it as right format.
So your solution don't create a new Excel workbook.
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
I would use the Compose option, use the dynamic data to have this separated by commas so that when the output is generated you have the data you want for a CSV format, then use craete file for One drive and in the file name, name it with a .CSV to make excel.
Hi Noah,
There is no action to create a new Excel file (Workbook) from scratch, but I faced same need and I managed to solve that this way:
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
@efialttes
Will creating a new worksheet automatically create a new workbook? I need an entire new excel file to be created.