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 |
| 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
- IsTrigger
- OperationId
- OperationKind
- OperationType
- PrimaryEntityTypeCode
- ProcessId
- ProcessStageId
- StageCategory
- StageName
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 | Description |
|---|---|---|
| 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 | 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 |
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 | 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 |
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 |
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
- processstage_contact
- processstage_teams
- ProcessStage_SyncErrors
- processstage_recurringappointmentmasters
- processstage_letters
- processstage_faxes
- processstage_tasks
- processstage_account
- lk_translationprocess_activestageid
- processstage_systemusers
- lk_newprocess_activestageid
- processstage_emails
- processstage_appointments
- processstage_phonecalls
- lk_expiredprocess_activestageid
- processstage_processstageparameter
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 | |
| 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