Sharepoint list deleting from powershell

Question

I have got a Sharepoint list. I updeted it in job everyday and everyday refresh by powershell. I have got some column on this sharepoint list. One of this column called [nazwazdarzenia]. And the code which works for today great was:

    # Delete existing List Data, If not required remove this line
$Items = $list.GetItems()
$Items | ForEach-Object{
        $list.GetItemById($_.Id).Delete()}

But now, I want to delete everyrecord without record which have got in column [nazwazdarzenia] =! "Szkolenie". So delete all records without records with column [nazwazdarzenia] not equal "Szkolenie". What If I should add to PowerShell to dellete all records without "Szkolenie". Please help.

Paul Strupeikis · Accepted Answer · 2016-02-19 11:32:30Z

2

Use the following code:

$list.Items | ? {$_["nazwazdarzenia"] -ne "Szkolenie"} | % {$list.GetItemById($_.Id).Delete()}

answered Feb 19, 2016 at 11:32

Paul Strupeikis

3,8184 gold badges22 silver badges34 bronze badges

Great hack code :)

Grzegorz Z
– Grzegorz Z

2016-02-19 13:05:04 +00:00
Commented Feb 19, 2016 at 13:05
Work brilliant :)

Grzegorz Z
– Grzegorz Z

2016-02-19 13:05:25 +00:00
Commented Feb 19, 2016 at 13:05

Add a comment |

Ankitkumar Malde · Accepted Answer · 2016-02-19 11:32:17Z

0

$web = Get-SPWeb <SharePoint URL>
$listName = "LIST NAME HERE"
$list = $web.Lists[$listName]
$items = $list.Items | Where {$_["nazwazdarzenia" ] -ne "Szkolenie"}
foreach($item in $items)
{
Write-Host "Deleting " $item.ID
$item.Delete()
}

answered Feb 19, 2016 at 11:32

Ankitkumar Malde

1,47314 silver badges28 bronze badges

Add a comment |

Stack Exchange Network

Sharepoint list deleting from powershell

2 Answers 2

Your Answer

Hot Network Questions

Sharepoint list deleting from powershell

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions