CanvasApp table/entity reference
-
Article
-
- 5 minutes to read
-
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: False
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: 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 |
CanConsumeAppPass Choices/Options
| Value |
Label |
Description |
| 1 |
True |
|
| 0 |
False |
|
DefaultValue: 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 |
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: False
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: 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 |
IsHeroApp Choices/Options
| Value |
Label |
Description |
| 1 |
True |
|
| 0 |
False |
|
DefaultValue: 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 |
IsHidden Choices/Options
| Value |
Label |
Description |
| 1 |
True |
|
| 0 |
False |
|
DefaultValue: False
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 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
Assets_Name
Added by: Active Solution Solution
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
assets_name |
| MaxLength |
200 |
| RequiredLevel |
None |
| Type |
String |
BackgroundImage_Name
Added by: Active Solution 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_Name
Added by: Active Solution 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: False
LargeIcon_Name
Added by: Active Solution Solution
| Property |
Value |
| Description |
|
| DisplayName |
|
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
largeicon_name |
| MaxLength |
200 |
| RequiredLevel |
None |
| Type |
String |
MediumIcon_Name
Added by: Active Solution 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_Name
Added by: Active Solution 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_Name
Added by: Active Solution 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_Name
Added by: Active Solution 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.
Added by: Power Apps Actions Solution
Same as appaction table canvasapp_appaction_onclickeventformulacomponentlibraryid Many-To-One relationship.
| 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 appaction table canvasapp_appaction_visibilityformulacomponentlibraryid Many-To-One relationship.
| 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 businessunit Table businessunit_canvasapp One-To-Many relationship.
FK_CanvasApp_Solution
See solution Table FK_CanvasApp_Solution One-To-Many relationship.
See also
About the table reference
Web API Reference
canvasapp EntityType