ProcessStage table/entity reference

Note

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

Stage associated with a process.

Messages

Message Web API Operation SDK class or method
Create POST /processstages
See Create
CreateRequest or
Create
Delete DELETE /processstages(processstageid)
See Delete
DeleteRequest or
Delete
Retrieve GET /processstages(processstageid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveActivePath RetrieveActivePath RetrieveActivePathRequest
RetrieveMultiple GET /processstages
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple

Properties

Property Value
CollectionSchemaName ProcessStages
DisplayCollectionName Process Stages
DisplayName Process Stage
EntitySetName processstages
IsBPFEntity False
LogicalCollectionName processstages
LogicalName processstage
OwnershipType None
PrimaryIdAttribute processstageid
PrimaryNameAttribute stagename
SchemaName ProcessStage

Writable columns/attributes

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

Connector

Added by: Power Automate Core Components Solution

Property Value
Description The connector associated with the stage.
DisplayName Connector
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName connector
MaxLength 100
RequiredLevel None
Type String

IsTrigger

Added by: Power Automate Core Components Solution

Property Value
Description Whether the stage is a trigger
DisplayName Is Trigger
IsValidForForm True
IsValidForRead True
LogicalName istrigger
RequiredLevel None
Type Boolean

IsTrigger Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

OperationId

Added by: Power Automate Core Components Solution

Property Value
Description The operation id of the stage
DisplayName Operation Id
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName operationid
MaxLength 100
RequiredLevel None
Type String

OperationKind

Added by: Power Automate Core Components Solution

Property Value
Description The operation kind
DisplayName Operation Kind
IsValidForForm True
IsValidForRead True
LogicalName operationkind
RequiredLevel None
Type Picklist

OperationKind Choices/Options

Value Label Description
473330000 Http
473330001 PowerApp
473330002 PowerAppV2
473330003 Button
473330004 ApiConnection
473330005 Alert
473330006 EventGrid
473330007 CurrentTime
473330008 ConvertTimeZone
473330009 GetFutureTime
473330010 GetPastTime
473330011 AddToTime
473330012 SubtractFromTime
473330013 AzureMonitorAlert
473330014 SecurityCenterAlert
473330015 JsonToJson
473330016 JsonToText
473330017 XmlToJson
473330018 XmlToText
473330019 Geofence
473330020 ODataOpenApiConnection
473330021 IndexOf
473330022 Substring
473330023 VirtualAgent
473330024 FormatNumber
473330025 Skills

OperationType

Added by: Power Automate Core Components Solution

Property Value
Description The type of the operation
DisplayName Operation Type
IsValidForForm True
IsValidForRead True
LogicalName operationtype
RequiredLevel None
Type Picklist

OperationType Choices/Options

Value Label Description
473330000 Http
473330001 ApiApp
473330002 Recurrence
473330003 Workflow
473330004 Flow
473330005 Wait
473330006 ApiConnection
473330007 OpenApiConnection
473330008 Manual
473330009 ApiConnectionWebhook
473330010 OpenApiConnectionWebhook
473330011 Response
473330012 HttpWebhook
473330013 Compose
473330014 Query
473330015 Function
473330016 ApiManagement
473330017 XmlValidation
473330018 FlatFileEncoding
473330019 Scope
473330020 Request
473330021 If
473330022 Foreach
473330023 Until
473330024 Xslt
473330025 FlatFileDecoding
473330026 Terminate
473330027 IntegrationAccountArtifactLookup
473330028 Switch
473330029 ParseJson
473330030 Table
473330031 Join
473330032 Select
473330033 InitializeVariable
473330034 IncrementVariable
473330035 DecrementVariable
473330036 SetVariable
473330037 AppendToArrayVariable
473330038 AppendToStringVariable
473330039 Batch
473330040 SendToBatch
473330041 SlidingWindow
473330042 Expression
473330043 Liquid
473330044 JavascriptCode
473330045 As2Decode
473330046 As2Encode
473330047 RosettaNetEncode
473330048 RosettaNetDecode
473330049 RosettaNetWaitForResponse
473330050 ApiConnectionNotification
473330051 Changeset
473330052 SwiftEncode

ParameterName

Added by: Power Automate Core Components Solution

Property Value
Description The parameter name.
DisplayName Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName parametername
MaxLength 100
RequiredLevel ApplicationRequired
Type String

ParameterValue

Added by: Power Automate Core Components Solution

Property Value
Description The parameter value.
DisplayName Value
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName parametervalue
MaxLength 2000
RequiredLevel None
Type String

ParentProcessStageId

Added by: Power Automate Core Components Solution

Property Value
Description The parent stage for the parameter.
DisplayName Stage
IsValidForForm True
IsValidForRead True
LogicalName parentprocessstageid
RequiredLevel ApplicationRequired
Targets processstage
Type Lookup

PrimaryEntityTypeCode

Property Value
Description Primary entity associated with the stage.
DisplayName Primary Entity
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName primaryentitytypecode
RequiredLevel SystemRequired
Type EntityName

ProcessId

Property Value
Description Shows the ID of the process.
DisplayName Process
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName processid
RequiredLevel SystemRequired
Targets workflow
Type Lookup

ProcessStageId

Property Value
Description Shows the ID of the process stage record.
DisplayName Process Stage
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName processstageid
RequiredLevel SystemRequired
Type Uniqueidentifier

StageCategory

Property Value
Description Select the category of the sales process.
DisplayName Stage Category
IsValidForForm True
IsValidForRead True
LogicalName stagecategory
RequiredLevel None
Type Picklist

StageCategory Choices/Options

Value Label Description
0 Qualify
1 Develop
2 Propose
3 Close
4 Identify
5 Research
6 Resolve
7 Approval

StageName

Property Value
Description Type a name for the process stage.
DisplayName Process Stage Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName stagename
MaxLength 100
RequiredLevel SystemRequired
Type String

Read-only columns/attributes

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

ClientData

Property Value
Description Step metadata for process stage
DisplayName Client Data
Format TextArea
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName clientdata
MaxLength 1073741823
RequiredLevel None
Type Memo

OwnerId

Property Value
Description Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user.
DisplayName Owner
IsValidForForm False
IsValidForRead True
LogicalName ownerid
RequiredLevel ApplicationRequired
Targets systemuser,team
Type Owner

OwnerIdType

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

OwningBusinessUnit

Property Value
Description Select the business unit that owns the record.
DisplayName Owning Business Unit
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel ApplicationRequired
Type Uniqueidentifier

ParentProcessStageIdName

Added by: Power Automate Core Components Solution

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

ProcessIdName

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

VersionNumber

Property Value
Description Version number of the process stage.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

One-To-Many Relationships

Listed by SchemaName.

processstage_knowledgearticle

Same as the processstage_knowledgearticle many-to-one relationship for the knowledgearticle table/entity.

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

processstage_contact

Same as the processstage_contact many-to-one relationship for the contact table/entity.

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

processstage_teams

Same as the processstage_teams many-to-one relationship for the team table/entity.

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

ProcessStage_SyncErrors

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

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

processstage_recurringappointmentmasters

Same as the processstage_recurringappointmentmasters many-to-one relationship for the recurringappointmentmaster table/entity.

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

processstage_letters

Same as the processstage_letters many-to-one relationship for the letter table/entity.

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

processstage_faxes

Same as the processstage_faxes many-to-one relationship for the fax table/entity.

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

processstage_tasks

Same as the processstage_tasks many-to-one relationship for the task table/entity.

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

processstage_account

Same as the processstage_account many-to-one relationship for the account table/entity.

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

lk_translationprocess_activestageid

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

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

processstage_systemusers

Same as the processstage_systemusers many-to-one relationship for the systemuser table/entity.

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

lk_newprocess_activestageid

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

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

processstage_emails

Same as the processstage_emails many-to-one relationship for the email table/entity.

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

processstage_appointments

Same as the processstage_appointments many-to-one relationship for the appointment table/entity.

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

processstage_phonecalls

Same as the processstage_phonecalls many-to-one relationship for the phonecall table/entity.

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

lk_expiredprocess_activestageid

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

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

processstage_processstageparameter

Added by: Power Automate Core Components Solution

Same as the processstage_processstageparameter many-to-one relationship for the processstageparameter table/entity.

Property Value
ReferencingEntity processstageparameter
ReferencingAttribute processstageid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName processstage_processstageparameter
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

processstage_parentprocessstage

Added by: Power Automate Core Components Solution

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

Property Value
ReferencingEntity processstage
ReferencingAttribute parentprocessstageid
IsHierarchical True
IsCustomizable False
ReferencedEntityNavigationPropertyName processstage_parentprocessstage
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

processstage_adx_portalcomment

Added by: Active Solution Solution

Same as the processstage_adx_portalcomment many-to-one relationship for the adx_portalcomment table/entity.

Property Value
ReferencingEntity adx_portalcomment
ReferencingAttribute stageid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName processstage_adx_portalcomment
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
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.

process_processstage

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

processstage_parentprocessstage

See the processstage_parentprocessstage one-to-many relationship for the processstage table/entity.

See also

Dataverse table/entity reference
Web API Reference
processstage EntityType