SharePoint Diary

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

March 30, 2015 List Settings, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Validation

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…

Export "User Information List" to Excel in SharePoint

March 30, 2015 CSV, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

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 >> …

Import Users from Excel (CSV) to SharePoint using PowerShell

March 30, 2015 CSV, PowerShell, SharePoint, SharePoint 2013

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…

Create Managed Metadata Service Application (MMS) in SharePoint 2016 using PowerShell

March 29, 2015 Managed Metadata, PowerShell, Service Application, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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…

How to Update User Email Address in SharePoint using PowerShell?

March 21, 2015 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, User Profile

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…

Increase SharePoint Search Index File Size Limit

March 19, 2015 Search, SharePoint, SharePoint 2010, SharePoint 2013

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…

Set Default Home Page in SharePoint 2013

March 17, 2015 SharePoint, SharePoint 2013

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 "…

Configure Resource Throttling in SharePoint 2013 using PowerShell

March 16, 2015 Best Practices, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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…

How to Disable "Open with Explorer" View in SharePoint 2013?

March 14, 2015 SharePoint

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'…

How to Add Calculated Column to SharePoint List using PowerShell?

March 14, 2015 Calculated Column, PowerShell, SharePoint

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…

How to Recover Deleted Files (Documents / List Items) from Recycle Bin in SharePoint 2013?

March 10, 2015 Recycle Bin, SharePoint, SharePoint 2013, SharePoint 2016, SharePoint Basics

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 …

Find All Large Lists Exceeding Threshold Limit in SharePoint using PowerShell

March 09, 2015 Admin Reports, Best Practices, CSV, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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…

Hide "Focus on Content" Full Screen Button in SharePoint 2013

March 09, 2015 CSS, SharePoint 2013, SharePoint 2016

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…

Increase SharePoint 2013 Lookup Column Width

March 09, 2015 CSS, List Forms, SharePoint, SharePoint 2013, SharePoint 2016, SharePoint Online

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…

How to Update List Items in SharePoint using PowerShell?

March 08, 2015 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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…

"Upgrade Required" Status in SharePoint 2013 Central Administration Servers in Farm

March 07, 2015 Installation, Patching, Service Packs, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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 …

Find Who Created a List or Library in SharePoint using PowerShell

March 02, 2015 PowerShell, SharePoint

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…

Disclaimer