SharePoint Diary

Add Lookup Field to SharePoint List using PowerShell

December 31, 2015 Column, PowerShell, SharePoint

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

December 30, 2015 Column, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

December 30, 2015 PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, Users and Groups

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

December 30, 2015 Column, List View, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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!

December 29, 2015 Administration, Monitoring, PowerShell, SharePoint

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

December 27, 2015 People Picker, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

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

December 26, 2015 Library, List, Permission, PowerShell, Security, SharePoint, SharePoint 2013, SharePoint 2016

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

December 25, 2015 Admin Reports, CSV, Search, SharePoint, SharePoint 2013, SharePoint 2016

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

December 22, 2015 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, User Profile

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

December 19, 2015 Column, People Picker, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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.

December 17, 2015 Known Issues, Managed Metadata, SharePoint, SharePoint 2010, SharePoint 2013

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

December 14, 2015 Column, Managed Metadata, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

December 14, 2015 Admin Reports, CSV, Managed Metadata, PowerShell, SharePoint

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?

December 13, 2015 SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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?

December 12, 2015 Column, List, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

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

December 07, 2015 Content Type, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Site Columns

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

December 06, 2015 Content Type, Managed Metadata, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

December 04, 2015 Content Type, Managed Metadata, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

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

December 02, 2015 PowerShell, SharePoint, Site Columns

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?

December 01, 2015 SharePoint, SharePoint 2013, SharePoint 2016, Site Columns

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…

Disclaimer