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

Flow to save weekly backups of a sharepoint list in onedrive

Anybody knows if there is a template flow to create weekly backups of a sharepoint list and save it in onedrive?

If a template like that does not exist, can anyone provide some guidance on how to do it?

 

Thank you in advance!

4 REPLIES 4
Super User
Super User

Re: Flow to save weekly backups of a sharepoint list in onedrive

What is the format of the file that you want to store in OneDrive?

 

You could do a get items action to collect the items in a list.

 

Then convert the content from the list into a json object (with a parse json action). 

 

Then use the create file action to save the json as a file in your one drive.

Jorge_fer_gon
Level: Power Up

Re: Flow to save weekly backups of a sharepoint list in onedrive

Would it be possible to program a weekly export to excell and automatically store the excell file into onedrive? Is there a template flow for that?

 

Thank you

WDRC
Level 8

Re: Flow to save weekly backups of a sharepoint list in onedrive

@Jorge_fer_gon,

There may not be a template, but you cannot save the list to excel direct, you will have to create a CSV file instead, a little bit of resurch on the forum should come up with something on that.  I have created a few save to CSV flows from a SP list and all genarally work okay.

@Pieter_Veenstramay have some other ideas as he is an expert on if you can change the CSV file into a full *.xlsx file, hopefully I may learn something to.

Regards,

Andrew

 

 

 

 

 

Highlighted
KarinaArceo
Level: Power Up

Re: Flow to save weekly backups of a sharepoint list in onedrive

I found this flow: 

Copy SharePoint list items to a CSV file every week. Hope it helps you.

 

 

 

flow.JPG

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

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 Solution Authors
Top Kudoed Authors
Users online (7,017)