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 Assembly
Create POST [org URI]/api/data/v9.0/processstages
See Create
CreateRequest or
Create
Delete DELETE [org URI]/api/data/v9.0/processstages(processstageid)
See Delete
DeleteRequest or
Delete
Retrieve GET [org URI]/api/data/v9.0/processstages(processstageid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveActivePath RetrieveActivePath Function RetrieveActivePathRequest
RetrieveEntityChanges RetrieveEntityChangesRequest
RetrieveMultiple GET [org URI]/api/data/v9.0/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 Extensions core package 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 Extensions core package 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
1 Yes
0 No

DefaultValue: False

OperationId

Added by: Power Automate Extensions core package 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 Extensions core package 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
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

OperationType

Added by: Power Automate Extensions core package 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
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

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
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

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 knowledgearticle table processstage_knowledgearticle Many-To-One relationship.

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 contact table processstage_contact Many-To-One relationship.

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 team table processstage_teams Many-To-One relationship.

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 syncerror table ProcessStage_SyncErrors Many-To-One relationship.

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 recurringappointmentmaster table processstage_recurringappointmentmasters Many-To-One relationship.

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 letter table processstage_letters Many-To-One relationship.

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 fax table processstage_faxes Many-To-One relationship.

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 task table processstage_tasks Many-To-One relationship.

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 account table processstage_account Many-To-One relationship.

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 translationprocess table lk_translationprocess_activestageid Many-To-One relationship.

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 systemuser table processstage_systemusers Many-To-One relationship.

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 newprocess table lk_newprocess_activestageid Many-To-One relationship.

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 email table processstage_emails Many-To-One relationship.

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 appointment table processstage_appointments Many-To-One relationship.

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 phonecall table processstage_phonecalls Many-To-One relationship.

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 expiredprocess table lk_expiredprocess_activestageid Many-To-One relationship.

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 Extensions core package Solution

Same as processstageparameter table processstage_processstageparameter Many-To-One relationship.

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

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 workflow Table process_processstage One-To-Many relationship.

See also

About the table reference
Web API Reference
processstage EntityType