Required Field Validation Based on Another Column’s Value in SharePoint 2013

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, the user must fill “Budget Amount” field value if “Budget Approved” field’s value is set to “True”. How to make a field required based on another…

Read more

Export “User Information List” to Excel in SharePoint

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: How to Export user information list to excel in SharePoint? Follow these steps to export user information list. Navigate to Site Settings >>…

Read more

Import Users from Excel (CSV) to SharePoint using PowerShell

Requirement: Got a bunch of users and want to add them to SharePoint? To bulk add users to SharePoint group programmatically using PowerShell, use the below script. This script imports a list of users from Excel. CSV file to SharePoint and adds them into appropriate groups. Solution: Lets import users from Excel…

Read more

Increase SharePoint Search Index File Size Limit

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 in the index because it exceeds…

Read more

Set Default Home Page in SharePoint 2016

It’s a common requirement in SharePoint 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: To set the default page for SharePoint site, do the following:  Navigate to your desired page Click on…

Read more

Configure Resource Throttling in SharePoint 2013 using PowerShell

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 results in low performance in SharePoint 2007 days. Throttling defines the Maximum…

Read more

How to Disable “Open with Explorer” View in SharePoint 2013?

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’s Authentication Providers. Remove permissions “Use Remote Interfaces” which also removes “Use Client Integration Features”…

Read more