Update User Profile Properties On SharePoint Online Using CSOM PowerShell

Nakkeeran Natarajan

10y35.5k110100Article

11 Comments

Join the conversation! Your thoughts help the community grow.

Yogendra Bhardwaj10y ago
I have found the root cause that i was running script in Windows Power Shell windows instead of sharepoint Management shell
Yogendra Bhardwaj10y ago
Yes , i have checked at location C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\ in fact i removed Sharepoint Online SDK and Install again but same result
Yogendra Bhardwaj10y ago
I have checked SDK version and using this script for sharepoint online
Yogendra Bhardwaj10y ago
Method invocation failed because [Microsoft.SharePoint.Client.UserProfiles.PeopleManager] does not contain a method named 'SetSingleValueProfileProperty'.
- Nakkeeran Natarajan10y ago
  Yogenda Bhardwaj The issue must be mostly due to the reference. From the step 1, you could see the latest version (16). do you have the latest reference installed on your local?
Yogendra Bhardwaj10y ago
HI There i am getting error below
- Nakkeeran Natarajan10y ago
  Yogenda Bhardwaj hi. I have checked it and the above snippet should work. Have you followed all the steps?
Vignesh Mani10y ago
nice
Sonu Chaudhary10y ago
good one
Debasis Saha10y ago
Nice sharing..
Kuppurasu Nagaraj10y ago
Nice Sharing..

Introduction

In this article, you will learn how to update SharePoint user profile properties programmatically in different ways using CSOM with PowerShell on SharePoint online - Office 365 sites. The update property option is available only on Office 365 sites as of now and it is not available on on-premise versions.

Steps Involved

The following prerequisites need to be executed before going for any operations using CSOM PowerShell on SharePoint sites.

Add the references using the Add-Type command with necessary reference paths. The necessary references are Microsoft.SharePoint.Client.dll, Microsoft.SharePoint.Client.Runtime.dll and UserProfile dll. The references should be from 16 folder, since these are latest updates from Microsoft.
1. Add-Type -Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"
2. Add-Type -Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
3. Add-Type -Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.UserProfiles.dll"
Initialize client context object with the site URL.
1. $siteURL = ""
2. $ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteURL)
If you are trying to access SharePoint Online site, then you need to setup the site credentials with credentials parameter and get it set to the client context.
1. #Setting Credentials for o365 - Start
2. $userId = ""
3. $pwd = Read-Host -Prompt "Enter password" -AsSecureString
4. $creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userId, $pwd)
5. $ctx.credentials = $creds
6. #Setting Credentials for o365 - End
There are multiple ways of updating the properties of SharePoint user profile. There will be properties with just a value or line of text and properties with collection of values. Two different methods are used to update those properties. Following tells us with examples.

Single Value properties - WorkPhone, Mobile, FirstName, LastName, etc.
Multi Valued properties - Ask Me About, Skills, Interests, etc.

Update Single Value Properties

Initialize the people manager object with the context to get the user profile data.
Using SetSingleValueProfileProperty method set the property for any target user.
Load the object and execute query to get the data.
1. # Update User Profile property (office 365)
2. function SetSingleValueProperty(){
3. try{
4. $peopleManager = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($ctx)
5. $peopleManager.SetSingleValueProfileProperty("i:0#.f|membership|[email protected]", "AboutMe", "Your description")
6. $ctx.Load($peopleManager)
7. $ctx.ExecuteQuery()
8. Write-Host "Property updated"
9. }
10. catch{
11. Write-Host "$($_.Exception.Message)" -foregroundcolor Red
12. }
13. }

You can update as many properties as possible.

$peopleManager = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($ctx)
$peopleManager.SetSingleValueProfileProperty("i:0#.f|membership|[email protected]", "AboutMe", "Your description")
$peopleManager.SetSingleValueProfileProperty("i:0#.f|membership|[email protected]", "SPS-Location", "Bangalore")
$ctx.Load($peopleManager)
$ctx.ExecuteQuery()
Write-Host "Properties updated"

Update Multi Valued Properties

In the above section, we have seen how we can set the single value profile properties for target user. Now we will see how we can set user profile multi valued properties for target user.

Initialize the people manager object with the context to get the user profile data.
Then initialize the list collection object and set the values in the collection variable.
Using SetMultiValuedProfileProperty method, set the multi valued property for any target user. (Here updated ask me about - Responsibility field).
Load the object and execute query to get the data.
1. # Update User Profile Multi Valued properties (office 365)
2. function SetMultiValuedProperty(){
3. try{
4. $peopleManager = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($ctx)
5. $propertyValues =New-Object "System.Collections.Generic.List``1[System.string]"
6. # My responsibilities
7. $propertyValues.Add("SharePoint")
8. $propertyValues.Add("Project1")
9. $propertyValues.Add("Project2")
10. #update value
11. $peopleManager.SetMultiValuedProfileProperty("i:0#.f|membership|[email protected]", "SPS-Responsibility", $propertyValues)
12. $ctx.Load($peopleManager)
13. $ctx.ExecuteQuery()
14. }
15. catch{
16. Write-Host "$($_.Exception.Message)" -foregroundcolor Red
17. }
18. }

The above operation will override (set) the existing property values. If you want to update the existing property values, you need to retrieve the existing value using get operation and then set the properties along with new values.

Note: The above set of operations needs to be called to get it executed.

SetSingleValueProperty # Update User Profile properties (office 365)
SetMultiValuedProperty # Update User Profile Multi Valued properties (office 365)

Summary

Thus you have learned how to update or set user profile properties for any user by various approaches using CSOM with PowerShell on SharePoint online sites (Office 365).