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

(3) Share

Report

Posted on by hpatel95

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.)

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.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
TomoFu 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No