June 7, 2019 / Last updated : June 7, 2019 Sethu Office 365

How to insert table in Modern Pages using PnP Powershell in Office 365/Sharepoint Online?

Hello SharePointers, Modern pages doesn’t support adding images in a table using text web part. To achieve that, We can use the below Pnp Powershell Connect-PnPOnline -Url https://mysites.sharepoint.com/sites/Test -Credentials (Get-Credential) Get-PnPClientSideComponent -Page Image.aspx |Format -Autosize textWebpart = Get-PnPClientSideComponent -Page Image.aspx -InstanceId 1d5bfd23-766c-4e24-aa34-8e08527a29d7 $textWebpart.Text | clip $htmlToInject = ‘ <div class=”canvasRteResponsiveTable”> <div class=”tableWrapper”> <table title=”Table”> <tbody> […]
April 17, 2019 / Last updated : April 17, 2019 Sethu Office 365

How to get Sharepoint site details using Powershell in Office 365?

Hello SharePointers, Below are the powershell code to site title, url, last modified date and creation date for a given sharepoint site collection. Get-SPWebApplication | Get-SPSite -Limit ALL | Get-SPWeb -Limit ALL | where { $_.HasUniquePerm -and $_.AssociatedOwnerGroup -ne $null } | foreach { $Title=$_.title;$TTNweburl = $_.Url; $_ ;$SiteCreatedDate=$_.Created; $SiteModifiedDate=$_.LastItemModifiedDate}| Select -ExpandProperty AssociatedOwnerGroup | Select […]
April 4, 2019 / Last updated : April 4, 2019 Sethu SharePoint Online

How to get the list of List and Document library item counts in SharePoint online using Pnp Powershell ?

Hello SharePointers, Below are the powershell commands to get the list of List and Document library item counts in SharePoint online using Pnp Powershell . $siteurl = “https://organisation.sharepoint.com/sites/selfservice/” $credentials = Get-Credential Connect-PnPOnline -Url $siteurl -Credentials $credentials $Subsites= Get-PnPSubWebs $ListItemCollection = @() Write-Host “Subsite count is ” $Subsites.Count ” in the site” foreach ($subsite in $Subsites) […]
April 2, 2019 / Last updated : April 2, 2019 Sethu SharePoint Online

How to restore subsite in a Sharepoint online site collection using Pnp Powershell

Hello SharePointers, Below are the power shell commands to restore subsite in a SharePoint online site collection using Pnp Powershell. $URL=”https://yourcompany.sharepoint.com/sites/selfservice/” $title=” KDM Monitor” $credentials=Get-Credential # Connect to SharePoint Online Connect-PnPOnline -Url $URL -Credentials $credentials Get-PnPRecycleBinItem | ? Title -eq $title | Restore-PnPRecycleBinItem Happy SharePointing 🙂
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 […]