Requirement: In a custom SharePoint 2013 list, User's requirement is to validate a required field based on another field's value. E.g. In a "Project Cost" list, user must fill "Budget Amount" field value if "Budget Approved" field's value is set to &quo…
At one point of time, I needed to export all users of a site collection to Excel and my trick to export user information list to excel as follows: Export user information list to excel in SharePoint 2013: Follow these steps to export user information list. Navigate to Site Settings >> …
Requirement: Got bunch of users and want to add them in to SharePoint? To bulk add users to SharePoint group programmatically using PowerShell, use the below script. This script Imports list of users from Excel .CSV file to SharePoint and adds them into appropriate groups. Solution: Lets im…
Managed Metadata Service allows us to Centrally manage enterprise level metadata & Content Types to use between Site Collections, Web Applications even across farms. Creation of Managed Metadata Service in SharePoint 2016 provides us "Term Store" which is a central repository to man…
Problem: SharePoint workflows failed because, user has no email address! You can get the user's Email address with this PowerShell one-liner: (Get-SPUser -Identity "Crescent\bourgeois" -Web "http://portal.crescent.com/projectpipeline").email Solution is simple! Share…
Problem: There are many Design documents uploaded to a SharePoint 2010 document library in Microsoft Word format in a Team site. Users reported these documents aren't appearing in search result. Same time found in crawl logs: "This item was partially parsed. The item has been truncated…
Its a common requirement in SharePoint 2013 to change its home page to some customized ones. In SharePoint 2013, to set homepage these options are available: Change default home page on SharePoint 2013 Team sites: Navigate to your desired page Click on "Page" tab, Click on "…
What is Resource throttling? Large lists are always performance killers in SharePoint. Luckily starting from SharePoint 2010, There is a feature called "Throttling" introduced to address this issue. Any operation such as data retrieval, update, delete of more than 2000 rows resul…
Requirement: Got a requirement to Hide "Open with Explorer" button from a particular library's ribbon menu due to some security reasons. Solution: Open with Explorer button can be disabled in multiple approaches. Disable "Client Integration" from Web Application'…
Requirement: Add new Calculated field to SharePoint list programmatically using PowerShell script. PowerShell to add calculated column in SharePoint list or library: Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue #Variables $WebURL="http://projects.crescent.c…
Ever wonder how to restore a deleted file in SharePoint? Like Windows, We've "Recycle Bin" feature in SharePoint. If you have Contributor permission or more, You can restore your deleted files. Usually, files in Recycle Bins gets deleted permanently after 30 days. SharePoint 2013 …
Requirement: Find all lists exceeding the list view threshold limit configured on Web Application's resource throttling settings. PowerShell Script to find all Large Lists which are exceeding the configured threshold limit: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction Silen…
Requirement: Hide Focus on Content button in SharePoint 2013! As the name suggests, Focus on content button in SharePoint 2013 removes left & top navigation and lets you to focus on the site content once you click on it. In case you want to remove that button, here is the trick: Solutio…
Requirement: Increase SharePoint 2013 multi-lookup field width Solution: Use CSS styles to set lookup field width in SharePoint! Here is how: Navigate to: http://your-sharepoint-site.com/Lists/Your-List/editform.aspx Click on "Site Settings" gear >> Edit Page Click on &quo…
Requirement: Update List Items in SharePoint using PowerShell How to Update List Items in SharePoint using PowerShell Script? Well, the basic syntax for updating a list item goes as: #Get Web and List $Web = Get-SPWeb "http://sharepointsite.com" $List = $Web.Lists["ListName…
Getting "Upgrade Required" error message in SharePoint 2013? Well, Ideally, We have to run the SharePoint Products Configuration Wizard on the server(s) right after installing the service pack/patches. In Windows Server 2012, SharePoint updates are part of Windows Server Update. It …
If you want to find out who has created a SharePoint site, list or library: Sorry! There is no way from SharePoint user Interface!! You can't get "Created By" or "Created On" values anywhere. But PowerShell is our rescuer! Lets find who has created a SharePoint list usi…
Reviewed by Salaudeen Rajack
on
March 30, 2015
Rating:
