CAML Query to Get List Items from SharePoint using PowerShell

CAML stands for Collaborative Application Markup Language. It’s an XML based query language used to query against data in SharePoint How to use CAML query in PowerShell? Basically, we create a CAML query and pass a SPquery object to retrieve filtered list items from the object. Here is a basic example for…

Read more

Find and Replace User ID in SharePoint InfoPath Forms using PowerShell

Requirement: Replace User IDs in InfoPath Forms. Little background: A particular user’s User account changed in Active directory and in SharePoint we ran Move-SPUser cmdlet to accommodate the user’s SAM account name change. However, There are many InfoPath form libraries with bunch of InfoPath forms in it – with old user id….

Read more

Get All List and Libraries Inventory of a SharePoint Site Collection using PowerShell

Requirement: Get All Lists and Libraries Inventory of a SharePoint Site Collection PowerShell to Get Site Collection List and Library Inventory: Report Output:  Get Inventory for All Site Collections in a Web Application Before running the script, make sure you add a web application user policy with Full control for the web…

Read more

Fix “Unfortunately, help seems to be broken…There aren’t any help collections in the current language for the site you’re using.” Error in SharePoint 2016

Problem: The Help Menu (?) in SharePoint 2016 is not working! On clicking the Help menu, it gets the error message: “Unfortunately, help seems to be broken… There aren’t any help collections in the current language for the site you’re using.” Troubleshooting Steps:  Enable External Web-based Help in Privacy Options of SharePoint…

Read more

Set Global Search Center in SharePoint 2016

So, you have your search center site ready for SharePoint 2013 (Use this article: Create Enterprise Search Center using PowerShell) as a next step, you should configure global search center from SharePoint central admin site to set default search center site for all site collections. SharePoint 2016 Default Search Center Once the…

Read more

Add Rich Text Column in SharePoint Document Library

Problem: Could not add rich text columns to SharePoint document library, Picture Library and other type of Libraries! A little background: End-user created a document library with column “Description” as “Multiple lines of text” and expecting this column to have the Rich text capability. So, tried editing the column, and found no…

Read more

Compare SharePoint List Item Version History using PowerShell

Requirement: Compare version history data of SharePoint List items and update a metadata column based on a particular field’s value change. A bit of background: We’ve a project tracking list with “Status” column. We wanted to have an insight on when a particular item’s status was set to “Rejected”. PowerShell to Compare…

Read more

Fix for SharePoint 2016 Project Templates Missing in Visual Studio 2015

Problem: SharePoint Project Templates are missing in Visual Studio 2015! Solution: We need to install “Microsoft Office Developer Tools for Visual Studio 2015” for SharePoint 2016 project templates in Visual Studio 2015. For SharePoint 2010/2013, download and install: Microsoft Office Developer Tools for Visual Studio 2015 For SharePoint 2016, Download and install:…

Read more

“Delete this list” Missing in SharePoint? Here is the solution!

Problem: “Delete this list” option missing in SharePoint list settings! wanted to delete a particular list in SharePoint but could not find delete this list option under list settings. Tried deleting it from the list ribbon menu, SharePoint Designer, Content and structure tool, Explorer view, PowerShell but none helped. Root Cause: Delete…

Read more

How to Disable Quick Edit in SharePoint?

Requirement:  Disable quick edit in SharePoint 2016 list. How to disable quick edit in SharePoint 2013 or SharePoint 2016? Bit background: We have a project tracking list with the field “Project Health” which is updated by an event receiver based on certain parameters and business logic. So, we made the field hidden…

Read more