CanvasApp table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

An application built through a canvas-based editing experience.

Messages

Message Web API Operation SDK class or method
Assign PATCH /canvasapps(canvasappid)
Update ownerid property.
AssignRequest
Create POST /canvasapps
See Create
CreateRequest or
Create
Delete DELETE /canvasapps(canvasappid)
See Delete
DeleteRequest or
Delete
GrantAccess GrantAccess GrantAccessRequest
Retrieve GET /canvasapps(canvasappid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET /canvasapps
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess RevokeAccessRequest
Update PATCH /canvasapps(canvasappid)
See Update
UpdateRequest or
Update

Properties

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

Writable columns/attributes

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

AADCreatedById

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

AADLastModifiedById

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

AADLastPublishedById

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

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

AdminControlBypassConsent Choices/Options

Value Label Description
1 True
0 False

DefaultValue: 0

AppComponentDependencies

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

AppComponents

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

AppOpenUri

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

AppVersion

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

AuthorizationReferences

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

BackgroundColor

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

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

BypassConsent Choices/Options

Value Label Description
1 True
0 False

DefaultValue: 0

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

CanConsumeAppPass Choices/Options

Value Label Description
1 True
0 False

DefaultValue: 0

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

CanvasAppType Choices/Options

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

CdsDependencies

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

CommitMessage

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

ConnectionReferences

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

CreatedByClientVersion

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

CreatedTime

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

DatabaseReferences

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

Description

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

DisplayName

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

EmbeddedApp

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

GalleryItemId

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

IntroducedVersion

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

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

IsCdsUpgraded Choices/Options

Value Label Description
1 True
0 False

DefaultValue: 0

IsCustomizable

Added by: Canvas App Metadata Extension Solution

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

IsFeaturedApp Choices/Options

Value Label Description
1 True
0 False

DefaultValue: 0

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

IsHeroApp Choices/Options

Value Label Description
1 True
0 False

DefaultValue: 0

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

IsHidden Choices/Options

Value Label Description
1 True
0 False

DefaultValue: 0

LastModifiedTime

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

LastPublishTime

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

MinClientVersion

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

Name

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

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
Targets systemuser
Type Owner

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
Format Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName publisher
MaxLength 2000
RequiredLevel None
Type Memo

Status

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

Tags

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

UniqueCanvasAppId

Added by: Canvas App Metadata Extension Solution

Property Value
Description The globally unique canvas app id
DisplayName Unique CanvasApp Id
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName uniquecanvasappid
MaxLength 100
RequiredLevel None
Type String

Read-only columns/attributes

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

Assets

Added by: Canvas App Metadata Extension Solution

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

Assets_Name

Added by: Canvas App Metadata Extension Solution

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

BackgroundImage

Added by: Canvas App Metadata Extension Solution

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

BackgroundImage_Name

Added by: Canvas App Metadata Extension Solution

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

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

ComponentState Choices/Options

Value Label Description
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished

Document

Added by: Canvas App Metadata Extension Solution

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

Document_Name

Added by: Canvas App Metadata Extension Solution

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

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

IsManaged Choices/Options

Value Label Description
1 Managed
0 Unmanaged

DefaultValue: 0

LargeIcon

Added by: Canvas App Metadata Extension Solution

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

LargeIcon_Name

Added by: Canvas App Metadata Extension Solution

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

MediumIcon

Added by: Canvas App Metadata Extension Solution

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

MediumIcon_Name

Added by: Canvas App Metadata Extension Solution

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

OverwriteTime

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

OwnerIdName

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

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
Targets businessunit
Type Lookup

OwningBusinessUnitName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunitname
MaxLength 100
RequiredLevel None
Type String

OwningTeam

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

OwningUser

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

SmallIcon

Added by: Canvas App Metadata Extension Solution

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

SmallIcon_Name

Added by: Canvas App Metadata Extension Solution

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

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

Added by: Canvas App Metadata Extension Solution

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

TeamsIcon_Name

Added by: Canvas App Metadata Extension Solution

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

VersionNumber

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

WideIcon

Added by: Canvas App Metadata Extension Solution

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

WideIcon_Name

Added by: Canvas App Metadata Extension Solution

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

One-To-Many Relationships

Listed by SchemaName.

canvasapp_msdyn_mobileapp_msdyn_primaryPublishedAppName

Added by: Mobile Apps Solution Solution

Same as the canvasapp_msdyn_mobileapp_msdyn_primaryPublishedAppName many-to-one relationship for the msdyn_mobileapp table/entity.

Property Value
ReferencingEntity msdyn_mobileapp
ReferencingAttribute msdyn_primarypublishedappname
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName canvasapp_msdyn_mobileapp_msdyn_primaryPublishedAppName
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

canvasapp_appaction_onclickeventformulacomponentlibraryid

Added by: Power Apps Actions Solution

Same as the canvasapp_appaction_onclickeventformulacomponentlibraryid many-to-one relationship for the appaction table/entity.

Property Value
ReferencingEntity appaction
ReferencingAttribute onclickeventformulacomponentlibraryid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName canvasapp_appaction_onclickeventformulacomponentlibraryid
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

canvasapp_appaction_visibilityformulacomponentlibraryid

Added by: Power Apps Actions Solution

Same as the canvasapp_appaction_visibilityformulacomponentlibraryid many-to-one relationship for the appaction table/entity.

Property Value
ReferencingEntity appaction
ReferencingAttribute visibilityformulacomponentlibraryid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName canvasapp_appaction_visibilityformulacomponentlibraryid
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

businessunit_canvasapp

See the businessunit_canvasapp one-to-many relationship for the businessunit table/entity.

FK_CanvasApp_Solution

See the FK_CanvasApp_Solution one-to-many relationship for the solution table/entity.

See also

Dataverse table/entity reference
Web API Reference
canvasapp EntityType