Add Lookup Field to SharePoint List using PowerShell

Requirement: PowerShell script to add lookup field to SharePoint list: Scenario: You have a parent list called “Parent Projects” and a child list “Project Milestones”. The “Parent Project Name” field in the child list is being looked up from the parent list’s “Project Name” field. PowerShell to Add Lookup Field to SharePoint…

Read more

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 Name for your column. …

Read more

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 email 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 becomes an orphan, and their Emails also go invalid. So prior…

Read more

Add Column to View in SharePoint using PowerShell

How to add a column to view in SharePoint? You can add columns to your view in just a few easy steps. To add a 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…

Read more

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’t start the service automatically – when stopped. So, let’s address…

Read more

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

Requirement: Update existing People Picker field value using PowerShell in SharePoint. PowerShell to add a new user to the existing People Picker field: We have a field called “Team Members” in the Projects list and wanted to add new member(s) to it for a particular list item. How to Set the People…

Read more

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

By default, SharePoint Lists and Libraries inherit permissions from their parent site when created. There are times when you may want to implement unique permissions on a SharePoint list level. E.g., if there are users who should access only a specific list in a SharePoint site but not any other object. So,…

Read more

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 Person 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: Here is the PowerShell script to get the value of…

Read more