Update User profile property using Powershell Sharepoint online Issue

Question

We want to update the customValue user profile property using powershell sharepoint online. The code updates only for one account '[email protected]' who is the globalk admin of the site. But none of other users, any suggestions

Import-Module Microsoft.Online.SharePoint.PowerShell -DisableNameChecking
               $username = "[email protected]" 
               $Adminurl = "https://Test-admin.sharepoint.com"
               $siteColUrl = "https://Test.sharepoint.com"


            try
             {
               Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"
               Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.UserProfiles.dll"
               Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
               Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.UserProfiles.dll"


               #Bind to site collection
               $password = Read-Host -Prompt "Enter password" -AsSecureString 
               $Context = New-Object Microsoft.SharePoint.Client.ClientContext($siteColUrl)
               #$ContextAdmin = New-Object Microsoft.SharePoint.Client.ClientContext($UserProfurl)

               $Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($username,$Password)
               $Context.Credentials = $Creds
               Write-Host "Successfully connected.." -ForegroundColor Green


               #Retrieve lists
               $web = $Context.Web
               $Users = $Context.Web.SiteUsers
               $items = $list.GetItems($query)
               $Context.Load($Users)
               $Context.Load($web)

               $Context.ExecuteQuery()
               $CustomValue  =10
               Write-Host $list.Title
               $PeopleManager = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($Context)
               Write-Host $items.Count

                Foreach ($User in $Users)
                {  
                  $UserNameValue =  $User.LoginName 
                  $UserProfile = $PeopleManager.GetPropertiesFor($UserNameValue)
                  $context.Load($UserProfile)
                  $Context.ExecuteQuery()
                      $PeopleManager.SetSingleValueProfileProperty($UserProfile.AccountName,"CustomValue", $CustomValue)
        $Context.ExecuteQuery() 
    }
    }

Answer 1

Last I knew, you had to do something like this:

$userEmailToCheck = "[email protected],[email protected]"
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext("https://tenant-admin.sharepoint.com")
$ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($credential.UserName, $credential.Password)
$web = $ctx.Web

$ctx.Load($web)
$ctx.ExecuteQuery()

$Users = $userEmailToCheck.Split(",")

$PeopleManager = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($ctx)
$loader =[Microsoft.SharePoint.Client.UserProfiles.ProfileLoader]::GetProfileLoader($ctx)

#To Get Profile
$profile = $loader.GetUserProfile()
$ctx.Load($profile)
$ctx.ExecuteQuery()


foreach($User in $Users){
  $UserProfile = $PeopleManager.GetPropertiesFor("i:0#.f|membership|"+$User)
  $ctx.Load($UserProfile)
  $ctx.ExecuteQuery()
  $PeopleManager.SetSingleValueProfileProperty($UserProfile.AccountName,"CustomValue", $CustomValue)
  $ctx.ExecuteQuery()      
}

I have another function I've used more recently that looks like this:

function Set-UPSValue {
        <#
        .SYNOPSIS
        Updates a SharePoint user profile property
        .DESCRIPTION    
        Updates a SharePoint user profile property
        .PARAMETER Email
        The users email address
        .PARAMETER Property
        The SharePoint Porperty to update
        .PARAMETER Value
        The property value
        .EXAMPLE
        Set-UPSValue -Email "[email protected]" -Property "Fax" -Value "567-555-1234"
    #>
    Param(
        [Parameter(Mandatory=$true,HelpMessage="The user email address",Position=0)][ValidateNotNull()]
        [string]$Email,

        [Parameter(Mandatory=$true,HelpMessage="The property to update",Position=1)][ValidateNotNull()]
        [string]$Property,

        [Parameter(Mandatory=$true,HelpMessage="The property value",Position=2)][ValidateNotNull()]
        [string]$Value
    )
    Begin {
        #Get the Client Context and Bind the Site Collection
        $context = New-Object Microsoft.SharePoint.Client.ClientContext($CAProd)

        #Authenticate
        $context.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($credential.UserName, $credential.Password)

        #Fetch the users in Site Collection
        $users = $context.Web.SiteUsers
        $context.Load($users)
        $context.ExecuteQuery()

        #Create an Object [People Manager] to retrieve profile information
        $people = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($context)
    }
    Process {
        try{
            $user = "i:0#.f|membership|"+$Email
            $userprofile = $people.GetPropertiesFor($user)
            $context.Load($userprofile)
            $context.ExecuteQuery()

            $people.SetSingleValueProfileProperty($userprofile.AccountName, $Property, $Value)
            $context.ExecuteQuery()
        }
        catch{
            $ErrorMessage = $_.Exception.Message
            write-host $ErrorMessage
        }
    }
    End {
        $context.Dispose()
    }   
}