How To Bulk Update SharePoint List

We’re busy implementing a SharePoint web application which has a couple of workflows that runs when users change things in a form.

Everything seems to work fine except before users close up for the day some of the lists that are read into the form require a status of “Open” to allow users to use that list item again the next day, but if a workflow fails it doesn’t update it to “open”

I was doing some research online and came across a blog post that assisted me, but I can’t seem to find it again but luckily copied the script out. Thanks to poster of that blog post!

Please see code below to run in SharePoint Powershell, remember to change the details to your site before running..

$web = Get-SPWeb http://YourServer/

$list = $web.Lists[“list name”]

foreach ($item in $list.Items) { $item[“column1”] = “New value”; $item[“column2”] = “New value”;$item.Update(); }

Hope this helps someone..

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

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