Office 365 bulk update users information

Anonymous
2022-08-02T08:19:54+00:00

Dear MS community,
i need to update all users job titles, i received a csv file including all users email address and their new titles, so please how do i achieve this?

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2022-08-02T10:46:32+00:00

Dear Osamah,

Good day! Thank you for posting your query in our community. We are happy to help you.

Based on your description, you want to bulk update the Job title of the user information. You can try the following steps to check if you can update all users via PowerShell:

  1. Download the SharePoint Online Management Shell: Download SharePoint Online Management Shell from Official Microsoft Download Center
  2. Open the Download the SharePoint Online Management Shell as Administrator;
  3. Install PowerShell Gallery | ExchangeOnlineManagement 2.0.5 Module and PowerShell Gallery | MSOnline 1.1.183.66 Module: Install-Module -Name ExchangeOnlineManagement -RequiredVersion 2.0.5 Install-Module -Name MSOnline
  4. Connect to these two Module: Connect-ExchangeOnline -UserPrincipalName ******@contoso.com Connect-MsolService
  5. Run the command:  $user_file =import-csv C:\Users\Administrator\Desktop\users.csv $user_file | ForEach-Object { Set-MsolUser -UserPrincipalName $_.Userprincipalname -title $_.Title}
  6. Done. Then you can check in the Microsoft 365 admin center.

 

Sincerely,

Jazlyn | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

Was this answer helpful?

4 people found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful