April 27, 2019 / Last updated : April 27, 2019 Sethu Office 365

How to add metadata to Document libraries in SharePoint online using powershell.

Hello SharePointers, Below are the Power shell command to add metadata to Document libraries in SharePoint online using powershell. $Path = “D:SharePoint docx” $listTitle = “My Documents” $targetList = $Context.Web.Lists.GetByTitle($listTitle) $filecreation= New-Object Microsoft.SharePoint.Client.FileCreationInformation $filecreation.Overwrite = $true $filecreation.Content = [System.IO.File]::ReadAllBytes($Path) $filecreation.URL = [System.IO.Path]::GetFileName(ePath) $File = $targetList.RootFolder.Files.Add(filecreation) $listItem = $uploadFile.ListItemAllFields $listItem[“LastReviewed Time “] = [System.DateTime]::Now $listItem.Update() $Ctx.Load($File) […]
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 […]
March 21, 2019 / Last updated : March 21, 2019 Sethu PowerShell

How to get result sources in SharePoint 2013/2016/2019 using Powershell?

Below are the powershell commands get result sources in SharePoint 2013/2016/2019 using Powershell. Add-PSSnapin Microsoft.SharePoint.PowerShell $ssa = Get-SPEnterpriseSearchServiceApplication $fedman = New-Object Microsoft.Office.Server.Search.Administration.Query.FederationManager($ssa) $searchOwner = Get-SPEnterpriseSearchOwner -Level Ssa $filter = New-Object Microsoft.Office.Server.Search.Administration.SearchObjectFilter($searchOwner) $filter.IncludeHigherLevel = $true $fedman.ListSources($filter,$true) | Select Name, Description, Active, Owner Happy SharePointing 🙂
March 6, 2019 / Last updated : March 6, 2019 Sethu Customization

How to get all site owners in SharePoint Online using Powershell?

Hello SharePointers. Below are the powershell script to get all the site owners of all the SharePoint sites. foreach($site in $sites) { $siteURL = $site.Url $siteOwner = $site.Owner Write-Host $siteURL -ForegroundColor Blue Write-Host $siteOwner -ForegroundColor Blue $siteAdmins = Get-SPOUser -Site $siteURL -Limit All | select LoginName,IsSiteAdmin | ? { $_.ISSiteAdmin } $siteUsers = “” foreach($siteAdmin […]
February 28, 2019 / Last updated : February 28, 2019 Sethu SharePoint 2010

How to create modern page in classic SharePoint site in Office 365/SharePoint Online?

To enable Modern pages in a classic sharepoint site, you need to activate the feature called “Site pages” at the site level. Here are the steps given below Navigate to your SharePoint site.Go to site settings, using Gear menu. On site settings page, select Manage site features from site action sectionActivate Site Page feature by […]
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 […]
February 16, 2019 / Last updated : February 16, 2019 Sethu Client Side Object Model

How to hide hours in SharePoint people picker in SharePoint online ,2010/2013/2016?

Hello SharePointers, Below are the powershell script to hide hours in People picker control in Sharepoint online/2010/2013/2016/2019. <script type=”text/javascript”> $(document).ready(function() { $(“select[id^=’People picker ID’]”).change(function() { $(this).find(“option[value=’4′]”).remove(); }); }); </script> Happy SharePointing 🙂
January 9, 2019 / Last updated : January 9, 2019 Sethu SharePoint 2010

How to upload Documents in a folder to SharePoint list in Office 365/SharePoint 2010/2013/2016/2019?

Hello Sharepointers, Below are the powershell script to upload Documents in a folder to SharePoint list in Office 365/SharePoint 2010/2013/2016/2019. if((Get-PSSnapin “Microsoft.SharePoint.PowerShell”) -eq $null) { Add-PSSnapin Microsoft.SharePoint.PowerShell Write-Host “SP Add-in Activated” } $webUrl = “https://lakssite” $docLibraryName = “Employee” $docLibraryUrlName = “Emp” $localFolderPath = “C:\Employee Folder” $web = Get-SPWeb $webUrl Write-Host “webSite = ” + $webSite […]