Study guide

14.3 Exporting, Importing, Upgrading & Patches

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

14.3 Exporting, Importing, Upgrading & Patches

Key Takeaways Explain This Topic AI

Solution Export produces a packaged ZIP containing solution.xml, customizations.xml, and assets, generated either as an Unmanaged package (for source control commit) or Managed package (for deployment).

Solution Segmentation allows consultants to include only modified subcomponents (specific columns, views, or forms) rather than entire table metadata, drastically reducing deployment merge conflicts.

Solution Import operations provide three modes: Update (in-place modification, non-destructive), Stage for Upgrade (creates temporary holding layer allowing zero-downtime validation before upgrade), and Upgrade (replaces solution and deletes removed components).

Applying a Solution Upgrade is the only import mechanism that cleanly deletes obsolete columns, components, and flows that were removed from the source solution.

Solution Patches provide lightweight, incremental delta packages (version major.minor.patch.build, e.g., 1.0.1.0) linked to a parent solution, which can later be rolled up into a unified base via 'Clone Solution'.

Last updated: August 2026

Exporting, Importing, Upgrading & Patches

Deploying changes smoothly between development, testing, and production environments without causing business interruption or leaving obsolete schema behind is the cornerstone of enterprise Application Lifecycle Management. Microsoft Dataverse provides robust mechanisms for packaging, segmenting, upgrading, and patching solutions. On the PL-200 exam, you must understand how solution export packages are constructed, how to use Solution Segmentation , the exact behavior of Update vs. Stage for Upgrade vs. Upgrade , and how to maintain live systems using Solution Patches and Solution Cloning .

1. Solution Export & Packaging Mechanics

When a solution is exported from Dataverse, the platform bundles its metadata into a compressed ZIP file containing standardized XML and resource files: +-----------------------------------------------------------------------------+

  • | SOLUTION ZIP PACKAGE STRUCTURE |
  • | |
  • | solution.zip |
  • | |-- solution.xml (Solution manifest, publisher, version, deps) |
  • | |-- customizations.xml (Schema, entities, forms, views, site maps) |
  • | |-- [Content_Types].xml (MIME types for package content) |
  • | |-- CanvasApps/ (Extracted .msapp binaries and Power Fx code) |
  • | |-- Workflows/ (Cloud flow and workflow JSON definitions) |
  • | `-- WebResources/ (JavaScript, PNG, SVG, CSS script files) |
  • +-----------------------------------------------------------------------------+
  • Export Configurations

Export as Unmanaged: Generates an unmanaged ZIP package. Used when transferring work between sandbox environments or unpacking components with the Power Platform CLI ( pac solution unpack ) to commit raw XML and code files into a Git source repository.

Export as Managed: Compiles and generates a managed ZIP package. Used for releasing validated builds to Test, QA, and Production environments.

Export Settings: Prior to export, makers can configure system settings to be bundled with the solution, including General settings, Sales settings, Email tracking, and Auto-numbering prefixes.

2. Solution Segmentation vs. Full Inclusion

In early versions of Dynamics CRM, adding a table to a solution automatically included the entire table definition—every column, form, view, chart, and relationship. When multiple teams deployed solutions, they constantly overwrote each other's form layouts and metadata.

Solution Segmentation allows consultants to include only the specific subcomponents that were created or modified: +-----------------------------------------------------------------------------------+

  • | SOLUTION SEGMENTATION ARCHITECTURE |
  • | |
  • | [UNSEGMENTED APPROACH (Anti-Pattern)] [SEGMENTED APPROACH (Best Practice)]|
  • | +-----------------------------------+ +-----------------------------------+|
  • | | Table: 'Account' | | Table: 'Account' ||
  • | | - Include all components: [YES] | | - Include all components: [NO] ||
  • | | - Include entity metadata: [YES] | | - Include entity metadata: [NO] ||
  • | | | | ||
  • | | Includes: | | Selected Subcomponents ONLY: ||
  • | | * All 150+ columns | | * Column: contoso_accounttier ||
  • | | * All 12 Main Forms | | * Form: Account Custom Main Form ||
  • | | * All 25 System Views | | ||
  • | | | | (Leaves all other forms, views, ||
  • | | (Overwrites changes made by other | | and columns completely untouched)|||
  • | | teams on Account forms!) | +-----------------------------------+|
  • | +-----------------------------------+ |
  • +-----------------------------------------------------------------------------------+
  • Rules for Solution Segmentation

Uncheck 'Include all components': When adding an existing table (e.g., Account, Contact), never check Include all components unless you intend to own and overwrite the entire table architecture.

Uncheck 'Include entity metadata': Prevents overriding global table properties (such as Auditing, Notes, Activities, or Offline sync settings) in downstream environments.

Select Specific Assets: Add only the newly created columns, the specific modified form, or the single system view required for the feature.

3. Solution Import Modes: Update vs. Stage for Upgrade vs. Upgrade

When deploying a new version of a managed solution into a target environment, the import engine provides three operational modes: +-----------------------------------------------------------------------------------+

  • | SOLUTION IMPORT MODES COMPARISON |
  • | |
  • | [1. UPDATE (In-Place)] |
  • | - Installs changes immediately into the existing solution layer. |
  • | - Overwrites modified components. |
  • | *** DOES NOT DELETE OBSOLETE COMPONENTS REMOVED FROM SOURCE SOLUTION! *** |
  • | |
  • | [2. STAGE FOR UPGRADE (Holding Layer)] |
  • | - Imports new solution as a temporary holding layer: '[SolutionName]_Upgrade' |
  • | - Existing solution remains active and unchanged during import. |
  • | - Allows automated health checks and verification before committing. |
  • | - Transition completed via: 'Apply Solution Upgrade' |
  • | |
  • | [3. UPGRADE (Direct / Applied)] |
  • | - Replaces the existing solution layer with the new version. |
  • | - Merges all intermediate patches into a single unified layer. |
  • | *** AUTOMATICALLY DELETES COMPONENTS DELETED FROM THE SOURCE SOLUTION! *** |
  • +-----------------------------------------------------------------------------------+
  • Detailed Breakdown of Import Modes
  • 1. Update (In-Place Update)

How it Works: Updates existing components and adds newly created components directly into the current solution layer.

Component Deletion: Non-destructive. If you deleted a column, form, or cloud flow from the solution in Development, importing with Update will NOT delete that obsolete component from the target environment. The deprecated component remains orphaned in the target environment.

Use Case: Small, additive updates where no components were removed.

2. Stage for Upgrade

How it Works: Imports the solution as a separate, temporary holding layer named [SolutionName]_Upgrade . The original base solution remains live and uninterrupted.

Zero-Downtime Validation: Administrators and CI/CD pipelines can validate the health of the deployment while the holding layer is staged.

Completion: The upgrade is finalized by selecting Apply Solution Upgrade (either manually in the UI or via the Apply-AdminPowerAppSolutionUpgrade pipeline command).

3. Upgrade (Direct Upgrade / Apply Solution Upgrade)

How it Works: The new solution version fully replaces the old solution. Dataverse performs a comprehensive delta reconciliation.

Component Deletion: Deletes all components that were removed from the source solution. If a deprecated column or flow was removed from the source development package, Dataverse cleanly purges it from the target environment.

Patch Consolidation: Consolidates all previously installed patches into the new base solution layer.

  • Feature / Behavior Update Stage for Upgrade Upgrade (Apply Upgrade)
  • Deletes Obsolete Components? No (Leaves orphaned assets) No (Held in staging) Yes (Purges deleted components)
  • Creates Holding Solution? No Yes ( _Upgrade suffix) Replaces holding solution
  • Consolidates Patches? No No Yes (Rolls up all patches)
  • Downtime / Risk Profile Low (Immediate, partial) Lowest (Allows pre-commit checks) Comprehensive cleanup

Important

How to Delete Deprecated Components in ALM: If an enterprise requirement states that obsolete columns, deprecated forms, or decommissioned flows must be removed from Production during deployment, you MUST use the Upgrade (or Stage for Upgrade followed by Apply Solution Upgrade) method . An Update will never delete components.

4. Solution Patches & Solution Cloning

In agile enterprise environments, deploying a massive 200MB solution containing hundreds of components for a single two-line bug fix is inefficient and risky. Dataverse provides Solution Patches to deliver lightweight, targeted incremental updates. +-----------------------------------------------------------------------------------+

  • | SOLUTION PATCHING & CLONING LIFECYCLE |
  • | |
  • | [BASE SOLUTION v1.0.0.0] |
  • | - Contains Core Tables, Forms, Flows (Base Layer) |
  • | - Locked while patches are active |
  • | |
  • | +---> [PATCH 1: v1.0.1.0] (Bug fix on Invoice Form) |
  • | | - Exports in seconds (Contains ONLY Invoice Form) |
  • | | |
  • | +---> [PATCH 2: v1.0.2.0] (New Hotfix Column on Account) |
  • | - Exports in seconds (Contains ONLY new Column) |
  • | |
  • | | |
  • | v (Execute 'Clone Solution' in Dev) |
  • | |
  • | [UNIFIED BASE SOLUTION v2.0.0.0 (Cloned & Rolled Up)] |
  • | - Merges Base Solution + Patch 1 + Patch 2 into a single clean base package |
  • | - Increments Major/Minor version digit |
  • | - Ready for fresh Managed 'Upgrade' deployment to Production |
  • +-----------------------------------------------------------------------------------+
  • Solution Patch Rules & Lifecycle

Version Numbering Convention:

Dataverse solutions follow standard versioning: Major . Minor . Build . Revision (e.g., 1.0.0.0 ).

When creating a patch, only the Build or Revision digits can increment (e.g., 1.0.1.0 or 1.0.0.1 ). Major and Minor digits cannot change.

Patch Content: A patch contains only the specific components or subcomponents that were added or modified (the delta). It depends strictly on its parent base solution.

Parent Solution Locking: While an active patch exists in the development environment, the parent base solution is locked and cannot be edited directly. All new customizations must be added to the patch.

Downstream Deployment: Patches are exported as Managed packages and imported into target environments where they layer directly on top of the parent managed solution.

Cloning a Solution (Patch Rollup)

Over time, managing 10 separate patches creates operational overhead. When preparing for a major release:

In the development environment, select the parent solution and click Clone Solution .

Dataverse rolls up the base solution and all active patches into a single, unified new solution package.

The consultant specifies a new Major or Minor version number (e.g., 2.0.0.0 or 1.1.0.0 ).

All previous patch containers are automatically deleted in development.

When this new base solution is deployed to Production as an Upgrade , Dataverse replaces the old base solution, deletes the obsolete patches, and establishes a single consolidated managed layer.