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..