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
- IsTrigger
- OperationId
- OperationKind
- OperationType
- ParameterName
- ParameterValue
- ParentProcessStageId
- PrimaryEntityTypeCode
- ProcessId
- ProcessStageId
- StageCategory
- StageName
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
- OwnerId
- OwnerIdType
- OwningBusinessUnit
- ParentProcessStageIdName
- ProcessIdName
- VersionNumber
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
- 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_parentprocessstage
- processstage_adx_portalcomment
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 | |
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