Clone or Copy SharePoint Online Site Collection With Lists Content

By -
Modern problems need modern solution...!

Although we have spent years with SharePoint On-Premises but its time to move on SharePoint Online. Being SharePoint Administrator in past, now you may have to deal with Microsoft Cloud Admin. It was pretty easy in good old days to copy or clone a site using backup restore or using export import methods. However, that thing do not work anymore in SharePoint Online. You have to try different approach and syntax for this. There are several articles on this but I found this one which lead me to different type of errors and ultimately to the actual solution I was looking for. Here is how I did it...

There are three main components in this article.

  1. Create a Site in SharePoint online with some dummy data
  2. Use PNP PowerShell to backup the site template and list data
  3. Create new site and restore the template


Important : The commands I will be using in this article are different than the used in above mentioned article. To run these commands, you need to get rid of the legacy SharePoint PNP Online and Install the PNP PowerShell. Please see this detailed article or run the below commands.

Uninstall-Module -Name "SharePointPnPPowerShellOnline" -AllVersions -Force



Install-Module -Name "PnP.PowerShell"

1. Create a Site in SharePoint online with some dummy data

Let's create a new site for this.



Site has been created. Now lets create a list and add some items.


Add a new custom column.



Add some dummy data.


2. Use PNP PowerShell to backup the site template and list data

Run the below commands to export the template. (Full script is on the end)



3. Create new site and restore the template

Create new site is pretty easy in SharePoint Online using PNP.


Note: The syntax is different to create a modern communication site and modern team site. Check this for complete details. Also, you need to be very sure that your source and target sites templates are same. Check full details here. For example

To create Modern Team Site (Our case): 

New-PnPSite -Type TeamSite -Title 'Shadow of Teams' -Alias ShadowTeams

If you want to create Modern Communication Site:

New-PnPWeb -Title "SubSite of Modern Team s" -Url SubSiteTeams -Description "Creating Subsite of Teams" -Locale 1033 -Template "STS#3"

SharePoint Online Site Templates names:

Template IDTitleDescription / Additional Info
STS#3Team site (no Office 365 group)A site with no connection to an Office 365 Group.
SITEPAGEPUBLISHING#0Communication sitePublish dynamic, beautiful content to people in your organization to keep them informed and engaged on topics, events, or projects.
GROUP#0Office 365 Group associated Team SiteFor Reporting Only – You cannot create sites with this template
POINTPUBLISHINGPERSONAL#0Delve BlogFor Reporting Only – Delve Blogs are being Retired
SPSPERS#10OneDrive for Business personal SiteFor Reporting Only – Use the Request-SPOPersonalSite cmdlet to pre-provision a OneDrive for Business ite
RedirectSite#0Redirect SitePlaceholder template for the old URL when you rename the Site URL. This is for reporting only and those sites are only created by Microsoft programmatically.
TEAMCHANNEL#0Teams Private Channel SiteLightweight Site Collection provisioned for each Teams Private Channel Site. This is For Reporting Only, and not for manual provisioning trough SharePoint Online



Lets verify the site now.








Complete Script

Connect-PnPOnline -interactive -URL "https://sharepointerguy.sharepoint.com/sites/ModernTeams"
Get-PnPSiteTemplate -Out "D:\Temp\MyApplications.xml"
Add-PnPDataRowsToSiteTemplate -Path "D:\Temp\MyApplications.xml" -List "Food Items"

New-PnPSite -Type TeamSite -Title 'Shadow of Teams' -Alias ShadowTeams

Connect-PnPOnline -interactive -URL "https://sharepointerguy.sharepoint.com/sites/ShadowTeams"
Invoke-PnPSiteTemplate -Path "D:\Temp\MyApplications.xml"

Bingo...!





Comments

Post a Comment

Popular Posts

GREYCstoration Oil Paint plugin for Photoshop

By -
Image
Oil Paint Filter is missing in Photoshop? Try GREYCstoration plugin. An alternate for Oil Paint filter. I found my Adobe Photoshop CS5 is missing Oil Paint filter plugin due to GPU unavailable on my machine. I found an alternate tool to get oil painting effect on photos. Below are the steps to use this tool. 1.  Download  tool and extract http://www.mediafire.com/download/3j15dj3opmip4ez/GreycShop.zip 2. Copy the extracted files on below path(s)     For 64Bit: C:\Program Files\Adobe\Adobe Photoshop CS5 (64 Bit)\Plug-ins     For 32Bit: C:\Program Files (x86)\Adobe\Adobe Photoshop CS5\Plug-ins 3. Run Adobe Photoshop 4. Select Noise >> GREYCstoration  For example: Enjoy :)
Read more

Service Bus Gateway service stuck at Starting

By -
Image
Lesson Learned: Never leave your servers to automatically download and install the updates. We had a SharePoint farm where Workflow manager is configured on one of its server and rest of them are just using WFM client to connect with the server. Everything was running smooth until some updates got installed on the servers over night and the next morning Workflows stuck and start giving errors. As initial check, I verified SharePoint services and WFM services, noticed that the Service Bus Gateway service is struck at Starting state. This was very generic thing but at least a point to start thinking... Troubleshooting: 1. Tried manual restart, but no luck. 2. Tried Leaving and Joining the WFM Farm again. But the timeout error. Error message received during rejoining:  “Starting Service bus gateway on machine <servername> failed: timeout has expired and the operation has not been completed” 3. Tried ULS check and noticed below error. "  Service cannot be started. Microsoft.Ser
Read more

PowerApps SubmitForm not clearing People Picker value

By -
Image
Although its a great experience working with Microsoft products but sometimes they surprises you with bugs that being a developer you would not expect. You may come across the problem that PowerApps SubmitForm is not updating data in SharePoint list, specially the People Picker type field (could be the same case with datetime type as well. Same thing I have experienced that while working on a PowerApps form which is connected with simple SharePoint list, I was unable to update the value of People Picker control which was having no special settings in SharePoint, just simple out of the box list with Title and a People Picker column. Spent hours on it but no gain. Finally the Google, a friend who can help you to find the right thing if you search for it. I came across this and this post and found similarity. Made the same changes and boom...! It worked..! You just need to turn ON the Fomula level error management under the Advance Settings. Below is the settings which I set to Yes. Have
Read more

Apple iPhone sending SMS automatically 00447786205094

By -
Image
Hi There, I have just noticed that my credit is being deducted from my mobile account. I am in Pakistan and using Warid Tel network. I see my mobile credit details after few hours on my screen. This facility is provided only by Warid Telecom that they provide your credit details each time you make a call or send SMS. I checked my Message,Calls logs emails logs etc but no point where i can check that why me credit is being deducted. Absolutely nothing found. :-/  I called Warid Tel support center and the guy told me that there are 4 SMS that have been sent internationally from my iPhone 5. Whattt???? :O I have't sent even a single one. He was bound not to tell me the number however i found that number from Warid Tel online customer portal. That magical number was  00447786205094. Warid Web Self Service Portal I googled and found that its UK number and an iPhone application Facetime/iMessage used to send text to this number for their activation without
Read more

SharePoint online hub navigation not updating for other users

By -
Its been quite a time that I am working with SharePoint Online and meeting new challenges every day. Its feels great when you find a solution for something which Google do not tell you. I am just writing this post because there might be someone out there facing the same issue and this post might help him. BTW, before you check the actual post of how to fix the navigation check below, this might also help to change the user language. Problem Description: When an Admin of SharePoint Online site, updates the hub navigation (or may be site navigation), it do not get updated for all the users instantly. User has to clear browser cache to get the updated navigation. As per discussion with Microsoft, SharePoint saves a copy of the navigation in browser cache which automatically refreshes after a certain period of time. By default, you cannot clear browser cache using React or JS code. Browsers do not allow you to do so. So, the user should wait till that time? ABSOLUTELY NOT! (Imran Khan 😋 )
Read more