How To Get All The Folders And Subfolders From SharePoint Online Document Library Using PnP PowerShell

Thank You. Works well. I just wanted to get a script to list first level folders.

This will quickly hit the throttling limit in sharepoint online, if you try this for a large site. Also Get-PnPFolderItem -has a built in -recursive switch which is easier.

This is great although you have mixed $folder and $folderUrl parameters I think? When I test it ignores the parameter and searches from the top of the site URL. I fixed this by replacing GetFolders($folderUrl) with Function GetFolders($folder) and PnPFolderItem -FolderSiteRelativeUrl $folderUrl -ItemType Folder with PnPFolderItem -FolderSiteRelativeUrl $folder -ItemType Folder

$username = "3233232"$password = "2332XXX" $CSVpath=".\Input.csv" $cred = New-Object -TypeName System.Management.Automation.PSCredential -argumentlist $userName, $(convertto-securestring $Password -asplaintext -force) # Input Parameters $siteURL="https://aXXXXXom/sites/gecome" $folder="Documents/IT Department/IT" $outputReport="C:\Output.csv" # Loop through to get all the folders and subfolders $logdetails=@() Function GetFolders($folderUrl) { $folderColl=Get-PnPFolderItem -FolderSiteRelativeUrl $folderUrl -ItemType Folder if($folderColl.Count -eq 0) { # break; } else { # Loop through the folders foreach($folder in $folderColl) { $newFolderURL= $folderUrl+"/"+$folder.Name write-Host $newFolderURL $folderCollCount=Get-PnPFolderItem -FolderSiteRelativeUrl $newFolderURL -ItemType Folder $logData = New-Object PSObject $logData | Add-Member -MemberType NoteProperty -name "Name" -value $folder.Name $logData | Add-Member -MemberType NoteProperty -name "ItemCount" -value ($folder.ItemCount - $folderCollCount.Count) $logData | Add-Member -MemberType NoteProperty -name "Path" -value $newFolderURL # $folder.Name+","+($folder.ItemCount - $folderCollCount.Count)+","+$newFolderURL| Export-Csv $ExportFile -append $logdetails+=$logData $logData | Export-Csv $outputReport -append # Call the function to get the folders inside folder GetFolders($newFolderURL) } } } # Connect to SharePoint Online site Connect-PnPOnline –Url $siteURL –Credentials $cred # Call the functions GetFolders($folder) #$logdetails | Export-Csv $outputReport -NoType Pause

Doesn't work below the first level. The recursivity fails.

How to get all the files inside these folders please help if you have ? Thanks for getting the folders

How to also include folders ownership and also export all the result to csv?

I've been pulling my hair out with a variant of this script as it is not getting all the folders. It is missing quite a few. When I run this script exactly, I get the same results. I can go to the sharepoint list and see all the folders and I am using the same credentials. I have looked over the code and it looks right but it is just not getting everything. Don't know why. EDIT: I just figured it out. It's in your code to break. When a folder is empty, it breaks out and doesn't go through the rest of the folders after it. Remove that break condition and it works properly!

Nice Article...........