Unanswered

Create a new excel workbook

(0) Share

Report

Posted on by kg1375

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?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-yamao-msft on at

Like (0)

Report

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-p/32140

Best regards,
Mabel Mao

Was this reply helpful? Yes No
kg1375 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-micsh-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No