Post
Ask Question

Create Library and Nested Folder Structure in SharePoint Using PnP PowerShell

Overview
 
I am going to show how to create a Library and Folder structure using PnP PowerShell.
 
Below is the folder structure.
 
 
 
One way to create folders is manual but it is a time-consuming process and error-prone. Another method is to create folders using PowerShell.
 
Pre-requisites
  • PowerShell installed on your machine.
  • PnP package installed and updated.
Below is the code
  1. $Url =Read-host "enter url"
  2. $filePath="Path/name.csv"
  3. # Reads the csv file and gets all records in one collection
  4. $rowCollection = import-csv $filePath
  5. $libName="Library name"
  6. $libDisplayName="Display name for library"
  8. ########################################################## Create Folders in Library ######################################
  10. function CreateFolders()
  11. {
  12. Connect-PnPOnline -Url $Url -Credentials(Get-Credential)
  13. Write-Host "Site Connected"
  14. Remove-PnPList -Identity FSCAudit
  15. New-PnPList -Title $libDisplayName -Url $libName -Template DocumentLibrary -OnQuickLaunch
  16. Write-Host "Library created"
  17. foreach ($myRow in $rowCollection) {
  18. try {
  19. if(![string]::IsNullOrEmpty($myRow.'Folder')){
  20. Add-PnPFolder -Name $myRow.Folder -Folder $libName
  21. Write-Host "Folder created - " $myRow.Folder
  22. $pathSemiFolder=$libName+"\"+$myRow.Folder
  23. if(![string]::IsNullOrEmpty($myRow.'SemiFolder'))
  24. {
  25. $option = [System.StringSplitOptions]::RemoveEmptyEntries
  26. $($myRow.SemiFolder.split(',',$option)).foreach{
  27. Add-PnPFolder -Name $_ -Folder $pathSemiFolder
  28. Write-Host "Folder created - " $_
  29. }
  30. }
  31. else {
  32. Write-Host "Sub folders does not exist"
  33. }
  35. }
  36. else {
  37. Write-Host "Folder name is empty"
  38. }
  40. }
  42. catch {
  43. Write-Error -Message $Error[0].Exception.Message -ErrorAction Continue
  44. }
  47. }
  49. }
  52. #################################################################################################################
  54. CreateFolders
Run script using PowerShell Command prompt.
 
Once the script is completed, you can see the Library and the folder structure in SharePoint.
 
This is helpful if you get frequent requests for creating a nested Folder structure.