Get Team sites & Create Document Library in SharePoint with PowerShell PnP

I needed to create a new document library to all our project related SharePoint Team sites. We use Office 365 Teams for both business units as for our projects, so first we need to get a list of all Team sites within the tenant, then check if the site is a project related Team site to finally add a new document library to it.

To get the job done we are going to use PowerShell PnP : more info about PnP

Getting all Team sites using PowerShell

To get all the team sites we need to connect to the SharePoint Admin Center to retrieve a list called : DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS

Connecting to the admin center

You can use one of mine connector scripts for it here at Technet. Or connect to SharePoint with:

#Create credential object
$cred = Get-Credential

#SharePoint admin center url (note the -admin)
$siteUrl = 'https://contoso-admin.sharepoint.com'
 
#Import the Skype for Business Online PS session
Connect-PnPOnline -url $siteUrl -Credentials $cred

Get the Team sites

The SharePoint Online site collection is stored in a hidden list, called DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS .  To retrieve the content of this list we first get all the available list items

$site = Get-PnPSite
$site.Context.Load( $site.RootWeb)
$site.Context.ExecuteQuery()
 
$web = $site.RootWeb
 
$site.Context.Load( $web.Lists)
$site.Context.ExecuteQuery()

$web.lists

So in this case it’s the third item, so we use $web.lists[2] to get the teams sites

$lists = $web.lists[2]

Check if it’s a project related Team sites

Now I wanted to now it the Team sites in the list is project related. All our project sites have the same document libraries, so the easiest way is to check if a particular document library exist:

for ($x = 0; $x -lt $list.ItemCount; $x++ )
{
$item = $list.GetItemById($x)

$site.Context.Load( $item)
$site.Context.ExecuteQuery()

	if($item.FieldValues.SiteUrl -ne $null)
	{
		connect-pnponline -url $item.FieldValues.SiteUrl -cred $cred
		$getReferenceLibrary = get-pnplist -Identity 'Document Library Name'

		if($getReferenceLibrary -ne $null)
		{
			#Add new document library
		}
	}
}

We walk trough the list items, check if it as has SiteUrl, connect to the site with pnponline and stored credentials. Get the pnplist with the name ‘Document Library Name’, if it returns not null, then we can add the new document library.

Creating new Document Library

The last part is pretty easy, all we need to do is add a new Document Library to the Teams site. Just to be sure, we check first if the document library not already exists.

for ($x = 0; $x -lt $list.ItemCount; $x++ )
{
$item = $list.GetItemById($x)

$site.Context.Load( $item)
$site.Context.ExecuteQuery()

	if($item.FieldValues.SiteUrl -ne $null)
	{
		connect-pnponline -url $item.FieldValues.SiteUrl -cred $cred
		
		#Get reference library
		$getReferenceLibrary = get-pnplist -Identity 'Document Library Name'
		
		#Check if new library not already exists
		$checkNewLibrary = get-pnplist -Identity 'New Document Library Name'

		if($getReferenceLibrary -ne $null -and $checkNewLibrary -eq $null)
		{
			#Add new document library
			new-pnplist -Title 'New Document Library Name' -Template DocumentLibrary -OnQuickLaunch
		}
	}
}

Thanks to Pieter Veenstra for retrieving the Team Sites 

And to Veronique Lengelle for the Create Document Library part