Salaudeen Rajack

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

3 thoughts on “SharePoint Online: Convert Folders to Metadata

  • Hi Salaudeen, Hope you are fine! can you please give a hint for the Sub folders as well, if I need to add Subfolders as choice column. thanks

    • You mean, You want to use the Sub-Folder names as choices (Instead of Folders in the root of the library)? Use:

      $SiteURL= “”
      $ListName = “ProjectList”
      $MetadataColumnName = “Project”

      #Connect to PnP Online
      Connect-PnPOnline -Url $SiteURL -Interactive

      #Get All Folders from the library
      $List = Get-PnPList -Identity $ListName -Includes RootFolder.Folders
      $Folders = $List.RootFolder.Folders

      $Choices = @()
      #Get 1st level Subfolders of the Folders in the library
      ForEach($Folder in $Folders | Where {$_.Name -ne “Forms”})
      $SubFolders = Get-PnPProperty -ClientObject $Folder -Property Folders
      $Choices += $SubFolders | Select -ExpandProperty Name
      #Get subfolder names as choices

  • Thank you for sharing your knowledge.


Leave a Reply

Your email address will not be published. Required fields are marked *