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. Person or Group field provides searchable list of people and groups when they add or edit an item. It acts like a auto complete field when you type the first 4 character 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 “Project Manager” user field value is a particular person. SharePoint CAML Query Filter by User Name: The above PowerShell…

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 CSV file. A bit background: We have a list with 1000’s 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 datasheet view can be used…

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 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 web…

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

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