Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

How to create clone SharePoint list (as backup) | or export excel | using Power Automate

(3) ShareShare
ReportReport
Posted on by 47
Hello fellows,
 
I have SharePoint list which has many editors.
 
I want to create backup SharePoint list and clone all data what is in Original SP List. 
I want to do it automation here. (It can be not run always when we add any data in list, but I want to run the flow every week for example.)
 
Or
 
How I can create automation to export all data in excel file. (It can be not run always when we add any data in list, but I want to run the flow every week for example.)
 

For now, I created flow which is looks like this.
 
 
 
 
Here, when I run the flow manually, it is coping same data which exists as well. 
for now, I set here 5000 Threshold as we have 5000 limits in lists.
 
What trigger condition or setting I can do so the flow only clone data which is not available.
 
For example, flow can check ID row and if this ID exist in backup list, it should not copy. Only copy which ID is not in the list.
 
 

 
I need to set the condition and I need your help. 
Also, How I can extent these 5000 limits? do we have any request form?
 
Thank you in advance.
  • TomoFu Profile Picture
    TomoFu 8 on at
    How to create clone SharePoint list (as backup) | or export excel | using Power Automate
    Hi, 
     
    Or
     
    How I can create automation to export all data in excel file. (It can be not run always when we add any data in list, but I want to run the flow every week for example.)
     
     
    Easiest way is to create CSV file with recurrence trigger
     
     
    File then can be stored on sharepoint/sent to email etc. 
     
    Kind regards
    Tomek
  • Suggested answer
    FLMike Profile Picture
    FLMike 31,580 on at
    How to create clone SharePoint list (as backup) | or export excel | using Power Automate
    Hi
     
    I am confused, you said you wanted to make a backup (clone) of a list, but then you said you wanted to export to excel. Why?
     
    First
     
    1. You should go to the environment, click New, List
    2. Select an existing list in that environment
    3. add the word Backup or Clone to the name, as it will say it already exists
     
    Now you have a table that matches exactly what the other one is.
     
    Now, you should create a Trigger that is when something is Modified, or Added
    and how the flow write to the backup
     
    If you dont want that thats fine, but then you have alot of work to validate what gets created and what gets updated.
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard