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 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 become orphan and their E-mails also goes invalid. So prior…

Read more

Add Column to View in SharePoint using PowerShell

How to add a 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 in the current…

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 Projects list and wanted to add new member(s) to it for a particular list item. How to Set the People Picker…

Read more

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 not any…

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 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 to get value of Person or Group field….

Read more