cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RLeite
Helper III
Helper III

Backup a sharepoint list to OneDrive.

Hello.

 

I have a list on sharepoint that is used by many users and I would like to create an automation to backup that list everyday, at night, to a folder in my OneDrive.

 

Can you please help me do that?

 

Thank you.

2 REPLIES 2
Rhiassuring
Super User
Super User

Hi @RLeite , 

Sure - you'll probably want to use Excel, so, create an Excel spreadsheet with a named Table in it, that will hold all the columns you want. Store that in your OneDrive.

Then, the flow will be pretty simple!  Schedule, get all items, (do something*), add a row (iterate through), done!

* = Do you want to save a new copy each day, or overwrite the previous one? The below is just showing how to populate a single existing Excel file. We'd want to take a copy first and populate a new one if that were the need.

 

Rhiassuring_0-1649470297775.png

 

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



RLeite
Helper III
Helper III

Hello.

 

I would like to create a new file everty time the automation runs.

What should I use after the RECURRENCE and the GET ITEMS?

 

Thank you.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,707)