Edit

Share via

Email table/entity reference (Microsoft Dynamics 365)

  • 05/22/2025

Activity that is delivered using email protocols.

Note

The Microsoft Dynamics 365 Email table extends the Microsoft Dataverse Email table.

Messages

The following table lists the messages for the Email 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
ProcessInboundEmail
Event: False		 ProcessInboundEmail action ProcessInboundEmailRequest
PropagateByExpression
Event: False		 PropagateByExpression action PropagateByExpressionRequest

Writable columns/attributes

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

msdyn_copilotengaged

Property Value
Description
DisplayName Copilot Engaged
IsValidForForm True
IsValidForRead True
LogicalName msdyn_copilotengaged
RequiredLevel None
Type Boolean
GlobalChoiceName msdyn_email_msdyn_copilotengaged
DefaultValue False
True Label Yes
False Label No

msdyn_emailengagementinteractions

Property Value
Description Email engagement interactions
DisplayName Email engagement interactions
IsValidForForm True
IsValidForRead True
LogicalName msdyn_emailengagementinteractions
RequiredLevel None
Type Memo
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 4000

msdyn_RecipientList

Property Value
Description Individual email will be sent to each recipient.
DisplayName Recipient List
IsValidForForm True
IsValidForRead True
LogicalName msdyn_recipientlist
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 8000

msdyn_sentiment

Property Value
Description
DisplayName Sentiment
IsValidForForm True
IsValidForRead True
LogicalName msdyn_sentiment
RequiredLevel None
Type Picklist
DefaultFormValue 0
GlobalChoiceName msdyn_email_msdyn_sentiment

msdyn_sentiment Choices/Options

Value Label
0 N/A
6 Failure
7 Very negative
8 Negative
9 Slightly negative
10 Neutral
11 Slightly positive
12 Positive
13 Very positive

msdyn_sentimentreason

Property Value
Description Sentiment Reason
DisplayName Sentiment Reason
IsValidForForm True
IsValidForRead True
LogicalName msdyn_sentimentreason
RequiredLevel None
Type Picklist
DefaultFormValue -1
GlobalChoiceName msdyn_email_msdyn_sentimentreason

msdyn_sentimentreason Choices/Options

Value Label
0 Transient
1 NonTransient

ServiceId

Property Value
Description Unique identifier for the associated service.
DisplayName Service
IsValidForForm False
IsValidForRead True
LogicalName serviceid
RequiredLevel None
Type Lookup
Targets service

Customized columns/attributes

Microsoft Dynamics 365 modifies the definition of columns/attributes defined in other solutions. Listed by SchemaName.

bcc

Changes from bcc (Microsoft Dataverse)

Property Value
Targets entitlement, equipment, lead, msdyn_salessuggestion

cc

Changes from cc (Microsoft Dataverse)

Property Value
Targets entitlement, equipment, lead, msdyn_salessuggestion

EmailSender

Changes from EmailSender (Microsoft Dataverse)

Property Value
Targets equipment, lead

RegardingObjectId

Changes from RegardingObjectId (Microsoft Dataverse)

Property Value
Targets bookableresourcebooking, bookableresourcebookingheader, bulkoperation, campaign, campaignactivity, contract, entitlement, entitlementtemplate, incident, invoice, lead, msdyn_customerasset, msdyn_playbookinstance, msdyn_postalbum, msdyn_salessuggestion, msdyn_swarm, opportunity, quote, salesorder, site

Changes from related (Microsoft Dataverse)

Property Value
Targets campaign, campaignactivity, contract, entitlement, equipment, incident, invoice, lead, msdyn_salessuggestion, opportunity, quote, salesorder

to

Changes from to (Microsoft Dataverse)

Property Value
Targets entitlement, equipment, lead, msdyn_salessuggestion

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

bookableresourcebooking_Emails

One-To-Many Relationship: bookableresourcebooking bookableresourcebooking_Emails

Property Value
ReferencedEntity bookableresourcebooking
ReferencedAttribute bookableresourcebookingid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_bookableresourcebooking_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

bookableresourcebookingheader_Emails

One-To-Many Relationship: bookableresourcebookingheader bookableresourcebookingheader_Emails

Property Value
ReferencedEntity bookableresourcebookingheader
ReferencedAttribute bookableresourcebookingheaderid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_bookableresourcebookingheader_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

BulkOperation_Email

One-To-Many Relationship: bulkoperation BulkOperation_Email

Property Value
ReferencedEntity bulkoperation
ReferencedAttribute activityid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_bulkoperation_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

Campaign_Emails

One-To-Many Relationship: campaign Campaign_Emails

Property Value
ReferencedEntity campaign
ReferencedAttribute campaignid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_campaign_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

CampaignActivity_Emails

One-To-Many Relationship: campaignactivity CampaignActivity_Emails

Property Value
ReferencedEntity campaignactivity
ReferencedAttribute activityid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_campaignactivity_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

Contract_Emails

One-To-Many Relationship: contract Contract_Emails

Property Value
ReferencedEntity contract
ReferencedAttribute contractid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_contract_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

entitlement_Emails

One-To-Many Relationship: entitlement entitlement_Emails

Property Value
ReferencedEntity entitlement
ReferencedAttribute entitlementid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_entitlement_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

entitlementtemplate_Emails

One-To-Many Relationship: entitlementtemplate entitlementtemplate_Emails

Property Value
ReferencedEntity entitlementtemplate
ReferencedAttribute entitlementtemplateid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_entitlementtemplate_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

Equipment_Email_EmailSender

One-To-Many Relationship: equipment Equipment_Email_EmailSender

Property Value
ReferencedEntity equipment
ReferencedAttribute equipmentid
ReferencingAttribute emailsender
ReferencingEntityNavigationPropertyName emailsender_equipment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

Incident_Emails

One-To-Many Relationship: incident Incident_Emails

Property Value
ReferencedEntity incident
ReferencedAttribute incidentid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_incident_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

Invoice_Emails

One-To-Many Relationship: invoice Invoice_Emails

Property Value
ReferencedEntity invoice
ReferencedAttribute invoiceid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_invoice_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

Lead_Email_EmailSender

One-To-Many Relationship: lead Lead_Email_EmailSender

Property Value
ReferencedEntity lead
ReferencedAttribute leadid
ReferencingAttribute emailsender
ReferencingEntityNavigationPropertyName emailsender_lead
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

Lead_Emails

One-To-Many Relationship: lead Lead_Emails

Property Value
ReferencedEntity lead
ReferencedAttribute leadid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_lead_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

msdyn_customerasset_Emails

One-To-Many Relationship: msdyn_customerasset msdyn_customerasset_Emails

Property Value
ReferencedEntity msdyn_customerasset
ReferencedAttribute msdyn_customerassetid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_msdyn_customerasset_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

msdyn_postalbum_Emails

One-To-Many Relationship: msdyn_postalbum msdyn_postalbum_Emails

Property Value
ReferencedEntity msdyn_postalbum
ReferencedAttribute msdyn_postalbumid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_msdyn_postalbum_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

msdyn_salessuggestion_Emails

One-To-Many Relationship: msdyn_salessuggestion msdyn_salessuggestion_Emails

Property Value
ReferencedEntity msdyn_salessuggestion
ReferencedAttribute msdyn_salessuggestionid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_msdyn_salessuggestion_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

msdyn_swarm_Emails

One-To-Many Relationship: msdyn_swarm msdyn_swarm_Emails

Property Value
ReferencedEntity msdyn_swarm
ReferencedAttribute msdyn_swarmid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_msdyn_swarm_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

Opportunity_Emails

One-To-Many Relationship: opportunity Opportunity_Emails

Property Value
ReferencedEntity opportunity
ReferencedAttribute opportunityid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_opportunity_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

Quote_Emails

One-To-Many Relationship: quote Quote_Emails

Property Value
ReferencedEntity quote
ReferencedAttribute quoteid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_quote_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

SalesOrder_Emails

One-To-Many Relationship: salesorder SalesOrder_Emails

Property Value
ReferencedEntity salesorder
ReferencedAttribute salesorderid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_salesorder_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

service_emails

One-To-Many Relationship: service service_emails

Property Value
ReferencedEntity service
ReferencedAttribute serviceid
ReferencingAttribute serviceid
ReferencingEntityNavigationPropertyName serviceid_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

site_Emails

One-To-Many Relationship: site site_Emails

Property Value
ReferencedEntity site
ReferencedAttribute siteid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_site_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

email_activitymonitor

Many-To-One Relationship: activitymonitor email_activitymonitor

Property Value
ReferencingEntity activitymonitor
ReferencingAttribute monitoredactivityitemid
ReferencedEntityNavigationPropertyName email_activitymonitor
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Service
Label:
MenuId: null
Order: 10
QueryApi: CRMIncident.RollupRelatedByObject
ViewId: 00000000-0000-0000-00aa-000010003501

email_campaignresponse

Many-To-One Relationship: campaignresponse email_campaignresponse

Property Value
ReferencingEntity campaignresponse
ReferencingAttribute originatingactivityid
ReferencedEntityNavigationPropertyName email_campaignresponse
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

msdyn_email_email_msdyn_emailsentiment

Many-To-One Relationship: msdyn_emailsentiment msdyn_email_email_msdyn_emailsentiment

Property Value
ReferencingEntity msdyn_emailsentiment
ReferencingAttribute msdyn_email
ReferencedEntityNavigationPropertyName msdyn_email_email_msdyn_emailsentiment
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

msdyn_email_msdyn_autocaseclosureagentactivity_activityid

Many-To-One Relationship: msdyn_autocaseclosureagentactivity msdyn_email_msdyn_autocaseclosureagentactivity_activityid

Property Value
ReferencingEntity msdyn_autocaseclosureagentactivity
ReferencingAttribute msdyn_activityid
ReferencedEntityNavigationPropertyName msdyn_email_msdyn_autocaseclosureagentactivity_activityid
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

msdyn_email_msdyn_autocaseclosureagentactivity_autocaseclosureagentgeneratedemailid

Many-To-One Relationship: msdyn_autocaseclosureagentactivity msdyn_email_msdyn_autocaseclosureagentactivity_autocaseclosureagentgeneratedemailid

Property Value
ReferencingEntity msdyn_autocaseclosureagentactivity
ReferencingAttribute msdyn_autocaseclosureagentgeneratedemailid
ReferencedEntityNavigationPropertyName msdyn_email_msdyn_autocaseclosureagentactivity_autocaseclosureagentgeneratedemailid
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

msdyn_email_msdyn_originatingqueue_email

Many-To-One Relationship: msdyn_originatingqueue msdyn_email_msdyn_originatingqueue_email

Property Value
ReferencingEntity msdyn_originatingqueue
ReferencingAttribute msdyn_emailid
ReferencedEntityNavigationPropertyName msdyn_email_msdyn_originatingqueue_email
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

msdyn_msdyn_conversationactionitem_email_msdyn_CreatedActivity

Many-To-One Relationship: msdyn_conversationactionitem msdyn_msdyn_conversationactionitem_email_msdyn_CreatedActivity

Property Value
ReferencingEntity msdyn_conversationactionitem
ReferencingAttribute msdyn_createdactivity
ReferencedEntityNavigationPropertyName msdyn_msdyn_conversationactionitem_email_msdyn_createdactivity
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

msdyn_msdyn_salescopilotinsight_email_msdyn_activityid

Many-To-One Relationship: msdyn_salescopilotinsight msdyn_msdyn_salescopilotinsight_email_msdyn_activityid

Property Value
ReferencingEntity msdyn_salescopilotinsight
ReferencingAttribute msdyn_activityid
ReferencedEntityNavigationPropertyName msdyn_msdyn_salescopilotinsight_email_msdyn_activityid
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

msdyn_readtracker_poly_email

Many-To-One Relationship: msdyn_readtracker msdyn_readtracker_poly_email

Property Value
ReferencingEntity msdyn_readtracker
ReferencingAttribute msdyn_regardingobjectid
ReferencedEntityNavigationPropertyName msdyn_readtracker_poly_email
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
email

Additional resources

Training

Module

Use Microsoft 365 services with model-driven apps and Microsoft Dataverse - Training

Learn how to use Microsoft 365 services with Power Apps model-driven apps and Dynamics 365 customer engagement apps.

Certification

Microsoft Certified: Dynamics 365 Customer Experience Analyst Associate - Certifications

As a Microsoft Dynamics 365 customer experience analyst, you’re responsible for configuring, customizing, and expanding the functionality of Dynamics 365 Sales to create business solutions that support, automate, and accelerate the company's sales process.