Back up Sharepoint list

Like (0) Share

Report

Posted on 28 Oct 2022 09:04:57 by IvanMeere

Good day all,

I have trouble building a scheduled flow where I want my Sharepoint list too backup or just copy the current list too a folder where I can access each list after the period has passed. And need too create a new list each time the flow runs not overwrite the old one.

I have tried

Copy SharePoint file then make the designation the folder but did not work.

I tried get items and then create new items ( in the SharePoint Library ) but also did not work.

May someone please help me.

All responses (6)

Answers (1)

CorgiMad 87 on 13 Nov 2023 at 14:45:19

Like (0)

Report

Re: Back up Sharepoint list

Hello gazzo1967
If the flow was to run daily, is there a way to just save on top of the previous days copy instead of having a new csv file added into a folder every day?
Thanks
Shelley
Verified answer

gazzo1967 1,151 on 02 Nov 2022 at 10:31:48

Like (2)

Report

Re: Back up Sharepoint list

@IvanMeere
Ok this will export all items as a csv.
To send an automated back up of your list to a folder

Add as your trigger and set the options to what you want.

Add Get Items

Add Create CSV Table with 'From' as 'Value' Get Items

Add A Compose
Select add Dynamic Content if not already showing.
Select 'Expression tab'
In the input box = utcnow('M')
This will give you the 'Month' if you want different use this page as a reference

Then Add either Sharepoint or Onedrive 'Create File'
Use Folder path to navigate to where you wish to store the file
File name Text name with OUTPUT from Compose (important ensure whatever you named the file the you end it with '.csv'
The second OUTPUT is from the Create CSV action

That will give you a CSV copy of all List items at the point of the run flow

If you look in the CSV one of the columns has the version number in it 🙂

Regards Gary
Please mark topics as solved if they are and give kudos to make people happy
IvanMeere 15 on 02 Nov 2022 at 05:30:37

Like (0)

Report

Re: Back up Sharepoint list

Good day yess that is true,
I got the copy right now. My problem is saving the version history of the lists
gazzo1967 1,151 on 01 Nov 2022 at 14:25:02

Like (0)

Report

Re: Back up Sharepoint list

@IvanMeere
Are you wanting to copy the list contents to a file at specific time schedule?
for example 1st every month?
Gary
IvanMeere 15 on 01 Nov 2022 at 06:56:25

Like (0)

Report

Re: Back up Sharepoint list

@gazzo1967
Hi,

My aplogy only for replaying now.

Please see a picture of my flow. I just want too know if you also know how too convert a csv file too pdf ?

PowerAutomate Flo...
gazzo1967 1,151 on 29 Oct 2022 at 13:04:56

Like (0)

Report

Re: Back up Sharepoint list

@IvanMeere
Hi
May help if you post a picture of what your current flow looks like 🙂
As they say a picture paints a thousand words 🙂
Gary