List of Office 365 Attributes Supported by OMP

Office 365 Display Names and Powershell Attribute Names to be used while importing using CSV file.

Bulk User Creation

Create users in bulk using CSV

(Mandatory fields marked by *)
Name in Office 365 Header in CSV file
User name*UserPrincipalName
Display Name *DisplayName
First NameFirstName
Last NameLastName
LocationUsageLocation
OfficeOffice
Phone NumberPhoneNumber
TitleTitle
State or provinceState
Mobile PhoneMobilePhone
Street AddressStreetAddress
CityCity
Country or RegionCountry
DepartmentDepartment
Fax NumberFax
Alternate Mobile PhonesAlternateMobilePhones
Alternate Email AddressesAlternateEmailAddresses
ZIP or Postal CodePostalCode
Password NeverExpiresPasswordNeverExpires
Strong Password RequiredStrongPasswordRequired
PasswordPassword
Force Change Password on Next LogonForceChangePassword
Preferred LanguagePreferredLanguage

Bulk Shared Mailbox Creation

Create shared mailboxes in bulk using CSV

(Mandatory fields marked by *)
Header in CSV file Description
Name*Specifies the unique name of the mailbox.
AliasSpecifies the Exchange alias (also known as the mail nickname) for the recipient.
PrimarySmtpAddressSpecifies the primary return email address that's used for the recipient.
FirstNameSpecifies the user's first name.
LastNameSpecifies the user's last name.
DisplayNameSpecifies the display name of the mailbox.
InitialsSpecifies the user's middle initials.
ModeratedBySpecifies 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.
SendModerationNotificationsSpecifies when moderation notification messages are sent.
  • Always : Notify all senders when their messages aren't approved. This is the default value.
  • Internal : Notify senders in the organization when their messages aren't approved.
  • Never :Don't notify anyone when a message isn't approved.
ModerationEnabledSpecifies whether moderation is enabled for this recipient

Distribution Group Creation

Create distribution groups in bulk using CSV

(Mandatory fields marked by *)
Header in CSV file Description
Name*Specifies the unique name of the group.
ModeratedBySpecifies 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.
RequireSenderAuthenticationEnabledSpecifies whether to accept messages only from authenticated (internal) senders.
ModerationEnabledSpecifies whether moderation is enabled for this recipient
DisplayNameSpecifies the display name of the group.
MemberDepartRestrictionSpecifies the restrictions that you put on requests to leave the group
BypassNestedModerationEnabledSpecifies how to handle message approval when a moderated group contains other moderated groups as members.
MembersSpecifies the recipients (mail-enabled objects) that are members of the group.
MemberJoinRestriction Specifies the restrictions that you put on requests to join the group.
  • Open : Users can add themselves to the group without approval from one of the group owners. You can't use this value on universal security groups.
  • Closed :Users can't add themselves to the group, and requests to join the group are rejected automatically. Group membership is controlled by the group owners. This is the default value on universal security groups and universal distribution groups.
  • ApprovalRequired :Users can request to join the group. The user is added to the group after the request is approved by one of the group owners.
AliasSpecifies the Exchange alias (also known as the mail nickname) for the recipient
ManagedBySpecifies 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.
PrimarySmtpAddressSpecifies the primary return email address that's used for the recipient.
SendModerationNotificationsSpecifies when moderation notification messages are sent.
  • Always : Notify all senders when their messages aren't approved. This is the default value.
  • Internal : Notify senders in the organization when their messages aren't approved.
  • Never :Don't notify anyone when a message isn't approved.

Mail-Enalbed Security Group Creation

Create mail-enalbed security groups in bulk using CSV

(Mandatory fields marked by *)
Header in CSV file Description
Name*Specifies the unique name of the group.
ModeratedBySpecifies 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.
RequireSenderAuthenticationEnabledSpecifies whether to accept messages only from authenticated (internal) senders.
ModerationEnabledSpecifies whether moderation is enabled for this recipient
DisplayNameSpecifies the display name of the group.
MemberDepartRestrictionSpecifies the restrictions that you put on requests to leave the group
BypassNestedModerationEnabledSpecifies how to handle message approval when a moderated group contains other moderated groups as members.
MembersSpecifies the recipients (mail-enabled objects) that are members of the group.
MemberJoinRestriction Specifies the restrictions that you put on requests to join the group.
  • Closed :Users can't add themselves to the group, and requests to join the group are rejected automatically. Group membership is controlled by the group owners. This is the default value on universal security groups and universal distribution groups.
  • ApprovalRequired :Users can request to join the group. The user is added to the group after the request is approved by one of the group owners.
AliasSpecifies the Exchange alias (also known as the mail nickname) for the recipient
ManagedBySpecifies 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.
PrimarySmtpAddressSpecifies the primary return email address that's used for the recipient.
SendModerationNotificationsSpecifies when moderation notification messages are sent.
  • Always : Notify all senders when their messages aren't approved. This is the default value.
  • Internal : Notify senders in the organization when their messages aren't approved.
  • Never :Don't notify anyone when a message isn't approved.

Dynamic Distribution Group Creation

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.
ModeratedBySpecifies 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.
ModerationEnabledSpecifies whether moderation is enabled for this recipient
DisplayNameSpecifies the display name of the group.
AliasSpecifies the Exchange alias (also known as the mail nickname) for the recipient
PrimarySmtpAddress*Specifies the primary return email address that's used for the recipient.
SendModerationNotificationsSpecifies when moderation notification messages are sent.
  • Always : Notify all senders when their messages aren't approved. This is the default value.
  • Internal : Notify senders in the organization when their messages aren't approved.
  • Never :Don't notify anyone when a message isn't approved.
IncludedRecipients*Specifies a filter that's based on the recipient type.
  • AllRecipients
  • MailContacts
  • MailGroups
  • MailUsers
  • Resources :This value indicates room or equipment mailboxes.
ConditionalCompanySpecifies a filter that's based on the value of the recipient's Company property.
ConditionalDepartmentSpecifies a filter that's based on the value of the recipient's Department property.
ConditionalStateOrProvinceSpecifies 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.

Contacts Creation

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 user's first name.
LastName Specifies the user'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.
Initials Specifies the user's middle initials.
ModerationEnabled Specifies whether moderation is enabled for this recipient.
SendModerationNotifications
  • Always : Notify all senders when their messages aren't approved. This is the default value.
  • Internal : Notify senders in the organization when their messages aren't approved.
  • Never :Don't notify anyone when a message isn't approved.

Modify Custom Attribute

Modify the custom attribute values of Office 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.

Mailbox Forward To (using CSV)

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:
  • ToExternal
  • ToInternal
  • ForwardDisabled
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/Remove Group Members

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:
  • Office365Group
  • DistributionGroup
  • MailEnabledSecurityGroup
Members* This parameter is used to identify the members(users and groups).
Operation* Specifies the operation to be performed.Valid values are:
  • Add
  • Remove

Modify Groups Custom Attributes

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:
  • Office365Group
  • DistributionGroup
  • MailEnabledSecurityGroup
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.

Office 365 group creation

Create Office 365 group creation in bulk using CSV

(Mandatory fields marked by *)
Header in CSV file Description
DisplayName*Specifies the name of the Office 365 Group. The display name is visible in the Exchange admin center, address lists, and Outlook.
NotesSpecifies the description of the Office 365 Group. If the value contains spaces, enclose the value in quotation marks.
RequireSenderAuthenticationEnabledSpecifies whether to accept messages only from authenticated (internal) senders.
OwnerSpecifies one or more owners for the Office 365 Group.
MembersSpecifies the recipients (mail-enabled objects) that are members of the group.
PrimarySmtpAddressSpecifies the primary return email address that's used for the recipient.
NameSpecifies the Name of the Office 365 group.The value that you use for this is parameter is appended with an underscore character (_) and a short GUID value.
EmailAddressesSpecifies all the email addresses (proxy addresses) for the recipient, including the primary SMTP address.
AliasSpecifies the Exchange alias (also known as the mail nickname) for the Office 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.
AccessType Specifies the privacy type for the Office 365 Group. Valid values are:
  • Public : The group content and conversations are available to everyone, and anyone can join the group without approval from a group owner. This is the default value.
  • Private :The group content and conversations are only available to members of the group, and joining the group requires approval from a group owner.
ManagedBySpecifies 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.
SendModerationNotificationsSpecifies when moderation notification messages are sent.
  • Always : Notify all senders when their messages aren't approved. This is the default value.
  • Internal : Notify senders in the organization when their messages aren't approved.
  • Never :Don't notify anyone when a message isn't approved.

Group Selection

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:
  • Office365Group
  • DistributionGroup
  • MailEnabledSecurityGroup

Mailbox Naming Attribute Changes

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.
ArchiveName Specifies the name of the archive mailbox.
SimpleDisplayName Specifies an alternative description of the object.

Security Group Creation

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.
DescriptionSpecifies the description of a group

Clear Mobile Device Data

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.
NotificationEmailSpecifies 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 Users

Modify SMTP Address of Mailbox and Mail Users in bulk

(Mandatory fields marked by *)
Name in Office 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 NameDisplayName
First NameFirstName
Last NameLastName
OfficeOffice
Mobile PhoneMobilePhone
TitleTitle
CityCity
Country or RegionCountry
DepartmentDepartment
Fax NumberFax
ZIP or Postal CodePostalCode
UserPrincipalName (UPN Prefix)UPNPrefix

Modify SMTP Address of Contacts

Modify SMTP Address of Contacts in bulk

(Mandatory fields marked by *)
Name in Office 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 NameDisplayName
First NameFirstName
Last NameLastName
OfficeOffice
Mobile PhoneMobilePhone
TitleTitle
CityCity
Country or RegionCountry
DepartmentDepartment
Fax NumberFax
ZIP or Postal CodePostalCode
Email Address (Prefix)EmailPrefix

Modify SMTP Address of Groups

Modify SMTP Address of Groups in bulk

(Mandatory fields marked by *)
Name in Office 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 NameDisplayName
Email Address (Prefix)EmailPrefix
Type* Specifies the type of the group.Valid values are:
  • Office365Group
  • DistributionGroup
  • MailEnabledSecurityGroup
  • DynamicDistributionGroup

Set Send On Behalf Permission of Groups

Set Send On Behalf Permission of Groups in bulk

(Mandatory fields marked by *)
Name in Office 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:
  • Office365Group
  • DistributionGroup
  • MailEnabledSecurityGroup
  • DynamicDistributionGroup
Get download link