Friday, December 11, 2015

Update Non read only fields in SharePoint list using powershell


function Get-SPList($webUrl, $lstUrl)
{
    $webObj = Get-SPWeb -identity $webUrl
    $lstObj = $webObj.GetList($lstUrl);
    return $lstObj
}
$spList = Get-SPList -webUrl "Web URL" -lstUrl "List URL"
$spListItem = $spList.GetItemById(9355)

foreach ($field in $spListItem.Fields) #Get all fields in lists
{
              if($field.ReadOnlyField -eq $false)  #checking field is read only
             {
                      if($field.Title -eq "Deliverable Status")
                     {
                               Write-Host $spField " | " $field.Type "," $field.Title ","  $field.StaticName -       ForegroundColor Green
                              $spListItem[$field.Title] = "Completed"
                              $spListItem.Update()  
                               Write-Host     $field.Title "-Updated"

                      }              
             }
}

No comments:

Post a Comment