Get All Document Libraries in SharePoint Online using PnP PowerShell

Requirement: Get all document libraries in SharePoint Online using PowerShell PnP

PnP PowerShell to Get All Document Libraries in SharePoint Online

Would you like to get a list of all document libraries on your SharePoint Online site? PowerShell makes it easy! I’ll show you how to use PowerShell to get a list of all document libraries on your site in this post.

Document libraries can be filtered from the Lists collection by either base template or base type properties. Here is how:

#Set Variables
$SiteURL = "https://crescent.sharepoint.com/sites/marketing"
 
#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Interactive

#Get all document libraries - Exclude Hidden Libraries
$DocumentLibraries = Get-PnPList | Where-Object {$_.BaseTemplate -eq 101 -and $_.Hidden -eq $false} #Or $_.BaseType -eq "DocumentLibrary"

#Get Document Libraries Name, Default URL and Number of Items
$DocumentLibraries | Select Title, DefaultViewURL, ItemCount

This PowerShell script gets all document libraries from the given site URL, along with the library URL and a number of items in each library.

Get all document libraries in SharePoint Online using PowerShell PnP

Here is another script to get all document libraries in SharePoint Online site using CSOM PowerShell: SharePoint Online: PowerShell to List All Document Libraries

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

2 thoughts on “Get All Document Libraries in SharePoint Online using PnP PowerShell

  • Really great information here.

    I have a Document Library that contains many pdf’s titled 12345.pdf. Each pdf has a corresponding xml file that share the same 12345 prefix (12345.xml)

    Is there a way for me to iterate through the Document library, grab the matching xml file, and import the xml values into the corresponding meta data properties of each pdf in the Document Library?

    Any suggestions or hints you can point me towards is very much appreciated.

    Thank you

    Reply

Leave a Reply