cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kg1375
Level: Power Up

Create a new excel workbook

Hello,

 

I'm looking to automate the creation of a new spreadsheet daily at midnight within my Sharepoint, with the new spreadsheet filename showing the current date.  I would then like to pull in certain data from the previous day's spreadsheet into the new spreadsheet, based on certain fields.  Could someone point me in the right direction?

3 REPLIES 3
Community Support Team
Community Support Team

Re: Create a new excel workbook

Hi @kg1375,

 

It seems that you are working with Excel file saved on SharePoint library.


But I am afraid that currently we are not able to get rows from the Excel table in SharePoint library then create a new Excel file automatically within SharePoint library.


There is a similar request on Flow Ideas Forum, please vote the idea at here:
https://powerusers.microsoft.com/t5/Flow-Ideas/Excel-get-row-connection-from-SharePoint-Library/idi-...

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kg1375
Level: Power Up

Re: Create a new excel workbook

Thank you for the response.  Two follow-ups - 

 

1) Is there a 'flow' just to create a new file and not pull in the data?  The creation of the file would be a higher priority.

2) I am using sharepoint, but could this be accomplished via OneDrive? 

Community Support Team
Community Support Team

Re: Create a new excel workbook

Hi @kg1375,

 

For question 1, no.

Microsoft Flow need the actual data (File content) to create the corresponding file.

 

For you second question, yes. You could switch to OneDrive for Excel.

Check:

Excel

 

Regards,

Michael

 

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,831)