March 16, 2019 / Last updated : March 16, 2019 Sethu Client Side Object Model

How to delete SharePoint list items before specific date in SharePoint online using Powershell?

Hello SharePointers, Below are the Pnp Powershell script to delete SharePoint list items before specific date in SharePoint online using Powershell. Connect-PnPOnline -Url <yourtenant>.sharepoint.com $listName = “EMployee” $items = Get-PnPListItem -List $listName -Fields “Title”,”Created”,”ID”,”GUID” // 30 days is the cut off period $days = (Get-Date).AddDays(-30) foreach($item in $items) { $created = $item[“Created”] Write-Host “Item created […]
February 22, 2019 / Last updated : February 22, 2019 Sethu Client Side Object Model

How to convert classic page to modern page in SharePoint Online/Office 365 using Powershell ?

Hello Sharepointers, Below are the powershell script to convert classic page to modern page in SharePoint Online/Office 365. $pages = Get-PnPListItem -List sitepages # Loop through over the pages foreach($page in $pages) { if ($page.FieldValues[“FileLeafRef”].StartsWith((“classicpage”))) { # No need to convert modern pages if ($page.FieldValues[“ClientSideApplicationId”] -eq “b6917cb1-93a0-4b97-a84d-7cf49975d4ec” ) { Write-Host ‘Page $page.FieldValues[“FileLeafRef”] is modern,already’ } […]
February 16, 2019 / Last updated : February 16, 2019 Sethu PowerShell

How to export all the webpart in a sharepoint online page using Powershell?

Below are the power shell script to export all the web part in a SharePoint Page . foreach($item in $items) { $file = $context.Web.GetFileByServerRelativeUrl($Item[“FileRef”]) if($Item[“FileRef”] -eq “/sites/testwebpartpage.aspx”){ $wpManager = $file.GetLimitedWebPartManager([Microsoft.SharePoint.Client.WebParts.PersonalizationScope]::Shared) $context.Load($file) $webparts = $wpManager.Webparts $context.Load($webparts) $context.ExecuteQuery() $ pelement = $XMLFile.CreateElement(“Page”) $ pelement .SetAttribute(“id”, $Item[“ID”]) $ pelement .InnerText = $Item[“FileRef”] $ pelement .AppendChild($PageElement) | Out-Null foreach($webpart […]
December 22, 2018 / Last updated : December 22, 2018 Sethu Client Object Model

How to delete large lists in Sharepoint online using Powershell

Add-PSSnapin Microsoft.SharePoint.Powershell -ea SilentlyContinue $web = get-spweb “https://mysite” $list = $web.lists[“Monster List”] $cquery = New-Object Microsoft.SharePoint.SPQuery $cquery.ViewAttributes = “Scope=’Recursive'” $cquery.RowLimit = 1000 $cquery.ViewFields = “” $cquery.ViewFieldsOnly = $true do { $listItems = $list.GetItems($cquery) $cquery.ListItemCollectionPosition = $listItems.ListItemCollectionPosition foreach($item in $listItems) { Write-Host “Deleting Monster Item – $($item.Id)” $list.GetItemById($item.Id).delete() } } while ($cquery.ListItemCollectionPosition -ne $null) Happy SharePointing […]