Update List Items in SharePoint 2013 and Office 365 Using PowerShell


Introduction

Welcome readers to an article on updating list items in SharePoint 2013 and Office 365 using PowerShell.

Here we will see how to update all the list items in a list when a requirement of such comes in.

I have a PowerShell script here that you just need to add using Notepad and save it as a .ps1 file. In this script I am updating a choice field from a look up field.

Script

  1. Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
  2. $webURL = “Your Site Url”
  3. $listName = “Name of your list”
  4. $web = Get-SPWeb $webURL
  5. $list = $web.Lists[$listName]
  6. $items = $list.items
  7. Foreach($item in $items)
  8. {
  9.   $prim = $item[“Look Up Column field”]
  10.   if(!$prim)
  11.   {
  12.     write-host “Null”
  13.   }
  14.   else
  15.   {
  16.     $trim = $prim.split(‘#’)[1]
  17.     write-host $trim
  18.     $item[“choice field”] = $trim
  19.     $item.Update()
  20.     write-host $item[“Your Result You want to see”]
  21.   }
  22. }

How to run

  • You need to change the fields Site Url, List Name and Fields.
  • You might have a question, why am I using a split function?
    The field value when fetched from a look up field has characters like “1,#”. Using split we eliminate that extra data by giving us a correct variable.
  • Run the SharePoint PowerShell as Administrator
  • Run the .ps1 file

It will be executed and you will see the updated field values.

Here is a time saver article for my readers. Keep learning.

Cheers!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s