Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. Passionate about sharing the deep technical knowledge and experience to help others, through the real-world articles!

9 thoughts on “SharePoint Online: Bulk Update User Profiles using PowerShell

  • We are receiving an issue where our JSON looks correct, but it is returning this error: UnexpectedToken email@email.com Unexpected EndArry token found. Our JSON follows what it should. It does pull over 1,000 records.

    Reply
    • Were you ever able to resolve this? I’m experiencing the same.

      Reply
      • Check your JSON file. Does it have “PROPERTYNAME: null,” in it? If so, you need to swap them out for empty strings. Best way is when constructing your object to convert to JSON, make sure you coalesce nulls to empty strings. If that’s too much like hard work, you could always do something like this: $json = $json.Replace(‘: null,’, ‘: “”‘);

        Reply
  • Is it possible to get profiles Directory Extensions synced to SharePoint using this same method? For example, I’m trying to sync the IP Phone and Notes attributes in AD (ipPhone and info) to custom SharePoint user properties. It looks like all directory extensions are bundled within the ExtensionProperty attribute in Azure AD, and when I try to extract that AD user property it messes up the JSON since there are multiple entries within that attribute. Any ideas would be welcome. Perhaps something with Get-AzureADUserExtension?

    Reply
  • I am updating About Me of user profile using this script. If About Me contains & it is updating as \u0026 in the json file. About Me on Delve is not showing the entire content. It is trimming the content after &. If I go to backend user profile, edit profile and update, it shows the complete About Me text.

    Ex: He is an expert in SharePoint & Powershell. This gets update in json as “He is an expert in SharePoint \u0026 Powershell.”

    on Delve it shows He is an expert in SharePoint

    How can we resolve this?

    Reply
  • I’m seeing the following error message: “New-PnPUPABulkImportJob : Folder /User Profile Import does not exist.” Is the path correct?

    Reply
    • Create a new document library “User Profile Import” in your root site, so that the log files gets saved there.

      Reply
  • How are you able to get the automation working? Using the ClientId and ClientSecret returns an Access denied error with New-PnPUPBulkImportJob.

    Reply
    • You got to grant access to your Client ID on the tenant, If you are using ClientId and ClientSecret method!

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *