September 19, 2018 / Last updated : September 19, 2018 Sethu Client Object Model

How to check if the list level Throttling is enabled or not in SharePoint Online/2010/2013/2016?

  Hello SharePointers, Below is the Powershell script to check if the list level Throttling is enabled or not. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $webApplicationURL = Read-Host “Enter SharePoint Web Application URL” $reportPath = Read-Host “Enter full Path URL in the format” $webapplication = Get-SPWebApplication $webApplicationURL $sites = $webapplication.Sites Write-Output “SharePoint List URL” | Out-File $reportPath […]
August 31, 2018 / Last updated : August 31, 2018 Sethu Client Object Model

How to hide fields in SharePoint display form using Javascript in SharePoint 2010/2013/2016 /2019 and office 365?

Hello SharePointers, If you add external column in list, those columns will be visibile in your sharepoint display form by default. To hide sharepoint fields in sharepoint display form, you have to write the below script. <script language=”javascript” src=”https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js”></script><script language=”javascript”> $(document).ready(function () { $(“.ms-standardheader:contains(‘FieldName1’)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName2)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName3’)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName4)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName5)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName6’)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName7’)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName8’)”).closest(“tr”).hide(); }); </script>​​​<br/>​<br/>   Happy […]
August 22, 2018 / Last updated : August 22, 2018 Sethu Client Object Model

How to add multiple users to People picker using JSOM in SharePoint 2010, 2013,2016,2019 Online & Office 365?

Hello SharePointers, Below is the JSOM script to add multiple user to people picker field in SharePoint list forms. function InsertUserstopeoplePicker() { var ctx = new SP.ClientContext(appWebUrl); var CtxSite = new SP.AppContextSite(ctx, hostWebUrl); var web = CtxSite.get_web();  var List = web.get_lists().getByTitle(‘Mytestlist’); var itemCreateInfo = new SP.ListItemCreationInformation(); var oListItem = List.addItem(itemCreateInfo); //Get User info var peoplePicker […]
July 25, 2018 / Last updated : August 15, 2018 Sethu Client Object Model

How to validate SharePoint list for First and Last name should be unique in Office 365/SharePoint online/2010/2013/2016?

Hello SharePointers, SharePoint online doesn’t allow two columns to be set as unique value for validation. Let us consider the business scenario, where first name and last name has to be unique in a SharePoint list. This can be achieved using REST API calls . Below are the code snippet that will help you to […]
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 […]
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 […]
May 24, 2017 / Last updated : May 24, 2017 Sethu Client Object Model

How to OverCome limitations of uploading 2 MB File limit in SharePoint Using CSOM?

Hello SharePointers, In SharePoint Online, 2013, 2016 environments , we can  use CSOM to upload files into document library. While uploading Large files, there is a limitation of 2 MB . To overcome this, we can use the below CSOM script. The below method will allows you to upload upto 10 MB. public void UploadDocumentusingContentStream(ClientContext cc, […]
May 20, 2017 / Last updated : May 20, 2017 Sethu Client Object Model

How to Delete SharePoint List attachements using CSOM in SharePoint Online/Office 365?

Hello SharePointers, Below is the CSOM Code snippet to delete SharePoint list attachments in SharePoint Online/Office 365. public static void DeleteAttachmentFilesfromListItem(ClientContext cc, string listName,int listItemId) { var list = cc.Web.Lists.GetByTitle(listName); var listItem = list.GetItemById(listItemId); cc.Load(listItem, li => li.AttachmentFiles); cc.ExecuteQuery(); listItem.AttachmentFiles.ToList().ForEach(a => a.DeleteObject()); context.ExecuteQuery(); } Happy SharePointing :-)(  
May 18, 2017 / Last updated : May 18, 2017 Sethu Client Object Model

How to Send email to External users in SharePoint online using CSOM?

Hello SharePointers, Below is the CSOM code to send email to External users in SharePoint online using CSOM string Url = “https://tenant.sharepoint.com/sites/comms/”; var cc = new ClientContext(Url); string passwordPlainText = “userpassword”; string currentUserLoginName = “user@tenant.onmicrosoft.com”; var passWord = new SecureString(); foreach (char c in passwordPlainText.ToCharArray()) passWord.AppendChar(c); cc.Credentials = new SharePointOnlineCredentials(currentUserLoginName, passWord); web.EnsureUser(“i:0#.f|membership|paige.turner_contoso.com#ext#@tenant.onmicrosoft.com”); clientContext.ExecuteQuery(); var emailProperties = […]
May 18, 2017 / Last updated : May 18, 2017 Sethu Client Object Model

How to get the list of external Users shared for a particular document library using CSOM?

Hello SharePointers, Below is the CSOM code to get list of external Users shared for a particular document library using CSOM. string URL = “https://yourtenant.sharepoint.com/sites/”; string userName = “user@yourtenant.onmicrosoft.com”; string userPassword = “password”; string fullDocumentUrl = “https://yourtenant.sharepoint.com/sites//Shared%20Documents/my_sample_document.xlsx”; using (var cc = new ClientContext(Url)) { var passWord = new SecureString(); foreach (char c in userPassword.ToCharArray()) passWord.AppendChar(c); cc.Credentials = new […]