Sharepoint Powershell - Delete all Items from a List on the Basis of Status
This post is to explain the process of deleting all items from a list on the basis of the status (e.g. status= completed) using PowerShell script in Sharepoint. To use the below script add your list/library name e.g. $docName=”<your list/library name>” and your SharePoint site/web address e.g. $web = Get-SPWeb <your site/web address> Script: Add-PSSnapin Microsoft.SharePoint.PowerShell $web = Get-SPWeb <your site/web Url> $docName = " <list/library display name> " $list = $web.lists | where {$ _ .title -eq $docName} for ($x = $list.ItemCount - 1 ;$x -ge 0 ; $x -- ) { $item = $list.Items[$x]; if ($item[ " Status " ] -eq " COMPLETED " ) { Write-Host " Deleting item id " $item.ID $item.Delete(); } } $list.Update();