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

Requirement: In a custom SharePoint list, the 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 the “Budget Amount” field value if the “Budget Approved” field’s value is set to “True”. How to make a field required based…

Read more

Export “User Information List” to Excel in SharePoint

At one point in 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 the 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? Use the script below to bulk add users to the SharePoint group programmatically using PowerShell. This script imports a list of users from Excel. CSV file to SharePoint and add them into appropriate groups. Solution: Let’s import users from…

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 on a Team site. Users reported these documents aren’t appearing in search results. 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

Requirement: Change the Home page in SharePoint. How to Change the Home Page in SharePoint? The Home page is always the first thing people see when they visit your site. It’s a common requirement in SharePoint to change its home page to some customized one. Changing the home page is a quick…

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, a feature called “Throttling” was 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 number…

Read more

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

Requirement: I got a requirement to hide the “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…

Read more

How to Add Calculated Column to SharePoint List using PowerShell?

Requirement: Add a new calculated field to SharePoint list programmatically using PowerShell script. PowerShell to add a calculated column in SharePoint list or library: Here is how to add a calculated column to your SharePoint list using PowerShell. Script in action: Create calculated column in SharePoint 2013 using PowerShell

Read more