Has anyone written a PowerShell script that takes metadata from the top folder and sets the metadata to sub folders and documents

Question

We have a library with a folder for each year then under the year with a number of folders and under each folder can be up to 12 subfolders all storing various different documents. For some reason the subfolders and documents have not inherited the metadata from the top folder.

So the structure is as follows

Library> Year Folder i.e. 2022

                      Folder A (Has metadata)  

                           sub folder (no metadata)  

                           sub folder (no metadata)  

                                 sub folder (no metadata)  

                    Folder B (Has metadata)  

                           sub folder (no metadata)  

                           sub folder (no metadata)  

                                 sub folder (no metadata)  

each sub folder can have x amount of docs in it and i need the metadata on folder A to be updated in those sub folders and then the metadata in folder B to update the folders below that folder.

This can't be done manually as I have so many folders and documents pushing on 800,000 in total

I'm a relative novice to PowerShell so anything simple will be appreciated

Answer 1

Hi @Glenn Skinner
I will recommend you to use pnp powershell to reach your requirement. Please refer to following code

#Parameters  
$SiteURL = "https://xxx.sharepoint.com/sites/test"  
$ListName = "SPDocuments"  
$CreatedBy= "******@xxxx.com"  
   
#Connect to PnP Online  
Connect-PnPOnline -Url $SiteURL -Interactive  
    
#Get the all subfolders in folder A  
$folders = Get-SPOFolderItem -FolderSiteRelativeUrl "/SPDocuments/2022/A" -ItemType Folder   
    
#Update document properties  
foreach($folder in $folders){  
	Set-PnPListItem -List $ListName -Identity $folder.Id -Values @{"Author" = $CreatedBy}  
}  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

Were you ever able to find a solutions. I gave it a shot, I have a halfway descent script that is working but it does need a little work. I need help if you solved it.

Answer 3

I know this has been answered with a proposed solution.

I would recommend you investigate using Document Sets, there whole reason for being is to do what you are asking for.