Skip to main content

Create bulk Sub site Using power shell script using custom SharePoint template


#Add references to SharePoint client assemblies and authenticate to Office 365 site
Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.dll"
Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.Runtime.dll"

$Username = Read-Host -Prompt "Please enter your username"
$Password = Read-Host -Prompt "Please enter your password" -AsSecureString
$Site = "https://xxxx.sharepoint.com/sites/sPOTest2/"
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($Site)
$Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username,$Password)
$Context.Credentials = $Creds
$csvLocation = "C:\Users\AA82211\Desktop\PS_SiteCollectionsToCreate.csv"
$csv = Import-Csv $csvLocation

#List Custom Templates
$Templates = $Context.Site.GetWebTemplates("1033","0")
$Context.Load($Templates)
$Context.ExecuteQuery()
$Templates | Where {$_.Name -like "*{*" } | Select Name, Description
 
$WCI = New-Object Microsoft.SharePoint.Client.WebCreationInformation
$WCI.WebTemplate = "{74B55E3E-D15D-4F56-BFA0-DE73BC1CF81F}#TemplateV2_0"

ForEach ($site in $csv)
 {
 $site = $($site.SiteCRelativeUrl)

    $WCI.Description = " Team site "
    $WCI.Title = $site
    $WCI.Url = $site
    $WCI.Language = "1033"
    $SubWeb = $Context.Web.Webs.Add($WCI)
    $Context.ExecuteQuery()

    Write-Host "----------------------------------------------------------------------------"  -foregroundcolor Green
    Write-Host "Site Collection-Subsite" $newWeb.Title "succesfully created!!!"

    Write-Host "----------------------------------------------------------------------------"  -foregroundcolor Green
}

-Replace Web template with your web template id, you get web template once you run this screept      copy  and paste from their.
-download PS_SiteCollectionsToCreate.csv from google.

Comments

Popular posts from this blog

SharePoint Framework extensions to Call Azure Function

In this article, we will talk about prerequisites, how to call Azure Function from SPFX extension, How to Create HHTP function, connect Visual Styuid editor to Azure and publish them, and Set Up CORS on the Azure Function, Create SharePoint Framework Extension, Azure Function, etc. Prerequisites :  Azure Subscriptions   VS code  Spfx Development Env  -   Step by steps details: https://docs.microsoft.com/en-us/sharepoint/dev/spfx/set-up-your-development-environment  Follow the below steps to create Azure Functions in the Azure portal.  Steps by steps guide:  https://docs.microsoft.com/en-us/sharepoint/dev/spfx/use-aadhttpclient-enterpriseapi    Reference :  https://docs.microsoft.com/en-us/answers/questions/430645/how-to-access-sharepoint-rest-api-in-my-function-a.html Step-1 : Login to Azure Portal (https://portal.azure.com/)   Step-2 : As highlighted below, click on the  + Create a resource, and click on “Compute”. Now, choose the “Function App”.   Or, for the same Option, you can sea

Responsive design for Seattle.master in SharePoint 2013 and SharePoint Online.

/* =SharePoint Experts, Inc. - CSS for creating a responsive design for Seattle.master in SharePoint 2013 and SharePoint Online. For more details see the related blog post at http://blog.sharepointexperience.com/2015/03/making-seattle-master-responsive -Copyright SharePoint Experts, Inc. and Heather Solomon. Distributed to the public for reference and educational purposes. Code may be used as long as this copyright message stays intact. -sharepointexperience.com */ /* Font Awesome is a free font. http://fontawesome.io Check for latest version at http://fontawesome.io/get-started This should be moved to the top of your CSS file, irregardless of media queries */ @import "//netdna.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.css"; @media screen and (max-width: 1044px) { /* Hide unnecessary page elements */ .ms-core-listMenu-horizontalBox .ms-listMenu-editLink  /* Global navigation "Edit Links" when managed navigation is in use */ { displa