Study guide
12.1 Classic Dataverse Workflows: Real-Time vs. Background (Async)
Microsoft Power Platform Functional Consultant PL-200
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Dataverse Tables, Relationships & Core Columns
1.1 Dataverse Table Types, Properties & Ownership 1.2 Table Relationships & Cascading Rules 1.3 Column Types, Formats, Primary Keys & Alternate Keys 1.4 Rollup, Calculated & Formula Columns with Power Fx
2 Chapter 2: Dataverse Data Management & Governance
2.1 Dataverse Search, Quick Find & Relevance Indexing 2.2 Auditing Configuration & Log Management 2.3 Duplicate Detection Rules & Settings 2.4 Bulk Record Operations, Data Import, Export & Templates
3 Chapter 3: Dataverse Security Model & Access Control
3.1 Business Units, Ownership Models & Modern BU Matrix 3.2 Security Roles, Privileges & Depth Levels 3.3 Teams Architecture: Owner, Access, and Microsoft Entra (AAD) Group Teams 3.4 Column-Level Security & Hierarchy Security Models
4 Chapter 4: Model-Driven App Fundamentals & Information Architecture
4.1 Model-Driven App Design, Site Map Navigation & Modern App Designer 4.2 Form Types: Main, Quick Create, Quick View & Card Forms 4.3 View Configuration, System Views, Personal Views & Filters
5 Chapter 5: Advanced Model-Driven App Components & Custom Pages
5.1 Custom Pages & Modern Commanding with Power Fx 5.2 Form Component Controls & Specialized UX Elements 5.3 Embedding Canvas Apps in Model-Driven Forms 5.4 Embedding Power BI Reports, Dashboards & Tiles
6 Chapter 6: Canvas Apps Structure, Formulas & Data Operations
6.1 Canvas App Architecture, Screens, Containers & Controls 6.2 Power Fx Formulas, Delegation & Data Source Limits 6.3 Variables (Context, Global), Collections & State Management 6.4 Triggering Power Automate Cloud Flows from Canvas Apps
7 Chapter 7: Power Pages Site Design, Navigation & Content
7.1 Power Pages Design Studio & Site Structure 7.2 Power Pages Templates, Styling & Responsive Layouts 7.3 Web Pages, Navigation Menus & Content Snippets
8 Chapter 8: Power Pages Data Integration, Forms & Web Roles
8.1 Power Pages Lists, Basic Forms & Advanced Forms 8.2 Table Permissions, Web Roles & Page Access Security 8.3 External Identity Providers & Authentication Configuration
9 Chapter 9: Power Automate Cloud Flow Fundamentals & Triggers
9.1 Cloud Flow Types: Automated, Instant, Scheduled & Desktop Overview 9.2 Dataverse Connector Triggers & Operational Filters 9.3 Standard Connectors, Custom Connectors & Connection References
10 Chapter 10: Cloud Flow Actions, Expressions & Logic Controls
10.1 Logic Controls: Conditions, Switches, Apply to Each & Do Until Loops 10.2 Variables, Data Operations & Dynamic Content Manipulation 10.3 Power Automate Expression Language (WDL / Functions) 10.4 Error Handling, Configure Run After & Scope Controls
11 Chapter 11: Business Process Flows & Guided Processes
11.1 Business Process Flow Architecture, Stages, Steps & Data Steps 11.2 Branching Rules & Multi-Entity Business Process Flows 11.3 BPF Action Steps, Workflows & Cloud Flow Execution 11.4 BPF Security Roles, Order & Process Lifecycle
12 Chapter 12: Classic Workflows, Business Rules & Modern Logic Extensibility
12.1 Classic Dataverse Workflows: Real-Time vs. Background (Async) 12.2 Business Rules: Scope & Actions 12.3 Low-Code Plug-ins in Dataverse: Automated vs. Instant 12.4 Troubleshooting Automations, Run History & Analytics
13 Chapter 13: Power Platform Environment Architecture & Security
13.1 Environment Types: Default, Sandbox, Production, Trial, Developer 13.2 Environment Governance, Groups, Routing & Capacity Management 13.3 Data Loss Prevention (DLP) Policies & Connector Classifications
14 Chapter 14: Application Lifecycle Management (ALM) & Solutions
14.1 Unmanaged vs. Managed Solutions & Solution Layering Mechanics 14.2 Solution Components, Dependencies, Publishers & Prefixes 14.3 Exporting, Importing, Upgrading & Patches 14.4 Solution Checker, App Checker & ALM Best Practices
15 Chapter 15: Enterprise Interoperability & Service Integration
15.1 Exchange / Server-Side Synchronization & Email Integration 15.2 SharePoint & OneDrive Document Management Integration 15.3 Microsoft Word & Excel Document Templates
16 Chapter 16: Copilot, AI Capabilities & Exam Strategy
16.1 Copilot Studio & Generative AI across Power Platform 16.2 AI Builder Prebuilt & Custom Models in Apps and Flows 16.3 PL-200 Exam Strategy, Time Management & Question Analysis
12.1 Classic Dataverse Workflows: Real-Time vs. Background (Async)
Key Takeaways Explain This Topic AI
Classic Dataverse Workflows operate in two fundamental execution modes: Real-Time (synchronous, inside the database transaction pipeline) and Background (asynchronous, handled by the Asynchronous Processing Service).
Real-Time Workflows execute in Pre-operation (before database commit) or Post-operation stages and can synchronously cancel operations and throw custom business exceptions via 'Stop workflow with status: Canceled'.
Background (Asynchronous) Workflows execute out-of-band with automatic retry logic, minimal impact on UI responsiveness, and configurable execution delays or wait conditions.
Workflow triggers encompass record creation, status transitions, record assignment, specific field changes (with attribute filtering), and record deletion.
While Power Automate Cloud Flows are Microsoft's primary modern automation engine, Classic Real-Time Workflows remain an exam-critical tool for immediate synchronous validation, transactional rollback, and legacy system support.
Last updated: August 2026
Classic Dataverse Workflows: Real-Time vs. Background (Async)
In Microsoft Dataverse, business process automation historically relied on Classic Workflows (formerly known as Dynamics CRM Workflows). Although Microsoft Power Automate Cloud Flows have become the primary, modern orchestration engine for multi-system and event-driven automation across the Power Platform, Classic Dataverse Workflows remain a critical, deeply integrated component of the platform architecture. On the PL-200 certification exam, you must understand how classic workflows execute, their synchronous and asynchronous processing characteristics, and the precise scenarios where they continue to provide architectural advantages over cloud flows.
1. Architecture of Classic Dataverse Workflows
Classic Dataverse Workflows are built directly into the Dataverse server infrastructure and operate within the core event execution pipeline. Workflows are classified into two distinct execution modes based on how and when the Dataverse engine processes their logic: +-----------------------------------------------------------------------------------+
- | DATAVERSE WORKFLOW EXECUTION PIPELINES |
- | |
- | [CLIENT / API REQUEST] |
- | | |
- | v |
- | +-----------------------------------------------------------------------------+ |
- | | SYNCHRONOUS TRANSACTION PIPELINE | |
- | | | |
- | | [Stage 20: Pre-Operation] | |
- | | --> Real-Time Workflow (Before database write) | |
- | | * Can validate, modify payload, or cancel with custom error | |
- | | | |
- | | [Stage 30: Main Database Operation (INSERT / UPDATE / DELETE)] | |
- | | | |
- | | [Stage 40: Post-Operation] | |
- | | --> Real-Time Workflow (After database write, inside transaction) | |
- | | * Creates related records, updates fields, or rolls back | |
- | +-----------------------------------------------------------------------------+ |
- | | | |
- | (Commit Database) (Queue Async Job) |
- | | | |
- | v v |
- | [UI / CALLER RECEIVES] +-----------------------------+ |
- | [SYNCHRONOUS RESPONSE] | AsyncService QUEUE | |
- | | - Evaluates available pool | |
- | | - Retries on failure | |
- | | - Runs Background Workflow | |
- | +-----------------------------+ |
- +-----------------------------------------------------------------------------------+
- Real-Time (Synchronous) Workflows
Pipeline Integration: Real-Time Workflows run directly inside the Dataverse database transaction pipeline.
Execution Stages:
Pre-operation (Before): Executes before the primary database operation is committed. This stage allows the workflow to inspect incoming values, perform complex validation, and abort the transaction before any physical SQL write occurs.
Post-operation (After): Executes after the primary record is updated in the database but before the transaction is committed. Any database updates or child record creations initiated by the workflow in this stage participate in the identical SQL transaction.
User Experience: The user interface (or API caller) is blocked and waits until all real-time workflow logic completes. If an operation succeeds, the UI refreshes immediately with the updated values. If an error occurs, the entire transaction rolls back, and a custom error message is displayed to the user.
Execution Identity: Can execute under the security context of the Calling User (the user who initiated the change) or the Workflow Owner (elevated administrative privilege).
Background (Asynchronous) Workflows
Decoupled Processing: When a trigger condition is met, Dataverse writes a lightweight job request to the asynchronous operations queue ( asyncoperation table). The primary transaction commits immediately without waiting for the workflow.
The Asynchronous Processing Service ( AsyncService ): A dedicated background server pool periodically polls the queue, instantiates the workflow engine, and executes the configured steps out-of-band.
System Impact & Resiliency: Because execution is decoupled from the user interface, background workflows do not slow down form saves or API response times. Furthermore, if a transient system error occurs (such as a database deadlock or temporary throttling), the AsyncService automatically retries the operation multiple times with exponential backoff.
Execution Identity: Always executes under the security context of the Workflow Owner .
- Architectural Dimension Real-Time (Synchronous) Workflow Background (Asynchronous) Workflow
- Execution Engine Core Dataverse Transaction Pipeline Asynchronous Processing Service ( AsyncService )
- Timing Immediate (blocking) Queued (runs when resources permit)
- Execution Stages Pre-operation (Before) or Post-operation (After) Post-operation only (queued post-commit)
Transaction Rollback Supported (Entire transaction reverts on error) Not Supported (Main record is already committed)
- UI Impact User waits for completion; form displays errors Non-blocking; user proceeds immediately
- Security Context Calling User OR Workflow Owner Workflow Owner only
Custom Error Dialogs Supported ( Stop workflow with status: Canceled ) Not Supported (Logged to System Jobs only)
- Performance Limit 2-minute transaction timeout ceiling Can run long-running delays and wait conditions
- 2. Trigger Events, Scope, and Execution Security
Classic workflows provide granular trigger filtering to ensure that automation runs only when precise data conditions are met.
- Supported Trigger Events +-----------------------------------------------------------------------------+
- | CLASSIC WORKFLOW TRIGGER EVENTS |
- | |
- | 1. RECORD IS CREATED ---> Fires immediately upon row insertion |
- | 2. RECORD STATUS CHANGES ---> Fires when statecode/statuscode shifts |
- | 3. RECORD IS ASSIGNED ---> Fires when OwnerId changes |
- | 4. RECORD FIELDS CHANGE ---> Fires when specific attributes update |
- | 5. RECORD IS DELETED ---> Fires before or after row removal |
- | 6. AS AN ON-DEMAND PROCESS ---> Manually executed by users from grid/form|
- | 7. AS A CHILD PROCESS ---> Called explicitly by parent workflows |
- +-----------------------------------------------------------------------------+
Record is created: Executes when a new row is inserted into the table.
Record status changes: Executes when the record's state changes (e.g., Active to Inactive, Open to Won, Active to Resolved).
Record is assigned: Executes when ownership of the record transfers to another user or team.
Record fields change (Attribute Filtering): Executes when one or more designated columns are modified. Selecting specific columns is vital for performance to prevent the workflow from firing unnecessarily on unrelated field edits.
Record is deleted:
In Real-Time workflows, deletion triggers can execute Before (Pre-operation) to inspect or archive data before the row is purged, or to cancel the deletion.
In Background workflows, deletion triggers execute After the row has been removed from the database.
Workflow Scope Configuration
The Scope setting defines the organizational boundary within which a user's action will trigger the workflow:
User: The workflow executes only when the record being modified is owned by the user running the workflow.
Business Unit: The workflow executes if the record being modified is owned by any user residing within the same Business Unit as the user initiating the action.
Parent-Child Business Units: The workflow executes if the record is owned by a user in the caller's Business Unit or any of its subordinate child Business Units.
Organization: The workflow executes globally across the entire Dataverse environment, regardless of who owns the record or what Business Unit they belong to. (This is the most common setting for enterprise business logic).
Execution Identity: Calling User vs. Workflow Owner
When authoring a Real-Time workflow, the consultant must configure the Execute as setting:
The user who made changes (Calling User): The workflow executes within the security privileges of the logged-in user. If the user does not possess write privileges on a secondary table that the workflow attempts to update, the workflow fails and aborts the entire transaction.
The owner of the workflow: The workflow executes under the elevated privileges of the user who published the workflow (typically a System Administrator or Service Principal). This allows standard users to trigger workflows that create or update restricted compliance records without granting those users direct security privileges to the target table.
3. Workflow Actions and Step Catalog
The classic workflow designer provides a structured, no-code visual step builder. The available action building blocks include: +-----------------------------------------------------------------------------+
- | CLASSIC WORKFLOW ACTION CATALOG |
- | |
- | [DATA OPERATIONS] [FLOW CONTROL] [COMMUNICATION] |
- | - Create Record - Check Condition - Send Email |
- | - Update Record - Conditional Branch - Send Direct Email |
- | - Assign Record - Default Action |
- | - Change Status - Parallel Wait Branch [TERMINATION] |
- | - Start Child Workflow - Stop: Succeeded |
- | - Stop: Canceled (Error)|
- +-----------------------------------------------------------------------------+
- Detailed Action Steps
Create Record: Provisions a new row in any standard or custom table and populates its columns using static values or dynamic values from the triggering record.
Update Record: Modifies columns on the primary triggering record, or on any related record accessible via an N:1 lookup relationship (e.g., updating the parent Account from a Contact event).
Assign Record: Reassigns ownership of the primary record or a related parent record to a specified user or team.
Send Email: Generates and sends an email message using a pre-defined Email Template or dynamically constructed body text with slug values.
Change Status: Transitions the record to a specific state (e.g., Deactivating an Account, setting an Invoice to Paid).
Start Child Workflow: Calls another activated workflow marked with the property "As a child process" . This promotes modular architecture, allowing complex logic to be partitioned into reusable components.
Stop Workflow:
Status: Succeeded: Explicitly terminates the workflow run successfully.
Status: Canceled: Terminates the workflow in a faulted state. In a Real-Time Workflow, selecting Canceled prompts the designer to enter a Custom Error Message . When triggered, Dataverse immediately rolls back the database transaction and displays the custom error text directly to the user in a modal business process error dialog.
Important
Synchronous Validation & Error Display: Setting a Real-Time Workflow to execute in the Pre-operation stage with a Stop workflow with status: Canceled action is the standard declarative method in classic Dataverse to block an invalid save and surface a custom error message to the end user without code.
4. Real-Time Workflows vs. Power Automate Cloud Flows
Understanding when to build a Modern Cloud Flow versus when a Classic Real-Time Workflow is required is a core competency tested on the PL-200 exam.
- Capability / Requirement Classic Real-Time Workflow Power Automate Cloud Flow
- Execution Latency Synchronous (<100ms within pipeline) Asynchronous (typically 1-5 seconds delay)
- Database Rollback Yes (Atomic transaction rollback) No (Cannot roll back Dataverse writes)
- Block User UI on Error Yes (Displays modal error dialog) No (Executes in cloud background)
- Cross-System Connectors No (Dataverse only) Yes (1,000+ connectors: SharePoint, SQL, SAP, APIs)
- Complex Looping & Arrays No (Linear logic only) Yes (Apply to Each, Filter Array, JSON parsing)
- Modern Approval Engine No Yes (Power Automate Approvals in Teams & Outlook)
- Platform Strategic Direction Maintained for legacy/synchronous parity Primary enterprise automation investment
Tip
Exam Architecture Rule: Default to Power Automate Cloud Flows for all modern background automations, approvals, integrations, and scheduled tasks. Choose Classic Real-Time Workflows (or Low-Code Plug-ins) ONLY when the requirement demands immediate synchronous execution, atomic database rollback, or blocking form saves with custom error dialogs.