Create a SharePoint Group using PowerShell

Requirement: Create new SharePoint Group using PowerShell SharePoint groups to simplifies permission management by assigning a set of users to a group and assigning permission level to them through the group. There are default groups gets created based on the site template you choose while cr…

"There has been a critical error while processing the form." - Error in InfoPath

Problem: SharePoint browser enabled InfoPath form gave this error message: There has been a critical error while processing the form. Click Start Over to load a new copy of the form. If this error persists, contact the support team for the Web site.  Click Close to exit this message.  Error de…

How to Connect to SharePoint Online from PowerShell?

I know I said it several times, but I'll say it again: I'm a big fan of PowerShell! PowerShell makes repetitive tasks easier and makes our life smarter. It helps to automate complex tasks and reduces the risk of human errors. In this article, I'm exploring how to use PowerShell with S…

Delete Button Missing in SharePoint Column? Here is How to Delete

How to delete a Column when Delete Button is missing? Unable to delete list column in SharePoint since there is no delete button in field properties? In some cases, columns added through "Add existing columns" doesn't provide the option to delete! To make them deletable, just reve…

Delete a Site Column using PowerShell in SharePoint

Requirement: Delete site column with PowerShell in SharePoint How to Delete a Site Column in SharePoint? Site columns in SharePoint can be deleted when we don't need them anymore. When you delete a site column, any lists and libraries with the particular site column doesn't get affecte…

Create Site Column in SharePoint using PowerShell

The PowerShell way of adding site column is extremely helpful when you have to add site columns in bulk. Say for e.g. You may have certain site columns created in your DEV environment and would like to have them in Staging or in PROD environment. Will you be creating them one by one with Shar…

Copy Permissions from One User to Another in SharePoint using PowerShell

Permission management in SharePoint is always a complex task especially on large environments. Granting permissions in SharePoint becomes cumbersome when you are in a situation to clone an existing user's access rights. Consider this scenario: You have an existing user in a department granted…

SharePoint 2013: PowerShell to Create a Folder in Document Library

Requirement: Create a new folder in SharePoint How to add folder in SharePoint Document Library using PowerShell: To create folder in document library in SharePoint 2013, use this PowerShell script: $folder = $list.Folders.Add("", [Microsoft.SharePoint.SPFileSystemObjectType]::Folde…

The text entered for Person or Group Column isn’t an item from the list. Select an item from the list, or enter text that matches one of the listed items

Problem: End-user wants to copy paste bunch of rows from Excel to SharePoint using Datasheet view. Datasheet view doesn't allow user to paste the data for Person or Group type column! it gives the error message: The Text entered for the "Person or Group column" isn’t an item from t…

Disable Throttling on SharePoint List using PowerShell

Throttling feature helps to avoid performance hits in SharePoint. We set throttling limits for entire web application. Its not possible to set throttling limits on specific SharePoint list or library. But we can disable/enable throttling on SharePoint lists. PowerShell to disable list throttlin…

Run PowerShell Script as Administrator (Elevated Privileges) by Default

Its a common SharePoint Administrator's pitfall - Forget to run PowerShell script using "Run as Administrator" option, failing so could lead to many *weird* issues while running PowerShell scripts in SharePoint, such as: "The local farm is not accessible. Cmdlets with FeatureDe…

Create New Custom List in SharePoint using PowerShell

Requirement: Add custom list to SharePoint using PowerShell. PowerShell to Create New List in SharePoint: To create a new list or library in a SharePoint Online site, you must have the "Manage Lists" permission! The default permission levels Edit, Design, Manage Hierarchy, and Ful…

SharePoint 2013 Patch (Service Pack-CU-Hotfix) Installation Guide - Step by Step

So you want to maintain your SharePoint environment healthy, secure, stable and up to date by installing latest patches? Well, this article walks through the various steps involved in installing patches for your SharePoint 2013 environment. SharePoint 2013 patching best practices Before procee…

Sync SharePoint List Data from a CSV File using PowerShell

Requirement: We've a SharePoint list with number of fields to capture organization wide people Expertise. This list has a particular field called "Team" and is to be updated from a CSV file of 100+ rows. Yes, Datasheet view can help, but the problem is: The Team field value to be up…

SharePoint 2013 Specific User Permission Analysis Report using PowerShell

Analyzing SharePoint permissions for a particular user is often a common task in SharePoint administration. Generally, How do we check what permissions a user has on SharePoint content? By getting into site or list settings page and check permissions for the particular user, isn't it? Well, Y…

SharePoint Online: Activate a Feature using PowerShell

Requirement: Activate a feature in SharePoint online site collection using PowerShell. Solution: In SharePoint On-Premises, We use: Enable-SPFeature cmdlet to activate/enable features. In SharePoint online there is no such cmdlet available through PowerShell to activate feature. But we can u…

How to Hide Column Headers in SharePoint List View Web Parts using CSS, jQuery?

I was looking for some ways to hide SharePoint list view column headers today. Here are my findings: You can use CSS to hide column headers Use JavaScript/JQuery to Hide column headers You can edit the page in SharePoint designer and remove column headers Hide Column Headers of All List V…