CanvasApp table/entity reference
Artikel 06/04/2024
6 inzenders
Feedback
In dit artikel
An application built through a canvas-based editing experience.
Messages
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
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
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
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