Hello Sharepointers, When you are using people picker in your sharepoint project/app, if you add two or more users in the people picker. You will face this issue”The User Does Not Exist or is Not Unique”. To resolve it , we need to change the People picker field schema in the following fashion. By Default […]
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 […]
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 } } […]
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); } […]
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 :-)(
Hello SharePointers, Below is the powershell script to configure sharepoint designer using Powershell Commands. $webAppObj = Get-SPWebApplication -Identity http://spdev/site $webAppObj.AllowDesigner = $true $webAppObj.AllowRevertFromTemplate = $true $webAppObj.AllowMasterPageEditing = $true $webAppObj.ShowURLStructure = $true Happy SharePointing Folks 🙂
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 = […]
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 […]
Hello SharePointers, In this blog, we will see how to get the total number of external users of a Office 365 tenant in SharePoint online/Office 365. Here are the code below List<ExternalShareDetails> shares = new List<ExternalShareDetails>(); string adminRealm = TokenHelper.GetRealmFromTargetUrl(tenantAdminUri); var adminToken = TokenHelper.GetAppOnlyAccessToken(TokenHelper.SharePointPrincipal, tenantAdminUri.Authority, adminRealm).AccessToken; using (var cc = TokenHelper.GetClientContextWithAccessToken(tenantAdminUri.ToString(), adminToken)) { var tenant = new […]
Hello SharePointers, Here is the powershell script to get site collection information such as storaged used, site collection name in SharePoint 2010/2013/2016. function GetAllSitecollectionsInfoInWebapp { param ($Webapp) try { foreach($Site in $WebApp.Sites) { [int]$usage = $Site.usage.storage/1MB $OutputString = $Site.Url + “, ” + $usage + ” MB, “+ $Site.Owner $OutputString | Out-File $OutputFilePath -Append } } […]