I have a SharePoint online list with more than 9000 items and 22 column. The list is being populated on daily basis.
I am taking backup manually every morning by saving the list as excel file in the document library and in my local computer.
I need a Powershell script for SharePoint Online to save my list as xml file and then I can create a windows task to run it daily.
PowerShell for SharePoint Online has really limited capabilities at the moment. There is no one liner to automate this task. But you can use CSOM inside your scripts.
[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SharePoint.Client') | Out-Null
$login = '[email protected]'
$password = ConvertTo-SecureString 'password' -AsPlainText -Force
$webUrl = 'https://test.sharepoint.com/sites/test/'
$listName = 'My List'
$context = New-Object Microsoft.SharePoint.Client.ClientContext $webUrl
$context.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials $login, $password
$web = $context.Web
$list = $web.Lists.GetByTitle($listName)
$query = New-Object Microsoft.SharePoint.Client.CamlQuery
$items = $list.GetItems($query)
$context.Load($items)
$context.ExecuteQuery()
$items | Select @{ L = "Title"; E = { $_["Title"] } }, @{ L = "Created"; E = { $_["Created"] } } | Export-Csv -Path export.csv
Of course it is far from final solution. There are following issues with the script:
ViewFields with the query to limit data loaded from database.RowLimit and paging.ConvertTo-* methods to format your result.Here is the sample that explains the syntax:
Export-SPWeb -Identity "http://sp.dev/subsite" -ItemUrl "/subsite/lists/List Title here" -path "c:\output\tempfile.csv"
Some Where Options:
Identity: full url (absolute) of the site where the list exists
ItemUrl: relative path of the list from subsite level. Do not forget to include the leading “/”
Path: path of the output file to save the data in. This does not need any extension but I usually give it .txt.
There are lot more additional parameters but above are the minimum for copying a list
For more details please refer to below links:
How To Export/Import a List Using PowerShell
Use Windows PowerShell to export a site, list, or document library
