Export Sharepoint List as an archive into an new excel table every 3 months

Like (0) Share

Report

Posted on 25 Apr 2022 15:26:42 by Community Power Pla...

Hello everyone,

I just created flow wich allows me every 3 months to export the data of a sharepoint list into an excel table. However what would be optimal for me would be to send those data in a new table (of the same excel file) every three month so that i can keep a organised record of the data. Does anyone knows how to create such a flow ?

Thank you. 🙂

All responses (2)

Answers (1)

Verified answer

v-yujincui-msft on 28 Apr 2022 at 07:43:51

Like (0)

Report

Re: Export Sharepoint List as an archive into an new excel table every 3 months

Hi @Anonymous ,

Do you want to save data from a SharePoint List to a new worksheet in excel?
I have made a test for your reference.

1. Here are my List and excel file.
2. Here is my Flow.
formatDateTime(utcNow(), 'yyyyMMdd')
Result Screenshots:

Best Regards,
Charlie Choi
v-yujincui-msft on 28 Apr 2022 at 07:41:29

Like (0)

Report

Re: Export Sharepoint List as an archive into an new excel table every 3 months

Sorry, please ignore this message(repeat).