Bulk create users in Azure AD with email field

user_2784375 0
Viewed 1357

I am trying to "bulk create" users into my Azure Active Directory using a .csv-file. It works as expected when I follow their "UserCreateTemplate.csv"-file, but when I add a field "Email [mail]" I get an error saying "Unknown CSV header found: Email [mail]"

Error when uploading .csv-file containing users

My .csv-file looks as follows:

version:v1.0
Name [displayName] Required,User name [userPrincipalName] Required,Initial passwor [passwordProfile] Required,Block sign in (Yes/No) [accountEnabled] Required,First name [givenName],Last name [surname],Mail [mail]
Bulked Test User,mb1@<redacted>.onmicrosoft.com,myPassword1234,No,My,Bulk User 1,mb1@example.com
azure-active-directory azure csv
1 Answers

It doesn't support to change the columns in csv template, so you couldn't add the email field.

enter image description here

Email field is only supported when bulk inviting users. Navigate to Azure Portal > Azure Active Directory > Users > Bulk operations > Click on Bulk invite.

You can paste the email addresses under "Email address to invite [inviteeEmail] Required" column and upload the file under Bulk Invite option. This will set the email address of the invited users in the mail attribute as well.

enter image description here

user_133083810
Related