Iterate through root site and subsites libraries

[pratheep-r]

I am trying to loop through libraries in sub sites and main site. The below script only getting the libraries from main site only.

$SiteURL = "YourSite"

#Connect to PnP Online
$Creds = Get-Credential
Connect-PnPOnline -Url $SiteURL -Credentials $Creds

#Get all subsites in a SharePoint Online site
$Subsites = Get-PnPSubWeb -Recurse -IncludeRootWeb

foreach ($Site in $Subsites)
{
Write-Host $Site.Url
Get-PnPList | Where-Object {$.BaseType -eq "DocumentLibrary" -and $.Hidden -eq $False}
}

I'd appreciate some help. Seems I am missing something here.

[AndersRask]

You should get all subwebs as long as you specify -Recurse

Maybe you dont have access to the subsites?

The code works as intended for me, but i noticed a small typo though in your where filter: it needs to be $.BaseType and $.Hidden ($_ is an alias for $PSItem )

[pratheep-r]

Thanks for trying.
I am not sure if I follow you re: typo. Looks like text window removing "_". Please see the attached image

If you see the second screen shot, subsite and nested sub sites looped through. However the libraries are only iterated in root site.

[pratheep-r]

Also I have site collection admin access.

[AndersRask]

Ah yes good point!

The Get-PnPList in the loop need to know that you are pointing to a new subweb!
You do this by connecting to the subweb inside the loop. Try something like this:

 foreach ($Site in $Subsites)
{
    Write-Host $Site.Url
    Connect-PnPOnline -Url $Site.Url
    Get-PnPList
}

[pratheep-r]

Fab, spot on - it worked. Thanks for the help