SharePoint Online: Read / Update Person or Group Field (People Picker) Values using PowerShell

Requirement: Get or Set “Person or Group” Field Values in SharePoint Online using PowerShell. The person or Group field provides a searchable list of people and groups when adding or editing an item. It acts like an auto-complete field when you type the first four characters of the user names. Here is…

Read more

SharePoint Online: CAML Query for Person or Group Field in PowerShell

Requirement: SharePoint Online CAML Query for Person or Group field SharePoint Online: CAML Query to Filter Person or Group Field in PowerShell Let’s say we want to filter and get all projects where the “Project Manager” user field value is a particular person. SharePoint CAML Query Filter by User Name: The above…

Read more

Add-Remove User to SharePoint Multi-Valued People Picker Field using PowerShell

Requirement: We have a SharePoint list called “Projects” with 1000s of items. The list has a field called “Team Members” which allows multiple user values. We often get a requirement to either add or remove a particular user to all items or specific items filtered by other columns in the list. Solution: Adding-removing…

Read more

Update SharePoint List Items from CSV File using PowerShell

Requirement: Update SharePoint List Items from a CSV file. A bit of background: We have a list with 1000s of rows of organization-wide experts. Later we added a new field for “Department”. Now the requirement is to update the Department field for a specific list of users. While the Quick edit (or…

Read more

SharePoint Online: Add Person or Group (People Picker) Column to List using PowerShell

Requirement: Create Person or Group Column in SharePoint Online List. How to  Add Person or Group Column to List in SharePoint Online? The “Person or Group” column in SharePoint Online is used to get user or group value. This field can be configured to accept any value from the authentication provider, such…

Read more

SharePoint 2013 People Picker Error: Sorry, we’re having trouble reaching the server

Problem: While trying to add a new user to a SharePoint group, SharePoint 2013 People Picker displayed the error: “Sorry, we’re having trouble reaching the server.” Troubleshooting: The server may not have enough resources such as Memory to process the function without timing out. Try adding more memory to your SharePoint 2013…

Read more

PowerShell-CAML SPQuery to Filter List Items based of Person or Group Field Value

Requirement:In a project tracking SharePoint list, want to quickly get the list of projects where a particular user is listed as Project Manager – person or group (People picker) field. Solution: Use SPQuery with PowerShell as in the below example. PowerShell to Filter List Items based on Person or Group Field:

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

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