Microsoft Entra ID (aaduser) table/entity reference

Virtual entity that represents Microsoft Entra ID

Messages

The following table lists the messages for the Microsoft Entra ID (aaduser) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
Create Event: True	POST /aadusers See Create	Create records
Delete Event: True	DELETE /aadusers(aaduserid) See Delete	Delete records
Retrieve Event: True	GET /aadusers(aaduserid) See Retrieve	Retrieve records
RetrieveEntityChanges Event: True		RetrieveEntityChangesRequest
RetrieveMultiple Event: True	GET /aadusers See Query data	Query data
Update Event: True	PATCH /aadusers(aaduserid) See Update	Update records
Upsert Event: False	PATCH /aadusers(aaduserid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Microsoft Entra ID (aaduser) table.

Property	Value
DisplayName	Microsoft Entra ID
DisplayCollectionName	Microsoft Entra IDs
SchemaName	aaduser
CollectionSchemaName	aadusers
EntitySetName	aadusers
LogicalName	aaduser
LogicalCollectionName	aadusers
PrimaryIdAttribute	aaduserid
PrimaryNameAttribute	displayname
TableType	Virtual
OwnershipType	OrganizationOwned

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• aaduserId
• AccountEnabled
• BusinessPhones
• City
• CompanyName
• DisplayName
• GivenName
• id
• ImAddresses
• JobTitle
• Mail
• MobilePhone
• OfficeLocation
• PostalCode
• PreferredLanguage
• StreetAddress
• surname
• UserPrincipalName
• UserType

aaduserId

Property	Value
Description	Unique identifier of a Microsoft Entra ID.
DisplayName	Id
IsValidForForm	False
IsValidForRead	True
LogicalName	aaduserid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

AccountEnabled

Property	Value
Description	Indicates if the Account of an Microsoft Entra ID is enabled.
DisplayName	Microsoft Entra ID Account Enabled
IsValidForForm	True
IsValidForRead	True
LogicalName	accountenabled
RequiredLevel	None
Type	Boolean
GlobalChoiceName	adduser_account_enabled
DefaultValue	False
True Label	Yes
False Label	No

BusinessPhones

Property	Value
Description	Business phone number for the user
DisplayName	Business Phones
IsValidForForm	True
IsValidForRead	True
LogicalName	businessphones
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

City

Property	Value
Description	City.
DisplayName	City
IsValidForForm	True
IsValidForRead	True
LogicalName	city
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

CompanyName

Property	Value
Description	Company Name.
DisplayName	Company Name
IsValidForForm	True
IsValidForRead	True
LogicalName	companyname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

DisplayName

Property	Value
Description	The name displayed in the address book for the user.
DisplayName	Display Name
IsValidForForm	True
IsValidForRead	True
LogicalName	displayname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

GivenName

Property	Value
Description	The given name (first name) of the user.
DisplayName	Given Name
IsValidForForm	True
IsValidForRead	True
LogicalName	givenname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

id

Property	Value
Description	A unique identifer for Microsoft Entra ID
DisplayName	A unique identifer for Microsoft Entra ID
IsValidForForm	True
IsValidForRead	True
LogicalName	id
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ImAddresses

Property	Value
Description	ImAddresses for the user
DisplayName	ImAddresses
IsValidForForm	True
IsValidForRead	True
LogicalName	imaddresses
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

JobTitle

Property	Value
Description	The user's job title.
DisplayName	Job Title
IsValidForForm	True
IsValidForRead	True
LogicalName	jobtitle
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Mail

Property	Value
Description	The SMTP address for the user.
DisplayName	Mail
IsValidForForm	True
IsValidForRead	True
LogicalName	mail
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

MobilePhone

Property	Value
Description	The primary cellular telephone number for the user.
DisplayName	Mobile Phone
IsValidForForm	True
IsValidForRead	True
LogicalName	mobilephone
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OfficeLocation

Property	Value
Description	The office location in the user's place of business.
DisplayName	Office Location
IsValidForForm	True
IsValidForRead	True
LogicalName	officelocation
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

PostalCode

Property	Value
Description	Postal Code.
DisplayName	Postal Code
IsValidForForm	True
IsValidForRead	True
LogicalName	postalcode
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

PreferredLanguage

Property	Value
Description	The preferred language for the user. Should follow ISO 639-1 Code; for example 'en-US'.
DisplayName	Preferred Language
IsValidForForm	True
IsValidForRead	True
LogicalName	preferredlanguage
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

StreetAddress

Property	Value
Description	Street Address.
DisplayName	Street Address
IsValidForForm	True
IsValidForRead	True
LogicalName	streetaddress
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

surname

Property	Value
Description	The user's surname (family name or last name).
DisplayName	Surname
IsValidForForm	True
IsValidForRead	True
LogicalName	surname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

UserPrincipalName

Property	Value
Description	The user principal name (UPN) of the user.
DisplayName	User Principal Name
IsValidForForm	True
IsValidForRead	True
LogicalName	userprincipalname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

UserType

Property	Value
Description	User Type.
DisplayName	User Type
IsValidForForm	True
IsValidForRead	True
LogicalName	usertype
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

CreatedDateTime

Property	Value
Description	Date and time when the Microsoft Entra ID was created.
DisplayName	Created Date Time
IsValidForForm	True
IsValidForRead	True
LogicalName	createddatetime
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

See also

Dataverse table/entity reference
Dataverse Web API Reference
aaduser