Canvas App (CanvasApp) table/entity reference (Microsoft Dataverse)

2025-08-28

An application built through a canvas-based editing experience.

Messages

The following table lists the messages for the Canvas App (CanvasApp) 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
`Assign` Event: False	`PATCH` /canvasapps(canvasappid) Update the `ownerid` property.	AssignRequest
`Associate` Event: True	Associate records	Associate records
`Create` Event: False	`POST` /canvasapps See Create	Create records
`Delete` Event: False	`DELETE` /canvasapps(canvasappid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`GrantAccess` Event: False	GrantAccess	GrantAccessRequest
`Retrieve` Event: False	`GET` /canvasapps(canvasappid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: False	`GET` /canvasapps See Query data	Query data
`RetrievePrincipalAccess` Event: True	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
`RetrieveSharedPrincipalsAndAccess` Event: True	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
`RevokeAccess` Event: False	RevokeAccess	RevokeAccessRequest
`Update` Event: False	`PATCH` /canvasapps(canvasappid) See Update	Update records
`Upsert` Event: False	`PATCH` /canvasapps(canvasappid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Canvas App (CanvasApp) table.

Property	Value
DisplayName	Canvas App
DisplayCollectionName	Canvas Apps
SchemaName	`CanvasApp`
CollectionSchemaName	`Canvas Apps`
EntitySetName	`canvasapps`
LogicalName	`canvasapp`
LogicalCollectionName	`canvasapps`
PrimaryIdAttribute	`canvasappid`
PrimaryNameAttribute	`name`
TableType	`Standard`
OwnershipType	`UserOwned`

Writable columns/attributes

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

AADCreatedById
AADLastModifiedById
AADLastPublishedById
AdminControlBypassConsent
AppComponentDependencies
AppComponents
AppOpenUri
AppVersion
AuthorizationReferences
BackgroundColor
BypassConsent
CanConsumeAppPass
CanvasAppId
CanvasAppType
CdsDependencies
CommitMessage
ConnectionReferences
CreatedByClientVersion
CreatedTime
DatabaseReferences
Description
DisplayName
EmbeddedApp
GalleryItemId
IntroducedVersion
IsCdsUpgraded
IsCustomizable
IsFeaturedApp
IsHeroApp
IsHidden
LastModifiedTime
LastPublishTime
MinClientVersion
Name
OwnerId
OwnerIdType
Publisher
Status
Tags
UniqueCanvasAppId

AADCreatedById

Property	Value
Description	Unique identifier of the user who created the canvas app.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	`aadcreatedbyid`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

AADLastModifiedById

Property	Value
Description	Unique identifier of the user who last modified the application.
DisplayName	Last Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	`aadlastmodifiedbyid`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

AADLastPublishedById

Property	Value
Description	Unique identifier of the user who last published the application.
DisplayName	Last Published By
IsValidForForm	True
IsValidForRead	True
LogicalName	`aadlastpublishedbyid`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

AdminControlBypassConsent

Property	Value
Description	Indicates whether the canvas app was marked for bypass consent by an admin.
DisplayName	Admin Control Bypass Consent
IsValidForForm	False
IsValidForRead	True
LogicalName	`admincontrolbypassconsent`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`canvasapp_admincontrolbypassconsent`
DefaultValue	False
True Label	True
False Label	False

AppComponentDependencies

Property	Value
Description	The app component dependencies.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`appcomponentdependencies`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	768000

AppComponents

Property	Value
Description	The app components.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`appcomponents`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	768000

AppOpenUri

Property	Value
Description	The app open URI.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`appopenuri`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

AppVersion

Property	Value
Description	The application version.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`appversion`
RequiredLevel	SystemRequired
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

AuthorizationReferences

Property	Value
Description	The authorization references of the application.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`authorizationreferences`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

BackgroundColor

Property	Value
Description	The background image color.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`backgroundcolor`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

BypassConsent

Property	Value
Description	Indicates whether the canvas app should bypass consent from consumers.
DisplayName	Bypass Consent
IsValidForForm	False
IsValidForRead	True
LogicalName	`bypassconsent`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`canvasapp_bypassconsent`
DefaultValue	False
True Label	True
False Label	False

CanConsumeAppPass

Property	Value
Description	The type of the canvas app.
DisplayName	Can Consume App Pass
IsValidForForm	False
IsValidForRead	True
LogicalName	`canconsumeapppass`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`canvasapp_canconsumeapppass`
DefaultValue	False
True Label	True
False Label	False

CanvasAppId

Property	Value
Description	For internal use only.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`canvasappid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

CanvasAppType

Property	Value
Description	The type of the canvas app.
DisplayName	Canvas App Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`canvasapptype`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`canvasapp_canvasapptype`

CanvasAppType Choices/Options

Value	Label
0	Classic Canvas App
1	App Component Library
2	Custom Canvas Page
3	Unified App
4	Code App

CdsDependencies

Property	Value
Description	Internal use. The app dependency details.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`cdsdependencies`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	768000

CommitMessage

Property	Value
Description	The commit message of the app.
DisplayName	The commit message.
IsValidForForm	False
IsValidForRead	True
LogicalName	`commitmessage`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

ConnectionReferences

Property	Value
Description	The connection references of the application.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`connectionreferences`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	768000

CreatedByClientVersion

Property	Value
Description	The version of the client that was used to author the application.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdbyclientversion`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

CreatedTime

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

DatabaseReferences

Property	Value
Description	The database references of the application.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`databasereferences`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	768000

Description

Property	Value
Description	The description of the app.
DisplayName	The description.
IsValidForForm	False
IsValidForRead	True
LogicalName	`description`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

DisplayName

Property	Value
Description	The display name of the app.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`displayname`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

EmbeddedApp

Property	Value
Description	Internal use. The embedded app information.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`embeddedapp`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

GalleryItemId

Property	Value
Description	The gallery item identifier.
DisplayName	The gallery item identifier
IsValidForForm	False
IsValidForRead	True
LogicalName	`galleryitemid`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

IntroducedVersion

Property	Value
Description	Version in which the canvas app is introduced.
DisplayName	Introduced Version
IsValidForForm	False
IsValidForRead	True
LogicalName	`introducedversion`
RequiredLevel	None
Type	String
Format	VersionNumber
FormatName	VersionNumber
ImeMode	Auto
IsLocalizable	False
MaxLength	48

IsCdsUpgraded

Property	Value
Description	Indicates whether the canvas app contains CDS 1.0 references.
DisplayName	Is CDS Upgraded
IsValidForForm	False
IsValidForRead	True
LogicalName	`iscdsupgraded`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`canvasapp_iscdsupgraded`
DefaultValue	False
True Label	True
False Label	False

IsCustomizable

Property	Value
Description	Information that specifies whether this component can be customized.
DisplayName	Customizable
IsValidForForm	False
IsValidForRead	True
LogicalName	`iscustomizable`
RequiredLevel	SystemRequired
Type	ManagedProperty

IsFeaturedApp

Property	Value
Description	Indicates whether the canvas app is a featured app.
DisplayName	Is Featured App
IsValidForForm	False
IsValidForRead	True
LogicalName	`isfeaturedapp`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`canvasapp_isfeatured`
DefaultValue	False
True Label	True
False Label	False

IsHeroApp

Property	Value
Description	Indicates whether the canvas app is a hero app.
DisplayName	Is Hero App
IsValidForForm	False
IsValidForRead	True
LogicalName	`isheroapp`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`canvasapp_isheroapp`
DefaultValue	False
True Label	True
False Label	False

IsHidden

Property	Value
Description	Indicates whether the canvas app is hidden from a user's list.
DisplayName	Is Hidden
IsValidForForm	False
IsValidForRead	True
LogicalName	`ishidden`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`canvasapp_ishidden`
DefaultValue	False
True Label	True
False Label	False

LastModifiedTime

Property	Value
Description	Date and time when the application was last modified.
DisplayName	Last Modified Time
IsValidForForm	True
IsValidForRead	True
LogicalName	`lastmodifiedtime`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

LastPublishTime

Property	Value
Description	Date and time when the application was last published.
DisplayName	Last Publish Time
IsValidForForm	True
IsValidForRead	True
LogicalName	`lastpublishtime`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

MinClientVersion

Property	Value
Description	The version of the client that was used to author the application.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`minclientversion`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Name

Property	Value
Description	Name of the CanvasApp
DisplayName	CanvasApp Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`name`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwnerId

Property	Value
Description	Unique identifier of the user or team who owns the canvas app.
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	`ownerid`
RequiredLevel	SystemRequired
Type	Owner
Targets	systemuser

OwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridtype`
RequiredLevel	SystemRequired
Type	EntityName

Publisher

Property	Value
Description	The publisher of the app.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`publisher`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

Status

Property	Value
Description	A value indicating whether the application is ready for consumption.
DisplayName	Status
IsValidForForm	False
IsValidForRead	True
LogicalName	`status`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

Property	Value
Description	The metadata tags of the application.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`tags`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

UniqueCanvasAppId

Property	Value
Description	The globally unique canvas app id
DisplayName	Unique CanvasApp Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`uniquecanvasappid`
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.

Assets
Assets_Name
BackgroundImage
BackgroundImage_Name
CanvasAppRowId
ComponentState
Document
Document_Name
IsManaged
LargeIcon
LargeIcon_Name
MediumIcon
MediumIcon_Name
OverwriteTime
OwnerIdName
OwningBusinessUnit
OwningTeam
OwningUser
SmallIcon
SmallIcon_Name
SolutionId
SupportingSolutionId
TeamsIcon
TeamsIcon_Name
VersionNumber
WideIcon
WideIcon_Name

Assets

Property	Value
Description	Assets for Canvas Apps.
DisplayName	Assets
IsValidForForm	True
IsValidForRead	True
LogicalName	`assets`
RequiredLevel	None
Type	File
MaxSizeInKB	32768

Assets_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`assets_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

BackgroundImage

Property	Value
Description	Background image for Canvas Apps.
DisplayName	Background Image
IsValidForForm	True
IsValidForRead	True
LogicalName	`background_image`
RequiredLevel	None
Type	File
MaxSizeInKB	32768

BackgroundImage_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`backgroundimage_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

CanvasAppRowId

Property	Value
Description	For internal use only.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`canvasapprowid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ComponentState

Property	Value
Description	For internal use only.
DisplayName	Component State
IsValidForForm	False
IsValidForRead	True
LogicalName	`componentstate`
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`componentstate`

ComponentState Choices/Options

Value	Label
0	Published
1	Unpublished
2	Deleted
3	Deleted Unpublished

Document

Property	Value
Description	Document for Canvas Apps.
DisplayName	Document
IsValidForForm	True
IsValidForRead	True
LogicalName	`document`
RequiredLevel	None
Type	File
MaxSizeInKB	32768

Document_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`document_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

IsManaged

Property	Value
Description	Indicates whether the solution component is part of a managed solution.
DisplayName	Is Managed
IsValidForForm	False
IsValidForRead	True
LogicalName	`ismanaged`
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	`ismanaged`
DefaultValue	False
True Label	Managed
False Label	Unmanaged

LargeIcon

Property	Value
Description	Large icon for Canvas Apps.
DisplayName	Large Icon
IsValidForForm	True
IsValidForRead	True
LogicalName	`large_icon`
RequiredLevel	None
Type	File
MaxSizeInKB	32768

LargeIcon_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`largeicon_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

MediumIcon

Property	Value
Description	Medium icon for Canvas Apps.
DisplayName	Medium Icon
IsValidForForm	True
IsValidForRead	True
LogicalName	`medium_icon`
RequiredLevel	None
Type	File
MaxSizeInKB	32768

MediumIcon_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`mediumicon_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

OverwriteTime

Property	Value
Description	For internal use only.
DisplayName	Record Overwrite Time
IsValidForForm	False
IsValidForRead	True
LogicalName	`overwritetime`
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

OwnerIdName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridname`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwningBusinessUnit

Property	Value
Description	Unique identifier of the business unit that owns the process.
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	`owningbusinessunit`
RequiredLevel	None
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description	Unique identifier of the team who owns the process.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	`owningteam`
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

Property	Value
Description	Unique identifier of the user who owns the process.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	`owninguser`
RequiredLevel	None
Type	Lookup
Targets	systemuser

SmallIcon

Property	Value
Description	Small icon for Canvas Apps.
DisplayName	Small Icon
IsValidForForm	True
IsValidForRead	True
LogicalName	`small_icon`
RequiredLevel	None
Type	File
MaxSizeInKB	32768

SmallIcon_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`smallicon_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

SolutionId

Property	Value
Description	Unique identifier of the associated solution.
DisplayName	Solution
IsValidForForm	False
IsValidForRead	True
LogicalName	`solutionid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

SupportingSolutionId

Property	Value
Description	For internal use only.
DisplayName	Solution
IsValidForForm	False
IsValidForRead	False
LogicalName	`supportingsolutionid`
RequiredLevel	None
Type	Uniqueidentifier

TeamsIcon

Property	Value
Description	Teams icon for Canvas Apps.
DisplayName	Teams Icon
IsValidForForm	True
IsValidForRead	True
LogicalName	`teams_icon`
RequiredLevel	None
Type	File
MaxSizeInKB	32768

TeamsIcon_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`teamsicon_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

VersionNumber

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`versionnumber`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

WideIcon

Property	Value
Description	Wide icon for Canvas Apps.
DisplayName	Wide Icon
IsValidForForm	True
IsValidForRead	True
LogicalName	`wide_icon`
RequiredLevel	None
Type	File
MaxSizeInKB	32768

WideIcon_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`wideicon_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

Many-to-One relationships

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

businessunit_canvasapp
FileAttachment_CanvasApp_Assets
FileAttachment_CanvasApp_BackgroundImage
FileAttachment_CanvasApp_Document
FileAttachment_CanvasApp_LargeIcon
FileAttachment_CanvasApp_MediumIcon
FileAttachment_CanvasApp_SmallIcon
FileAttachment_CanvasApp_TeamsIcon
FileAttachment_CanvasApp_WideIcon
FK_CanvasApp_Solution
owner_canvasapp

businessunit_canvasapp

One-To-Many Relationship: businessunit businessunit_canvasapp

Property	Value
ReferencedEntity	`businessunit`
ReferencedAttribute	`businessunitid`
ReferencingAttribute	`owningbusinessunit`
ReferencingEntityNavigationPropertyName	`owningbusinessunit`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

FileAttachment_CanvasApp_Assets

One-To-Many Relationship: fileattachment FileAttachment_CanvasApp_Assets

Property	Value
ReferencedEntity	`fileattachment`
ReferencedAttribute	`fileattachmentid`
ReferencingAttribute	`assets`
ReferencingEntityNavigationPropertyName	`assets`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

FileAttachment_CanvasApp_BackgroundImage

One-To-Many Relationship: fileattachment FileAttachment_CanvasApp_BackgroundImage

Property	Value
ReferencedEntity	`fileattachment`
ReferencedAttribute	`fileattachmentid`
ReferencingAttribute	`background_image`
ReferencingEntityNavigationPropertyName	`backgroundimage`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

FileAttachment_CanvasApp_Document

One-To-Many Relationship: fileattachment FileAttachment_CanvasApp_Document

Property	Value
ReferencedEntity	`fileattachment`
ReferencedAttribute	`fileattachmentid`
ReferencingAttribute	`document`
ReferencingEntityNavigationPropertyName	`document`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

FileAttachment_CanvasApp_LargeIcon

One-To-Many Relationship: fileattachment FileAttachment_CanvasApp_LargeIcon

Property	Value
ReferencedEntity	`fileattachment`
ReferencedAttribute	`fileattachmentid`
ReferencingAttribute	`large_icon`
ReferencingEntityNavigationPropertyName	`largeicon`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

FileAttachment_CanvasApp_MediumIcon

One-To-Many Relationship: fileattachment FileAttachment_CanvasApp_MediumIcon

Property	Value
ReferencedEntity	`fileattachment`
ReferencedAttribute	`fileattachmentid`
ReferencingAttribute	`medium_icon`
ReferencingEntityNavigationPropertyName	`mediumicon`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

FileAttachment_CanvasApp_SmallIcon

One-To-Many Relationship: fileattachment FileAttachment_CanvasApp_SmallIcon

Property	Value
ReferencedEntity	`fileattachment`
ReferencedAttribute	`fileattachmentid`
ReferencingAttribute	`small_icon`
ReferencingEntityNavigationPropertyName	`smallicon`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

FileAttachment_CanvasApp_TeamsIcon

One-To-Many Relationship: fileattachment FileAttachment_CanvasApp_TeamsIcon

Property	Value
ReferencedEntity	`fileattachment`
ReferencedAttribute	`fileattachmentid`
ReferencingAttribute	`teams_icon`
ReferencingEntityNavigationPropertyName	`teamsicon`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

FileAttachment_CanvasApp_WideIcon

One-To-Many Relationship: fileattachment FileAttachment_CanvasApp_WideIcon

Property	Value
ReferencedEntity	`fileattachment`
ReferencedAttribute	`fileattachmentid`
ReferencingAttribute	`wide_icon`
ReferencingEntityNavigationPropertyName	`wideicon`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

FK_CanvasApp_Solution

One-To-Many Relationship: solution FK_CanvasApp_Solution

Property	Value
ReferencedEntity	`solution`
ReferencedAttribute	`solutionid`
ReferencingAttribute	`solutionid`
ReferencingEntityNavigationPropertyName	`FK_CanvasApp_Solution`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

owner_canvasapp

One-To-Many Relationship: owner owner_canvasapp

Property	Value
ReferencedEntity	`owner`
ReferencedAttribute	`ownerid`
ReferencingAttribute	`ownerid`
ReferencingEntityNavigationPropertyName	`ownerid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

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

canvasapp_appaction_onclickeventformulacomponentlibraryid
canvasapp_appaction_visibilityformulacomponentlibraryid
canvasapp_FileAttachments
canvasapp_msdyn_mobileapp_msdyn_primaryPublishedAppName

canvasapp_appaction_onclickeventformulacomponentlibraryid

Many-To-One Relationship: appaction canvasapp_appaction_onclickeventformulacomponentlibraryid

Property	Value
ReferencingEntity	`appaction`
ReferencingAttribute	`onclickeventformulacomponentlibraryid`
ReferencedEntityNavigationPropertyName	`canvasapp_appaction_onclickeventformulacomponentlibraryid`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

canvasapp_appaction_visibilityformulacomponentlibraryid

Many-To-One Relationship: appaction canvasapp_appaction_visibilityformulacomponentlibraryid

Property	Value
ReferencingEntity	`appaction`
ReferencingAttribute	`visibilityformulacomponentlibraryid`
ReferencedEntityNavigationPropertyName	`canvasapp_appaction_visibilityformulacomponentlibraryid`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

canvasapp_FileAttachments

Many-To-One Relationship: fileattachment canvasapp_FileAttachments

Property	Value
ReferencingEntity	`fileattachment`
ReferencingAttribute	`objectid`
ReferencedEntityNavigationPropertyName	`canvasapp_FileAttachments`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

canvasapp_msdyn_mobileapp_msdyn_primaryPublishedAppName

Many-To-One Relationship: msdyn_mobileapp canvasapp_msdyn_mobileapp_msdyn_primaryPublishedAppName

Property	Value
ReferencingEntity	`msdyn_mobileapp`
ReferencingAttribute	`msdyn_primarypublishedappname`
ReferencedEntityNavigationPropertyName	`canvasapp_msdyn_mobileapp_msdyn_primaryPublishedAppName`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?