Microsoft 365 Display Names and Powershell Attribute Names to be used while importing using CSV file.
Create users in bulk using CSV
(Mandatory fields marked by *)Name in Microsoft 365 | Header in CSV file |
---|---|
User name* | UserPrincipalName |
Display Name * | DisplayName |
First Name | FirstName |
Last Name | LastName |
Location | UsageLocation |
Office | Office |
Phone Number | PhoneNumber |
Title | Title |
State or province | State |
Mobile Phone | MobilePhone |
Street Address | StreetAddress |
City | City |
Country or Region | Country |
Department | Department |
Fax Number | Fax |
Alternate Mobile Phones | AlternateMobilePhones |
Alternate Email Addresses | AlternateEmailAddresses |
ZIP or Postal Code | PostalCode |
Password NeverExpires | PasswordNeverExpires |
Strong Password Required | StrongPasswordRequired |
Password | Password |
Force Change Password on Next Logon | ForceChangePassword |
Preferred Language | PreferredLanguage |
Create shared mailboxes in bulk using CSV
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Name* | Specifies the unique name of the mailbox. |
Alias | Specifies the Exchange alias (also known as the mail nickname) for the recipient. Value should not contain white spaces. |
PrimarySmtpAddress | Specifies the primary return email address that's used for the recipient. |
FirstName | Specifies the user's first name. |
LastName | Specifies the user's last name. |
DisplayName | Specifies the display name of the mailbox. |
Initials | Specifies the user's middle initials. The maximum length is 6 characters. |
ModeratedBy | Specifies one or more moderators for this group. A moderator approves messages sent to the group before the messages are delivered and it must be a mailbox, mail user, or mail contact in your organization. |
SendModerationNotifications | Specifies when moderation notification messages are sent.
|
ModerationEnabled | Specifies whether moderation is enabled for this recipient |
Create distribution groups in bulk using CSV
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Name* | Specifies the unique name of the group. |
ModeratedBy | Specifies one or more moderators for this group. A moderator approves messages sent to the group before the messages are delivered and it must be a mailbox, mail user, or mail contact in your organization. |
RequireSenderAuthenticationEnabled | Specifies whether to accept messages only from authenticated (internal) senders. |
ModerationEnabled | Specifies whether moderation is enabled for this recipient |
DisplayName | Specifies the display name of the group. |
MemberDepartRestriction | Specifies the restrictions that you put on requests to leave the group |
BypassNestedModerationEnabled | Specifies how to handle message approval when a moderated group contains other moderated groups as members. |
Members | Specifies the recipients (mail-enabled objects) that are members of the group. |
MemberJoinRestriction | Specifies the restrictions that you put on requests to join the group.
|
Alias | Specifies the Exchange alias (also known as the mail nickname) for the recipient. Value should not contain white spaces. |
ManagedBy | Specifies an owner for the group. If you don't use this parameter to specify the owner when you create the group, the user account that created the group is the owner. |
PrimarySmtpAddress | Specifies the primary return email address that's used for the recipient. |
SendModerationNotifications | Specifies when moderation notification messages are sent.
|
Create mail-enabled security groups in bulk using CSV
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Name* | Specifies the unique name of the group. |
ModeratedBy | Specifies one or more moderators for this group. A moderator approves messages sent to the group before the messages are delivered and it must be a mailbox, mail user, or mail contact in your organization. |
RequireSenderAuthenticationEnabled | Specifies whether to accept messages only from authenticated (internal) senders. |
ModerationEnabled | Specifies whether moderation is enabled for this recipient |
DisplayName | Specifies the display name of the group. |
MemberDepartRestriction | Specifies the restrictions that you put on requests to leave the group |
BypassNestedModerationEnabled | Specifies how to handle message approval when a moderated group contains other moderated groups as members. |
Members | Specifies the recipients (mail-enabled objects) that are members of the group. |
MemberJoinRestriction | Specifies the restrictions that you put on requests to join the group.
|
Alias | Specifies the Exchange alias (also known as the mail nickname) for the recipient. Value should not contain white spaces. |
ManagedBy | Specifies an owner for the group. If you don't use this parameter to specify the owner when you create the group, the user account that created the group is the owner. |
PrimarySmtpAddress | Specifies the primary return email address that's used for the recipient. |
SendModerationNotifications | Specifies when moderation notification messages are sent.
|
Create dynamic distribution groups in bulk using CSV
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Name* | Specifies the unique name of the group. |
ModeratedBy | Specifies one or more moderators for this group. A moderator approves messages sent to the group before the messages are delivered and it must be a mailbox, mail user, or mail contact in your organization. |
ModerationEnabled | Specifies whether moderation is enabled for this recipient |
DisplayName | Specifies the display name of the group. |
Alias | Specifies the Exchange alias (also known as the mail nickname) for the recipient. Value should not contain white spaces. |
PrimarySmtpAddress* | Specifies the primary return email address that's used for the recipient. |
SendModerationNotifications | Specifies when moderation notification messages are sent.
|
IncludedRecipients* | Specifies a filter that's based on the recipient type.
|
ConditionalCompany | Specifies a filter that's based on the value of the recipient's Company property. |
ConditionalDepartment | Specifies a filter that's based on the value of the recipient's Department property. |
ConditionalStateOrProvince | Specifies a filter that's based on the value of the recipient's StateOrProvince property. |
ConditionalCustomAttribute(1 to 15) | Specifies a filter that's based on the value of the recipient's CustomAttribute1 to CustomAttribute15 property. |
Create contacts in bulk using CSV
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Name* | Specifies the unique name of mail contact. |
ExternalEmailAddress* | Specifies the target email address of the mail contact or mail user. |
FirstName | Specifies the contact's first name. |
LastName | Specifies the contact's last name. |
DisplayName | Specifies the display name of the mail contact. |
ModeratedBy | Specifies one or more moderators for this mail contact. A moderator approves messages sent to the mail contact and it must be a mailbox, mail user, or mail contact in your organization |
Alias | Specifies the Exchange alias (also known as the mail nickname) for the recipient. Value should not contain white spaces. |
Initials | Specifies the contact's middle initials. The maximum length is 6 characters. |
ModerationEnabled | Specifies whether moderation is enabled for this recipient. |
SendModerationNotifications |
|
Company | Specifies the contact's company name. |
Title | Specifies the contact's title. |
PhoneNumber | Specifies the contact's office phone number. |
MobilePhone | Specifies the contact's personal mobile number. |
Fax | Specifies the contact's fax number. |
Department | Specifies the contact's department. |
Office | Specifies the contact's physical office name. |
StreetAddress | Specifies the contact's physical address. |
City | Specifies the contact's city. |
State | Specifies the contact's state. |
Country | Specifies the contact's country. |
PostalCode | Specifies the contact's postal code. |
Modify the custom attribute values of Microsoft 365 objects
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Identity* | Specifies the unique name of object. |
CustomAttribute1 to CustomAttribute15 | These parameters specify custom attributes. You can use these attributes to store additional information.Value should contain not more than 1024 characters. |
ExtensionCustomAttribute1 to ExtensionCustomAttribute5 | These paramenters specify custom attributes that store additional information. You can specify multiple values for these parameters as a comma delimited list. |
Set forwarding address to mailboxes
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Identity* | Specifies the group that you want to modify.You can use any values that uniquely identifies the group. For example: Name, Display name, Alias, Distinguished name (DN), Canonical DN, Email address, GUID |
ForwardToOption* | Specifies the type of the forwarding.Valid values are:
|
DeliverToMailboxAndForward | Specifies the message delivery behavior when a forwarding address is specified by the ForwardingAddress parameter. |
ForwardingAddress | Specifies a forwarding address for messages that are sent to this mailbox. (Mandatory for 'ToInternal' and 'ToExternal' option in 'ForwardToOption') |
Add members to groups and also remove members from groups
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Identity* | Specifies the group that you want to modify.You can use any values that uniquely identifies the group. For example: Name, Display name, Alias, Distinguished name (DN), Canonical DN, Email address, GUID |
Type* | Specifies the type of the group.Valid values are:
|
Members* | This parameter is used to identify the members(users and groups). |
Operation* | Specifies the operation to be performed.Valid values are:
|
Modify the custom attribute values of groups.
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Identity* | Specifies the group that you want to modify.You can use any values that uniquely identifies the group. For example: Name, Display name, Alias, Distinguished name (DN), Canonical DN, Email address, GUID |
Type* | Specifies the type of the group.Valid values are:
|
CustomAttribute1 to CustomAttribute15 | These parameters specify custom attributes. You can use these attributes to store additional information.Value should contain not more than 1024 characters. |
ExtensionCustomAttribute1 to ExtensionCustomAttribute5 | These paramenters specify custom attributes that store additional information. You can specify multiple values for these parameters as a comma delimited list. |
Create Microsoft 365 group creation in bulk using CSV
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
DisplayName* | Specifies the name of the Microsoft 365 Group. The display name is visible in the Exchange admin center, address lists, and Outlook. |
Notes | Specifies the description of the Microsoft 365 Group. If the value contains spaces, enclose the value in quotation marks. |
RequireSenderAuthenticationEnabled | Specifies whether to accept messages only from authenticated (internal) senders. |
Owner | Specifies one or more owners for the Microsoft 365 Group. |
Members | Specifies the recipients (mail-enabled objects) that are members of the group. |
PrimarySmtpAddress | Specifies the primary return email address that's used for the recipient. |
Name | Specifies the Name of the Microsoft 365 group.The value that you use for this is parameter is appended with an underscore character (_) and a short GUID value. |
EmailAddresses | Specifies all the email addresses (proxy addresses) for the recipient, including the primary SMTP address. |
Alias | Specifies the Exchange alias (also known as the mail nickname) for the Microsoft 365 Group. This value identifies the recipient as a mail-enabled object, and shouldn't be confused with multiple email addresses for the same recipient (also known as proxy addresses). A recipient can have only one Alias value. Value should not contain white spaces. |
AccessType | Specifies the privacy type for the Microsoft 365 Group. Valid values are:
|
ManagedBy | Specifies an owner for the group. If you don't use this parameter to specify the owner when you create the group, the user account that created the group is the owner. |
SendModerationNotifications | Specifies when moderation notification messages are sent.
|
Modify groups in bulk
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Identity* | Specifies the group that you want to modify.You can use any values that uniquely identifies the group. For example: Name, Display name, Alias, Distinguished name (DN), Canonical DN, Email address, GUID |
Type* | Specifies the type of the group.Valid values are:
|
Modify the naming attributes of mailboxes.
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
Identity* | Specifies the mailbox that you want to modify. You can use any value that uniquely identifies the mailbox. |
Name | Specifies the unique name of the mailbox. The maximum length is 64 characters. |
Alias | Specifies the Exchange alias (also known as the mail nickname) for the recipient.The value of Alias can contain letters, numbers and the characters !, #, $, %, &, ', *, +, -, /, =, ?, ^, _, `, {, |, } and ~. Periods (.) are allowed, but each period must be surrounded by other valid characters (for example, help.desk).The maximum length of the Alias value is 64 characters. Value should not contain white spaces. |
ArchiveName | Specifies the name of the archive mailbox. |
SimpleDisplayName | Specifies an alternative description of the object. |
Create security groups in bulk using CSV
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
DisplayName* | Specifies the display name of the group. |
MailNickName* | Specifies the nickname of a mail. |
Description | Specifies the description of a group |
Clear mobile device data in bulk using CSV
(Mandatory fields marked by *)Header in CSV file | Description |
---|---|
DeviceId* | Specifies the identity of the device that you want to clear. |
NotificationEmail | Specifies the email address to which the device wipe confirmation will be sent. You can provide multiple email addresses separated by commas. |
Modify SMTP Address of Mailbox and Mail Users in bulk
(Mandatory fields marked by *)Name in Microsoft 365 | Header in CSV file |
---|---|
UserPrincipalName* | Specifies the object that you want to modify. You can use any value that uniquely identifies the mailbox. |
Display Name | DisplayName |
First Name | FirstName |
Last Name | LastName |
Office | Office |
Mobile Phone | MobilePhone |
Title | Title |
City | City |
Country or Region | Country |
Department | Department |
Fax Number | Fax |
ZIP or Postal Code | PostalCode |
UserPrincipalName (UPN Prefix) | UPNPrefix |
Modify SMTP Address of Contacts in bulk
(Mandatory fields marked by *)Name in Microsoft 365 | Header in CSV file |
---|---|
Identity* | Specifies the contact that you want to modify. You can use any value that uniquely identifies the mailbox. |
Display Name | DisplayName |
First Name | FirstName |
Last Name | LastName |
Office | Office |
Mobile Phone | MobilePhone |
Title | Title |
City | City |
Country or Region | Country |
Department | Department |
Fax Number | Fax |
ZIP or Postal Code | PostalCode |
Email Address (Prefix) | EmailPrefix |
Modify SMTP Address of Groups in bulk
(Mandatory fields marked by *)Name in Microsoft 365 | Header in CSV file |
---|---|
Identity* | Specifies the group that you want to modify. You can use any value that uniquely identifies the mailbox. |
Display Name | DisplayName |
Email Address (Prefix) | EmailPrefix |
Type* | Specifies the type of the group.Valid values are:
|
Set Send On Behalf Permission of Groups in bulk
(Mandatory fields marked by *)Name in Microsoft 365 | Header in CSV file |
---|---|
Identity* | Specifies the group that you want to modify. You can use any value that uniquely identifies the mailbox. |
Type* | Specifies the type of the group.Valid values are:
|
Microsoft Teams Channel Creation in Bulk
(Mandatory fields marked by *)Name | Description |
---|---|
DisplayName* | Specifies the name of the channel. |
Description | Specifies the description of the channel. |
Owner | Specifies the owner(object id) of the channel. It is mandatory for a private channel but not supported for a standard channel |
MembershipType* | Specifies the membership type of the channel.Valid values are:
|