May 27, 2017 / Last updated : May 27, 2017 Sethu PowerShell

How to Create a document set using JSOM in SharePoint online/Office 365?

Hello SharePointers, Here is the JSOM code to create a document set using JSOM.   docSetName = “RequirementDocset; var context = new SP.ClientContext(_spPageContextInfo.webServerRelativeUrl); var list = context.get_web().get_lists().getById(‘GUID of List’); context.load(list); var itemCreateInfo = new SP.ListItemCreationInformation(); itemCreateInfo.set_underlyingObjectType(SP.FileSystemObjectType.folder); itemCreateInfo.set_leafName(docSetName); var listitem listitem= list.addItem(itemCreateInfo); listitem.set_item(“ContentTypeId”, “GUID”); listitem.set_item(‘Title’, docSetName); listitem.set_item(‘DocumentSetDescription’, “This is Req set Document Set”); listitem.set_item(‘ChartIdlookup’, itemid); listitem.update(); […]
May 27, 2017 / Last updated : May 27, 2017 Sethu PowerShell

How to remove permission for a group from SharePoint 2010/2013 using Powershell?

Hello SharePointers, Here are the powershell script to remove the Full Control permission from owners group. $web = get-spweb http://mysharepoint $group = $web.SiteGroups[“Owners”] $role = $group.ParentWeb.RoleAssignments.GetAssignmentByPrincipal($group) $roledef= $group.ParentWeb.RoleDefinitions[“Full Control”] $role .RoleDefinitionBindings.Remove($roledef) $role .Update() $group.Update() $web.Dispose() Happy SharePointing 🙂
May 25, 2017 / Last updated : May 25, 2017 Sethu Client Side Object Model

How to Set People Picker value in SharePoint using CSOM and Powershell?

Hello SharePointers, Below are the CSOM script to set/populate People Picker value in a SharePoint list . $userName = “domain\username” $spuser = EnsureUser $context $userName $lookupValue = @() if($spuser -ne $null){ $spuserValue = New-Object Microsoft.SharePoint.Client.FieldUserValue $spuserValue.LookupId = $spuser.id $lookupValue += $spuserValue } $userValue = [Microsoft.SharePoint.Client.FieldUserValue[]]$lookupValue $listItem[“Your People Picker FieldColumn name”] = $userValue $listItem.Update() Happy SharePointing […]
May 25, 2017 / Last updated : May 25, 2017 Sethu Customization

How to get SharePoint list item counts using REST API?

Hello SharePointers Below is REST API code to get the sharepoint list item counts using REST API. var ListUrl = _spPageContextInfo.webServerRelativeUrl + “/_api/web/lists/getbytitle(‘yourlistname’)/items”; getJsonFormat(ListUrl) .done(function(data) { var itemsCount = data.d.results.length;  }) .fail( function(error){ console.log(JSON.stringify(error)); }); function getJsonFormat(ListUrl) { return $.ajax({ url: ListUrl, type: “GET”, contentType: “application/json;odata=verbose”, headers: { “Accept”: “application/json;odata=verbose” } }); } Happy SharePointing […]
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 23, 2017 / Last updated : May 23, 2017 Sethu Client Side Object Model

How to query User Information List using Powershell?

Hello SharePointers, Below is the Powershell script to query User Information List for a particular sharepoint group. $List = $web.Lists.GetByTitle(‘User Information List’) $userItem = $List.GetItemById(‘GROUP NAME’); $ctx.Load($userItem) $ctx.ExecuteQuery() $obj = New-Object PSObject $obj | Add-Member -type NoteProperty -Name Title -Value $userItem[‘Title’] $obj | Add-Member -type NoteProperty -Name UserName -Value $userItem[‘UserName’] $obj | Add-Member -type NoteProperty -Name […]
May 23, 2017 / Last updated : May 23, 2017 Sethu Customization

How to calculate total size of a Document library using Powershell in SharePoint 2013/2010/2016?`

Hello SharePointers, Below are the script to find the actual size of documents in document library using Powershell. foreach ($web in $site.AllWebs) { $DocLibSize=0 $count=0 foreach ($list in $web.Lists) { if($list.BaseTemplate -eq “DocumentLibrary”) { $itemSize = 0 foreach ($item in $list.items) { $itemSize += ($item.file).length } $itemSize= [Math]::Round(($itemSize/1MB),2) Write-Host $itemSize “MB ” $DocLibSize+=$itemSize } } […]
May 20, 2017 / Last updated : May 20, 2017 Sethu REST API's

How to Get List of folders and files in SharePoint Document library using REST API in SharePoint online/Office 365?

Hello SharePointers, Below is the REST API snippet to find folders and files inside the folder url of a sharepoint document library. var folderUrl = ‘myfolder/2016’; var url = _spPageContextInfo.webServerRelativeUrl + “/_api/Web/GetFolderByServerRelativeUrl(‘” + folderUrl + “‘)?$expand=Folders,Files”; $.getJSON(url,function(data,status,xhr){ for(var i = 0; i < data.Files.length;i++){ console.log(data.Files[i].Name); } for(var i = 0; i < data.Folders.length;i++){ console.log(data.Folders[i].Name); } […]