Office 365 Sharepoint - update custom metadata field value in document Library

Hi everyone,

Before I get to the “looping through all documents” part of what I am trying to achieve, I am trying to update a single custom metadata field value on a document in a library. Ultimately I will loop through the entire library and change 4 different custom metadata fields on the documents based on sections of the document name.

I have done some fun and interesting things with powershell, but really struggling with interacting with the online sharepoint model after reading a lot of articles. There seems to be a few ways to skin the cat, but not successful yet with any.

Here is a simple example of one way I have tried to achieve this. In this case I am expecting that the $File.ListItemAllFields in about line 24 will give me access to all fields including the additional ones we have added to the library, but this technique seems to only expose a few fields (id title and GUID). I can update the exposed fields (ie code works on Title), but don’t understand why I cannot update any other fields eg MyCustomField below (and many others I have tried).

I get this error on trying to update other fields, even though this field absolutely exists:

Error Updating Metadata of the File! Exception calling “ExecuteQuery” with “0” argument(s): “Column ‘MyCustomField’ does not exist.
It may have been deleted by another user. /sites/Star/Shared Documents”

#Load SharePoint CSOM Assemblies
Add-Type -Path “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll”
Add-Type -Path “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll”

#Set parameter values
$SiteURL=“https://mycompany.sharepoint.com/sites/DocCentral” # modern sharepoint site!
$FileRelativeUrl="/sites/doccentral/Shared Documents/1000 Operations/ABC-OP-PR-1000_26 Woven Procedure.doc"

Try {
#Get Credentials to connect
$Cred= Get-Credential
$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)

#Setup the context
$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$Ctx.Credentials = $Credentials

$File = $Ctx.web.GetFileByServerRelativeUrl($FileRelativeUrl)
$Ctx.Load($File)
$Ctx.ExecuteQuery()

#Set Metadata of the File
$ListItem = $File.ListItemAllFields
$ListItem[“MyCustomField”] = “Hello World” #Any other field outside of ID, Title and GUID not accessible after above line??
$ListItem.Update()
$Ctx.ExecuteQuery()

Write-host -f Green “File’s Metadata has been Updated Successfully!”
}
Catch {
write-host -f Red “Error Updating Metadata of the File!” $_.Exception.Message
}

#Read more: https://www.sharepointdiary.com/2017/08/sharepoint-online-update-document-metadata-using-powershell.html#ixzz6ctYSlD2P