Add values to folder columns in a SharePoint Online document library with PowerShell

Question

I have a library in which custom columns were added but I have not been able to add the corresponding values when creating the folder or modify it once the folder is created in SharePoint Online. For example:

I have verified with the Add-PnPFolder and Resolve-PnPFolder commands but it does not provide options to be able to add the values to the columns established in the SharePoint library with PowerShell.

I hope you can help me.

Thank you so much.

Answer 1

Hi @Jairo Javier Baleta Cali,

Please try this PowerShell:

#Parameters
$SiteURL = "https://wendytest123.sharepoint.com/sites/karley03"
$ListName = "Lib1"
$FolderServerRelativeURL = "/sites/karley03/Lib1/Folder1"
 
#Connect to SharePoint Online site
Connect-PnPOnline -Url $SiteURL -Interactive
 
#Get the Folder
$Folder = Get-PnPFolder -Url $FolderServerRelativeURL -Includes ListItemAllFields
 
#Update Folder's column
Set-PnPListItem -List $ListName -Identity $Folder.ListItemAllFields.Id -Values @{"CusColumn1" = "XXXXXXXXX"; "CusColumn2" = "XXXXXXX"} | Out-Null

---

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

Hi @Jairo Javier Baleta Cali,

 This is a default behavior of SharePoint, you cannot assign custom columns to the (default) Folder content type in library. You must have added custom column to the Document content type in library.

Workaround:

You can set custom columns for folders in Grid view. Open your library in grid view using Edit in grid view option at the top of library.

---

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.