Add Lookup Field to SharePoint List using PowerShell

PowerShell script to add lookup field to SharePoint list: Scenario: You have a parent list called "Parent Projects" and child list "Project Milestones". The "Parent Project Name" field in child list is being looked up from the parent list's "Project Nam…

Add Single line of text / Multiple lines of text Fields to SharePoint List using PowerShell

How to Add Single Line of Text or Multiple Lines of Text Columns in SharePoint?  Browse to your list or library in SharePoint >> Click on the List or Library tab from ribbon. Click on "Create Column" button under "Manage Views" group.  In Create Column page, Type the…

Find Orphan User E-mails in List Items using PowerShell

Requirement: Our customized application for sending newsletters organizational wide, keeps its list of users to send e-mail in a SharePoint list called "Subscriptions". Users are configured in a people picker field of the list. Now, when someone leaves the organization, their account b…

Add Column to View in SharePoint using PowerShell

How to add column to view in SharePoint? To add column in sharepoint view follow these steps: Browse to your list or library in SharePoint >> Click on the List or Library tab from ribbon. Select the appropriate view from the "Current View" drop-down. Default View gets listed i…

Monitor SharePoint Services (Such as Timer Service) - Send Alert Email When They Goes Down!

In continuation to my post Monitor SharePoint App Pools using PowerShell Script ,  If certain Services on SharePoint server goes down, that could cause outages or service interruptions to your SharePoint environment! Although monitoring solutions such as SCOM can monitor services, they can'…

PowerShell to Update Multi-valued Peole Picker Field with New Users

Requirement: Update existing People Picker field value using PowerShell in SharePoint. PowerShell script to Add an new user to existing People Picker field: We have a field called "Team Members" in Projects list and wanted to add new member(s) to it for a particular list item. Add-…

Break Permission Inheritance and Add-Remove Users to SharePoint List using PowerShell

By default SharePoint Lists and Libraries are inheriting permissions from its parent site when created. There are times where you may want to implements unique permissions on a SharePoint list level. Say for e.g. if there are users who should access only a specific list in a SharePoint site but n…

Export SharePoint 2013 Search Crawl History to CSV using PowerShell

Requirement: Extract crawl history of SharePoint 2013 search service application to a CSV file. PowerShell to Extract Last 10 Crawl Log History to CSV file: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Parameters $ContentSourceName = "Local …

Update User Profile Properties in SharePoint using PowerShell

SharePoint User Profile properties are usually imported from Active Directory to provide information about SharePoint users. At times, we may have to update SharePoint user profiles manually. My scenario is to update user profile pictures from a SharePoint library. Here is my PowerShell script: …

Get-Set Person or Group (People Picker) Field Value using PowerShell in SharePoint

Requirement: SharePoint PowerShell to get and set person or group field value Peron or Group column in SharePoint captures user values. Here is my collection of PowerShell scripts to work with People picker field values: Read People Picker Field Value using PowerShell: PowerShell script…

The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator.

Error: The Managed Metadata Service or Connection is currently not  available. The Application Pool or Managed Metadata Web Service may not have been started.  Please Contact your Administrator.   Steps to troubleshoot: Check Managed Metadata Service is Running from SharePoint Central Admi…

Get/Set Managed Metadata Column Values using PowerShell

Here is my nifty collection of PowerShell scripts to read and update Managed Metadata field values in SharePoint: Read Managed Metadata column Value: PowerShell to get managed metadata field value. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $WebURL="…

Managed Metadata Columns Usage Report in SharePoint using PowerShell

Requirement: Find the usage of all Managed Metadata columns in SharePoint environment. PowerShell script to find managed metadata column usage: Here is the PowerShell script to find all managed metadata columns in SharePoint site collection. Add-PSSnapin Microsoft.SharePoint.PowerShell -Err…

How to Rename a List or Library in SharePoint?

How to rename a SharePoint list? Well, renaming SharePoint list is fairly a simple two step process. Lets rename a document library in SharePoint 2013. Browse to the document library >> Click on "Document Library Settings" under Library Settings group of the ribbon. Click on &q…

How to Add a Column to SharePoint List using PowerShell?

Requirement: Add columns to SharePoint list using PowerShell. PowerShell Script to Add Columns to SharePoint List: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue Function Add-FieldToList($SiteURL,$ListName, $FieldName, $FieldType, $IsRequired) { #Set the Error …

PowerShell to Add-Remove Fields to Content Type in SharePoint

If you have a requirement to add a field to content type or remove a field from existing content type, use this PowerShell script: PowerShell script to Add a field to content type: #Get Web Object $web = Get-SPWeb "http://sharepoint.company.com" #Get Content Type and Field $ContentT…

Publish Content Type in SharePoint using PowerShell

Content types that we create in one SharePoint site collection should be published from Managed metadata content type hub in order to make the content type available in all other site collections which consume Managed Metadata Service application. How to publish from content type hub in SharePo…

Create Content Type Hub in SharePoint using PowerShell

Content type hub in SharePoint is a central location to manage content types. Any web application subscribed to the content type hub can consume content types from this store. Creating content type hub in SharePoint using Central Administration web UI is explained in my another article: How to C…

Create Lookup Site Column from Subsite using PowerShell

Creating lookup field as site column was explained in my another post: Create a Cross-Site Lookup Site Column in SharePoint 2013 . Now got a requirement to create a lookup site column from the subsite's list! Unfortunately, there is no UI to create a site column from subsite list values. Look…

How to Create a Cross-Site Lookup Site Column in SharePoint 2013?

Lookup columns are used to get its value from a field in an another list in SharePoint sites. Lookup fields also provides a relationship between lists/libraries. Is it possible to create a lookup column from list on another site? sure, use site columns, so that you can utilize SharePoint 2013 loo…