Skip to main content

Notifications

Community site session details

Community site session details

Session Id : sRN4SNmw6YzXustr5Okcxx
Power Automate - General Discussion
Unanswered

Backup a sharepoint list to OneDrive.

Like (1) ShareShare
ReportReport
Posted on 8 Apr 2022 16:24:52 by 126

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.

  • amit-mishra Profile Picture
    12 on 21 Mar 2025 at 08:12:57
    Backup a sharepoint list to OneDrive.
    Shoviv Cloud Drive Migrator is excellent for migrating data between cloud platforms, you can sechdule your backup tasks with this tool so that you can also get automated, daily backups of a SharePoint list to OneDrive. Download a free trial.
     
  • RL-26071304-0 Profile Picture
    126 on 12 Apr 2022 at 10:22:09
    Re: Backup a sharepoint list to OneDrive.

    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.

     

  • Rhiassuring Profile Picture
    8,688 Super User 2025 Season 1 on 09 Apr 2022 at 02:12:18
    Re: Backup a sharepoint list to OneDrive.

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

Overall leaderboard
Loading started