Microsoft Entra ID (aaduser) table/entity reference

  • Article

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

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