Powershell deleting/showing list items csom

Question

I am trying to delete items in a list using CSOM powershell but it doesn't seem to work at all, Here is my code atm which is trying to print out the title of my list items but this isn't working either(not printing out any data). Where am I going wrong?

$web = $ctx.Web
$site = $ctx.Site     
$ctx.Load($web)     
$list = $web.Lists.GetByTitle("Pages")
write-host $list.ItemCount        
Write-Host ("Deleting old result page")
Write-Output("Deleting old result page")
foreach($listItem in $list)
{        
    $ctx.Load($listItem)    
    $ctx.ExecuteQuery()    
}

Amal Hashim · Accepted Answer · 2015-01-15 13:53:47Z

Its because you haven't loaded the $list.

Use below code and try

$web = $clientContext.Web
$list = $web.Lists.GetByTitle("Pages")
$clientContext.Load($list)
$clientContext.ExecuteQuery()
$count = $list.ItemCount
$newline = [environment]::newline
Write-Host -NoNewline "Deleting listitems from Pages" -foregroundcolor black -backgroundcolor yellow
$continue = $true
while($continue)
{
    Write-Host -NoNewline "." -foregroundcolor black -backgroundcolor yellow
    $query = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery(100, "ID")
    $listItems = $list.GetItems( $query )
    $clientContext.Load($listItems)
    $clientContext.ExecuteQuery()       
    if ($listItems.Count -gt 0)
    {
        for ($i = $listItems.Count-1; $i -ge 0; $i--)
        {
            $listItems[$i].DeleteObject()
        } 
        $clientContext.ExecuteQuery()
    }
    else
    {
        Write-Host "." -foregroundcolor black -backgroundcolor yellow
        $continue = $false;
    }
}
Write-Host "All listitems deleted from Pages." -foregroundcolor black -backgroundcolor green

Stack Exchange Network

Powershell deleting/showing list items csom

1 Answer 1

Your Answer

Hot Network Questions

Powershell deleting/showing list items csom

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions