Let's SharePoint

February 22, 2018 / Last updated : February 22, 2018 Sethu Client Object Model

Server relative urls must start with SPWeb.ServerRelativeUrl – SharePoint Online Powershell error message?

Hello SharePointers, When you user Server relative urls in sharepoint online powershell , please ensure that you provide only relative urls to the copyto function. For example For instance, If you have following piece of code      $file =$ctx.Web.GetFileByServerRelativeUrl($att.ServerRelativeUrl) Write-Host $file.Name $ctx.Load($file) $ctx.ExecuteQuery() Write-Output “Hello” $NewName=$file.Name if($DestinationLibrary.EndsWith(“/”)){} else {$DestinationLibrary=$DestinationLibrary+”/”} Write-Host “Processing ” $file.Name $file.CopyTo($DestinationLibrary […]
February 21, 2018 / Last updated : February 21, 2018 Sethu PowerShell

Get-SPOSite : The site is not properly formed.

Hello SharePointers, When you try to connect to SharePoint online, if you face the issue “Get-SPOSite : The site is not properly formed.”. That means you have not given the correct site URL. The url should of the format https://companyname-admin.sharepoint.com/sites/SiteName Incorrect format https://companyname-admin.sharepoint.com/sites/SiteName/ which gives the error message “Get-SPOSite : The site is not properly […]
February 17, 2018 / Last updated : February 17, 2018 Sethu Client Side Object Model

How to create a Promoted list in SharePoint 2010/2013/2016 or Online using PnP CSOM?

Hello SharePointers Below is the PnP CSOM script to create a promoted list in  SharePoint 2010/2013/2016 or Online using PnP CSOM Script. $ListTemplateInternalName = “PromotedList.stp” $Context = Get-PnPContext $Web = $Context.Site.RootWeb $ListTemplates = $Context.Site.GetCustomListTemplates($Web) $Context.Load($Web) $Context.Load($ListTemplates) Execute-PnPQuery $ListTemplate = $ListTemplates | where { $_.InternalName -eq $ListTemplateInternalName } if ($ListTemplate -eq $null) { Throw [System.Exception] “PnP […]
February 15, 2018 / Last updated : February 15, 2018 Sethu Office 365

How to get current logged in user on a Sharepoint list using Sharepoint Framework?

Hello SharePointers, SharePoint frameworks is most talked about the topic nowadays. In this blog,we will get the current logged in user on a SharePoint List using SPX framework. import Web from ‘sp-pnp-js’; let web = new Web(this.context.pageContext.site.absoluteUrl); let curruser = web.currentUser.get().then(function(res){ console.log(res.Title); }) Happy SharePointing Folks 🙂
February 13, 2018 / Last updated : February 13, 2018 Sethu JSOM

How to associate the global resusable workflows to SharePoint list/libraries using JSOM?

Hello SharePointers, Here are the JSOM script to associate global reusable workflow to a SharePoint list/libraries. <script type=”text/javascript”> function AddWorkflow() { var ctx = SP.ClientContext.get_current(); var site = ctx.get_web(); var templates = ctx.get_web().get_workflowTemplates(); var template = templates.getByName(“My worklows”); ctx.load(templates); ctx.load(template); ctx.executeQueryAsync(Function.createDelegate(this, function (sender, args) { var info = new SP.Workflow.WorkflowAssociationCreationInformation(); var taskList = ctx.get_web().get_lists().getByTitle(“Workflow Tasks”); […]
February 1, 2018 / Last updated : February 1, 2018 Sethu Client Side Object Model

Error while executing web part: System.Net.WebException: The operation has timed out

Hello SharePointers, When do you have a custom webpart, if its get timed out due to various data sources involved and throws the following error. “Unable to display this Web Part. For information on how to solve the problem, open this web page in an HTML editor compatible with Microsoft SharePoint Foundation, such as Microsoft […]
January 30, 2018 / Last updated : January 30, 2018 Sethu Client Object Model

How to create a Survey in SharePoint using CSOM?

Hello SharePointers, Here are the CSOM code to create a survey list in SharePoint 2010/203 or SharePoint Online. public static void CreateSurveyList() { ClientContext ctx = new ClientContext(“http://mysite”); ListCreationInformation lci = new ListCreationInformation(); lci.Description = “Test Survey”; lci.Title = “First Survey”; lci.TemplateType = 102; List newSurveyList = ctx .Web.Lists.Add(lci); ctx .Load(newSurveyList); ctx .ExecuteQuery(); } Happy […]
January 10, 2018 / Last updated : January 10, 2018 Sethu PowerShell

How to republish all the content types in a Content Hub using Powershell in SharePoint 2010/2013/2016?

Hello SharePointers, Below are the Powershell commands to republish all the content types in a Content Hub using Powershell. Add-PSSnapin microsoft.sharepoint.powershell function RepublishHubContentTypes ($HubURL) { $HubSite = Get-SPSite $HubURL $Web = $HubSite.RootWeb #Check the site is a content type hub if ([Microsoft.SharePoint.Taxonomy.ContentTypeSync.ContentTypePublisher]::IsContentTypeSharingEnabled($HubSite)) { #Set up ContentTypePublisher object to allow publishing through the Content Type Hub […]
January 5, 2018 / Last updated : January 5, 2018 Sethu Office 365

How to set Managed property to searchable,queryable,sortable, refinable in SharePoint 2010/2013/2016 using Powershell?

Hello SharePointers, Here are the powershell script to set Searchable, queryable, Sortable, Retrievable, Refinable for a managed property. $searchappln = Get-SPEnterpriseSearchServiceApplication $ManagedProperty = Get-SPEnterpriseSearchMetadataManagedProperty -SearchApplication $searchappln -Identity $_.ManagedPropertyName -ea silentlycontinue if($ManagedProperty) { $ManagedProperty.Searchable = $true $ManagedProperty.Queryable = $true $ManagedProperty.Sortable = $true $ManagedProperty.Retrievable = $true $ManagedProperty.Refinable = $true $ManagedProperty.SafeForAnonymous = $true $ManagedProperty.update() write-host “The searchable, queryable, […]
January 5, 2018 / Last updated : January 5, 2018 Sethu Office 365

How to delete older version of sharepoint list items using Powershell in Sharepoint 2010/2013/2016?

Hello SharePointers, Below is the Powershell script to delete the older version of SharePoint list item. This script will delete the older version which lasts more than 12 months or after. $SPweb = Get-SPWeb “http://mysite/goodness” $limit = (Get-Date).AddMonths(-12) $SPlist = $SPweb.Lists[“Doc1”] foreach ($SPitem in $SPlist.Items) { $VersionsCount= $SPItem.Versions.count for($v=$VersionsCount-1;$v -ge 0;$v–) { if($SPitem.Versions[$v].IsCurrentVersion){ } else{ […]