Running SharePoint List Workflows on a particular view of List Items using
PowerShell
Too often it is required to execute
workflows on multiple list items on a particular list view and there is no OOTB
feature available in SharePoint to achieve this objective. One such example is
to update all list items, delete multiple list items based on a criteria set in
Workflow etc.
Below Power Shell script will
help you to run List Workflow on all list items in one go.
# This Script is for running on all items of a
particular List View
# URL of the Site
$web = Get-SPWeb -Identity "http://xxxxxxxxxx/"
$manager =
$web.Site.WorkFlowManager
# Name of the list
$list = $web.Lists["ListName"]
$ListView = $list.Views["ViewName"]
# Name of the Workflow
$assoc =
$list.WorkflowAssociations.GetAssociationByName("WorkflowName","en-US")
$data =
$assoc.AssociationData
$items =
$list.GetItems($ListView)
foreach($item in $items)
{
# Putting five seconds delay
because if power shell sends all instances to server workflows get hanged.
start-sleep -seconds 5
$wf = $manager.StartWorkFlow($item,$assoc,$data,$true)
}
$manager.Dispose()
$web.Dispose()
Copy the script save it
anywhere in your machine such as C Drive with extension .ps1.
Run the SharePoint
Management Shell as “Run As Administrator”.
Type & “path where .ps1
is saved”.
And here we go.
Good Luck.
