Process (Workflow) table/entity reference

Note

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

Set of logical rules that define the steps necessary to automate a specific business process, task, or set of actions to be performed.

Messages

Message Web API Operation SDK Assembly
Assign PATCH [org URI]/api/data/v9.0/workflows(workflowid)
Update ownerid property.
AssignRequest
Create POST [org URI]/api/data/v9.0/workflows
See Create
CreateRequest or
Create
CreateWorkflowFromTemplate CreateWorkflowFromTemplate Action CreateWorkflowFromTemplateRequest
Delete DELETE [org URI]/api/data/v9.0/workflows(workflowid)
See Delete
DeleteRequest or
Delete
ExecuteWorkflow ExecuteWorkflow Action ExecuteWorkflowRequest
GrantAccess GrantAccess Action GrantAccessRequest
InitializeModernFlowFromAsyncWorkflow InitializeModernFlowFromAsyncWorkflowRequest
install install Action Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message.
ModifyAccess ModifyAccess Action ModifyAccessRequest
Retrieve GET [org URI]/api/data/v9.0/workflows(workflowid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/workflows
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess Function RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess Function RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess Action RevokeAccessRequest
RunDesktopFlow RunDesktopFlow Action Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message.
SetState PATCH [org URI]/api/data/v9.0/workflows(workflowid)
Update statecode and statuscode properties.
SetStateRequest
Update PATCH [org URI]/api/data/v9.0/workflows(workflowid)
See Update
UpdateRequest or
Update

Properties

Property Value
CollectionSchemaName Workflows
DisplayCollectionName Processes
DisplayName Process
EntitySetName workflows
IsBPFEntity False
LogicalCollectionName workflows
LogicalName workflow
OwnershipType UserOwned
PrimaryIdAttribute workflowid
PrimaryNameAttribute name
SchemaName Workflow

Writable columns/attributes

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

AsyncAutoDelete

Property Value
Description Indicates whether the asynchronous system job is automatically deleted on completion.
DisplayName Delete Job On Completion
IsValidForForm False
IsValidForRead True
LogicalName asyncautodelete
RequiredLevel SystemRequired
Type Boolean

AsyncAutoDelete Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

BusinessProcessType

Property Value
Description Business Process Type.
DisplayName Business Process Type
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName businessprocesstype
RequiredLevel None
Type Picklist

BusinessProcessType Choices/Options

Value Label Description
0 Business Flow
1 Task Flow

Category

Property Value
Description Category of the process.
DisplayName Category
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName category
RequiredLevel SystemRequired
Type Picklist

Category Choices/Options

Value Label Description
0 Workflow
1 Dialog
2 Business Rule
3 Action
4 Business Process Flow
5 Modern Flow
6 Desktop Flow

ClientData

Property Value
Description Business logic converted into client data
DisplayName Client Data
Format TextArea
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName clientdata
MaxLength 1073741823
RequiredLevel None
Type Memo

CreateStage

Property Value
Description Stage of the process when triggered on Create.
DisplayName Create Stage
IsValidForForm False
IsValidForRead True
LogicalName createstage
RequiredLevel None
Type Picklist

CreateStage Choices/Options

Value Label Description
20 Pre-operation
40 Post-operation

DeleteStage

Property Value
Description Stage of the process when triggered on Delete.
DisplayName Delete stage
IsValidForForm False
IsValidForRead True
LogicalName deletestage
RequiredLevel None
Type Picklist

DeleteStage Choices/Options

Value Label Description
20 Pre-operation
40 Post-operation

Description

Property Value
Description Description of the process.
DisplayName Description
Format TextArea
IsLocalizable True
IsValidForForm True
IsValidForRead True
LogicalName description
MaxLength 100000
RequiredLevel None
Type Memo

EntityImage

Property Value
Description Shows the default image for the record.
DisplayName Default Image
IsPrimaryImage True
IsValidForForm False
IsValidForRead True
LogicalName entityimage
MaxHeight 144
MaxWidth 144
RequiredLevel None
Type Image

FormId

Property Value
Description Unique identifier of the associated form.
DisplayName Form ID
IsValidForForm False
IsValidForRead True
LogicalName formid
RequiredLevel None
Type Uniqueidentifier

InputParameters

Property Value
Description Input parameters to the process.
DisplayName Input Parameters
Format TextArea
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName inputparameters
MaxLength 1073741823
RequiredLevel None
Type Memo

IntroducedVersion

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

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

IsCustomProcessingStepAllowedForOtherPublishers

Added by: MessageProcessorExtension Solution

Property Value
Description Defines whether other publishers can attach custom processing steps to this action
DisplayName Allow custom processing step for other publishers
IsValidForForm True
IsValidForRead True
LogicalName iscustomprocessingstepallowedforotherpublishers
RequiredLevel SystemRequired
Type ManagedProperty

IsTransacted

Property Value
Description Whether or not the steps in the process are executed in a single transaction.
DisplayName Is Transacted
IsValidForForm True
IsValidForRead True
LogicalName istransacted
RequiredLevel None
Type Boolean

IsTransacted Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 1

LanguageCode

Property Value
Description Language of the process.
DisplayName Language
Format Language
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName languagecode
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

Mode

Property Value
Description Shows the mode of the process.
DisplayName Mode
IsValidForForm True
IsValidForRead True
LogicalName mode
RequiredLevel SystemRequired
Type Picklist

Mode Choices/Options

Value Label Description
0 Background
1 Real-time

Name

Property Value
Description Name of the process.
DisplayName Process Name
FormatName Text
IsLocalizable True
IsValidForForm True
IsValidForRead True
LogicalName name
MaxLength 100
RequiredLevel SystemRequired
Type String

OnDemand

Property Value
Description Indicates whether the process is able to run as an on-demand process.
DisplayName Run as On Demand
IsValidForForm False
IsValidForRead True
LogicalName ondemand
RequiredLevel None
Type Boolean

OnDemand Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

OwnerId

Property Value
Description Unique identifier of the user or team who owns the process.
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

PrimaryEntity

Property Value
Description Primary entity for the process. The process can be associated for one or more SDK operations defined on the primary entity.
DisplayName Primary Entity
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName primaryentity
RequiredLevel SystemRequired
Type EntityName

ProcessOrder

Property Value
Description Type the business process flow order.
DisplayName Process Order
Format None
IsValidForForm False
IsValidForRead True
LogicalName processorder
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

ProcessRoleAssignment

Property Value
Description Contains the role assignment for the process.
DisplayName Role assignment for Process
Format Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName processroleassignment
MaxLength 1048576
RequiredLevel None
Type Memo

ProcessTriggerFormId

Property Value
Description Unique identifier of the associated form for process trigger.
DisplayName ProcessTriggerFormId
IsValidForForm False
IsValidForRead True
LogicalName processtriggerformid
RequiredLevel None
Type Uniqueidentifier

ProcessTriggerScope

Property Value
Description Scope of the process trigger.
DisplayName ProcessTriggerScope
IsValidForForm False
IsValidForRead True
LogicalName processtriggerscope
RequiredLevel None
Type Picklist

ProcessTriggerScope Choices/Options

Value Label Description
1 Form
2 Entity

Rank

Property Value
Description Indicates the rank for order of execution for the synchronous workflow.
DisplayName Rank
Format None
IsValidForForm False
IsValidForRead True
LogicalName rank
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

RendererObjectTypeCode

Property Value
Description The renderer type of Workflow
DisplayName Renderer Type
IsValidForForm False
IsValidForRead True
LogicalName rendererobjecttypecode
RequiredLevel None
Type EntityName

RunAs

Property Value
Description Specifies the system user account under which a workflow executes.
DisplayName Run As User
IsValidForForm False
IsValidForRead True
LogicalName runas
RequiredLevel None
Type Picklist

RunAs Choices/Options

Value Label Description
0 Owner
1 Calling User

Scope

Property Value
Description Scope of the process.
DisplayName Scope
IsValidForForm False
IsValidForRead True
LogicalName scope
RequiredLevel SystemRequired
Type Picklist

Scope Choices/Options

Value Label Description
1 User
2 Business Unit
3 Parent: Child Business Units
4 Organization

StateCode

Property Value
Description Status of the workflow
DisplayName Status
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

StateCode Choices/Options

Value Label DefaultStatus InvariantName
0 Draft 1 Draft
1 Activated 2 Activated
2 Suspended 3 Suspended

StatusCode

Property Value
Description Reason for the status of the workflow
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status

StatusCode Choices/Options

Value Label State
1 Draft 0
2 Activated 1
3 CompanyDLPViolation 2

Subprocess

Property Value
Description Indicates whether the process can be included in other processes as a child process.
DisplayName Is Child Process
IsValidForForm False
IsValidForRead True
LogicalName subprocess
RequiredLevel None
Type Boolean

Subprocess Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

SyncWorkflowLogOnFailure

Property Value
Description Select whether synchronous workflow failures will be saved to log files.
DisplayName Log upon Failure
IsValidForForm False
IsValidForRead True
LogicalName syncworkflowlogonfailure
RequiredLevel SystemRequired
Type Boolean

SyncWorkflowLogOnFailure Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

TriggerOnCreate

Property Value
Description Indicates whether the process will be triggered when the primary entity is created.
DisplayName Trigger On Create
IsValidForForm False
IsValidForRead True
LogicalName triggeroncreate
RequiredLevel None
Type Boolean

TriggerOnCreate Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

TriggerOnDelete

Property Value
Description Indicates whether the process will be triggered on deletion of the primary entity.
DisplayName Trigger On Delete
IsValidForForm False
IsValidForRead True
LogicalName triggerondelete
RequiredLevel None
Type Boolean

TriggerOnDelete Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

TriggerOnUpdateAttributeList

Property Value
Description Attributes that trigger the process when updated.
DisplayName Trigger On Update Attribute List
Format TextArea
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName triggeronupdateattributelist
MaxLength 1073741823
RequiredLevel None
Type Memo

Type

Property Value
Description Type of the process.
DisplayName Type
IsValidForForm False
IsValidForRead True
LogicalName type
RequiredLevel SystemRequired
Type Picklist

Type Choices/Options

Value Label Description
1 Definition
2 Activation
3 Template

UIFlowType

Property Value
Description Type of the UI Flow process.
DisplayName Desktop Flow Type
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName uiflowtype
RequiredLevel None
Type Picklist

UIFlowType Choices/Options

Value Label Description
0 Windows recorder (V1)
1 Selenium IDE
2 Power Automate Desktop
101 Recording

UniqueName

Property Value
Description Unique name of the process
DisplayName Unique Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName uniquename
MaxLength 256
RequiredLevel None
Type String

UpdateStage

Property Value
Description Select the stage a process will be triggered on update.
DisplayName Update Stage
IsValidForForm False
IsValidForRead True
LogicalName updatestage
RequiredLevel None
Type Picklist

UpdateStage Choices/Options

Value Label Description
20 Pre-operation
40 Post-operation

WorkflowId

Property Value
Description Unique identifier of the process.
DisplayName Process
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName workflowid
RequiredLevel SystemRequired
Type Uniqueidentifier

Xaml

Property Value
Description XAML that defines the process.
DisplayName
Format TextArea
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName xaml
MaxLength 1073741823
RequiredLevel ApplicationRequired
Type Memo

Read-only columns/attributes

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

ActiveWorkflowId

Property Value
Description Unique identifier of the latest activation record for the process.
DisplayName Active Process ID
IsValidForForm True
IsValidForRead True
LogicalName activeworkflowid
RequiredLevel None
Targets workflow
Type Lookup

ActiveWorkflowIdName

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

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

CreatedBy

Property Value
Description Unique identifier of the user who created the process.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedByName

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

CreatedByYomiName

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

CreatedOn

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

CreatedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who created the process.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

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

CreatedOnBehalfByYomiName

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

EntityImage_Timestamp

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

EntityImage_URL

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

EntityImageId

Property Value
Description For internal use only.
DisplayName Entity Image Id
IsValidForForm False
IsValidForRead True
LogicalName entityimageid
RequiredLevel None
Type Uniqueidentifier

IsCrmUIWorkflow

Property Value
Description Indicates whether the process was created using the Microsoft Dynamics 365 Web application.
DisplayName Is CRM Process
IsValidForForm False
IsValidForRead True
LogicalName iscrmuiworkflow
RequiredLevel None
Type Boolean

IsCrmUIWorkflow Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

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

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the process.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByName

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

ModifiedByYomiName

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

ModifiedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the process was last modified.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who last modified the process.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

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

ModifiedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
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

OwnerIdYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
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

ParentWorkflowId

Property Value
Description Unique identifier of the definition for process activation.
DisplayName Parent Process ID
IsValidForForm True
IsValidForRead True
LogicalName parentworkflowid
RequiredLevel None
Targets workflow
Type Lookup

ParentWorkflowIdName

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

PluginTypeId

Property Value
Description Unique identifier of the plug-in type.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName plugintypeid
RequiredLevel None
Targets sdkmessagefilter
Type Lookup

SdkMessageId

Property Value
Description Unique identifier of the SDK Message associated with this workflow.
DisplayName SDK Message
IsValidForForm True
IsValidForRead True
LogicalName sdkmessageid
RequiredLevel None
Targets sdkmessage
Type Lookup

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

TrustedAccess

Added by: Power Automate Extensions Workflow Customization package Solution

Property Value
Description For Internal Use Only.
DisplayName Trusted Access
IsValidForForm True
IsValidForRead True
LogicalName trustedaccess
RequiredLevel None
Type Boolean

TrustedAccess Choices/Options

Value Label Description
1 Workflow has gone through access check
0 Workflow has not gone through access check

DefaultValue: 0

UIData

Property Value
Description For internal use only.
DisplayName UI Data
Format TextArea
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName uidata
MaxLength 1073741823
RequiredLevel None
Type Memo

VersionNumber

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

WorkflowIdUnique

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

One-To-Many Relationships

Listed by SchemaName.

Workflow_Annotation

Same as the Workflow_Annotation many-to-one relationship for the annotation table/entity.

Property Value
ReferencingEntity annotation
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Workflow_Annotation
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

process_processstage

Same as the process_processstage many-to-one relationship for the processstage table/entity.

Property Value
ReferencingEntity processstage
ReferencingAttribute processid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName process_processstage
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: Cascade
Unshare: Cascade

lk_asyncoperation_workflowactivationid

Same as the lk_asyncoperation_workflowactivationid many-to-one relationship for the asyncoperation table/entity.

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute workflowactivationid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName lk_asyncoperation_workflowactivationid
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

process_processtrigger

Same as the process_processtrigger many-to-one relationship for the processtrigger table/entity.

Property Value
ReferencingEntity processtrigger
ReferencingAttribute processid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName process_processtrigger
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_expiredprocess_processid

Same as the lk_expiredprocess_processid many-to-one relationship for the expiredprocess table/entity.

Property Value
ReferencingEntity expiredprocess
ReferencingAttribute processid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName workflow_expiredprocess
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

workflow_parent_workflow

Same as the workflow_parent_workflow many-to-one relationship for the workflow table/entity.

Property Value
ReferencingEntity workflow
ReferencingAttribute parentworkflowid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName workflow_parent_workflow
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

slaitembase_workflowid

Same as the slaitembase_workflowid many-to-one relationship for the slaitem table/entity.

Property Value
ReferencingEntity slaitem
ReferencingAttribute workflowid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName slaitembase_workflowid
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

slabase_workflowid

Same as the slabase_workflowid many-to-one relationship for the sla table/entity.

Property Value
ReferencingEntity sla
ReferencingAttribute workflowid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName slabase_workflowid
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_processsession_processid

Same as the lk_processsession_processid many-to-one relationship for the processsession table/entity.

Property Value
ReferencingEntity processsession
ReferencingAttribute processid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName lk_processsession_processid
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_translationprocess_processid

Same as the lk_translationprocess_processid many-to-one relationship for the translationprocess table/entity.

Property Value
ReferencingEntity translationprocess
ReferencingAttribute processid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName workflow_translationprocess
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_newprocess_processid

Same as the lk_newprocess_processid many-to-one relationship for the newprocess table/entity.

Property Value
ReferencingEntity newprocess
ReferencingAttribute processid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName workflow_newprocess
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Workflow_SyncErrors

Same as the Workflow_SyncErrors many-to-one relationship for the syncerror table/entity.

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Workflow_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

workflow_active_workflow

Same as the workflow_active_workflow many-to-one relationship for the workflow table/entity.

Property Value
ReferencingEntity workflow
ReferencingAttribute activeworkflowid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName workflow_active_workflow
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

catalogassignment_workflow

Added by: CatalogFramework Solution

Same as the catalogassignment_workflow many-to-one relationship for the catalogassignment table/entity.

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

regardingobjectid_process

Added by: Power Automate Extensions core package Solution

Same as the regardingobjectid_process many-to-one relationship for the flowsession table/entity.

Property Value
ReferencingEntity flowsession
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName regardingobjectid_process
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

workflow_workflowbinary_Process

Added by: Power Automate Extensions core package Solution

Same as the workflow_workflowbinary_Process many-to-one relationship for the workflowbinary table/entity.

Property Value
ReferencingEntity workflowbinary
ReferencingAttribute process
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName workflow_workflowbinary_Process
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_retrainworkflow_msdyn_toaimodel

Added by: AISolution Solution

Same as the msdyn_retrainworkflow_msdyn_toaimodel many-to-one relationship for the msdyn_aimodel table/entity.

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

msdyn_scheduleinferenceworkflow_msdyn_toaimodel

Added by: AISolution Solution

Same as the msdyn_scheduleinferenceworkflow_msdyn_toaimodel many-to-one relationship for the msdyn_aimodel table/entity.

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

msdyn_workflow_slaitem_customtimecalculationworkflowid

Added by: Service Level Agreement (SLA) Extension Solution

Same as the msdyn_workflow_slaitem_customtimecalculationworkflowid many-to-one relationship for the slaitem table/entity.

Property Value
ReferencingEntity slaitem
ReferencingAttribute msdyn_customtimecalculationworkflowid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_workflow_slaitem_customtimecalculationworkflowid
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_workflow_msdyn_pmrecording

Added by: Process Mining Solution

Same as the msdyn_workflow_msdyn_pmrecording many-to-one relationship for the msdyn_pmrecording table/entity.

Property Value
ReferencingEntity msdyn_pmrecording
ReferencingAttribute msdyn_sourceworkflow
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName msdyn_workflow_msdyn_pmrecording
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_workflow_msdyn_solutionhealthrule_Workflow

Added by: Power Apps Checker Solution

Same as the msdyn_workflow_msdyn_solutionhealthrule_Workflow many-to-one relationship for the msdyn_solutionhealthrule table/entity.

Property Value
ReferencingEntity msdyn_solutionhealthrule
ReferencingAttribute msdyn_workflow
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName msdyn_workflow_msdyn_solutionhealthrule_Workflow
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_workflow_msdyn_solutionhealthrule_resolutionaction

Added by: Power Apps Checker Solution

Same as the msdyn_workflow_msdyn_solutionhealthrule_resolutionaction many-to-one relationship for the msdyn_solutionhealthrule table/entity.

Property Value
ReferencingEntity msdyn_solutionhealthrule
ReferencingAttribute msdyn_resolutionaction
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName msdyn_workflow_msdyn_solutionhealthrule_resolutionaction
AssociatedMenuConfiguration Behavior: DoNotDisplay
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.

workflow_active_workflow

See the workflow_active_workflow one-to-many relationship for the workflow table/entity.

workflow_modifiedby

See the workflow_modifiedby one-to-many relationship for the systemuser table/entity.

workflow_createdonbehalfby

See the workflow_createdonbehalfby one-to-many relationship for the systemuser table/entity.

business_unit_workflow

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

system_user_workflow

See the system_user_workflow one-to-many relationship for the systemuser table/entity.

team_workflow

See the team_workflow one-to-many relationship for the team table/entity.

workflow_createdby

See the workflow_createdby one-to-many relationship for the systemuser table/entity.

workflow_parent_workflow

See the workflow_parent_workflow one-to-many relationship for the workflow table/entity.

workflow_modifiedonbehalfby

See the workflow_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.

Many-To-Many Relationships

Relationship details provided where the Workflow table is the first table in the relationship. Listed by SchemaName.

botcomponent_workflow

See the botcomponent_workflow many-to-many relationship for the botcomponent table/entity.

See also

About the table reference
Web API Reference
workflow EntityType