Create an Excel Workbook

[Noah100]

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

[efialttes]

Hi @Noah100 !
I would do the following: 

I just got the expression to calculate week number from this topic as suggested by one of the best superusers: @Pstork1 
I've just tested manually the recurrence flow, and verified w34 has been added to my excel

Hope this helps!

[Noah100]

@efialttes 
Will creating a new worksheet automatically create a new workbook? I need an entire new excel file to be created. 

[SamLed · Accepted solution]

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:

• Create an Excel template file, store it in a template dedicated SharePoint library
• Get content from template xslx, create new file in another location.
• Work on newly created file to add data.

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

[caseyisaac]

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. 

[SamLed]

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.

[efialttes]

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!

[Noah100]

@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?

[SamLed · Accepted solution]

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.

[Noah100]

@SamLed 
Thank you, that worked out great!

[caseyisaac]

Then I would use XLSX vs CSV