Study guide
2.4 Bulk Record Operations, Data Import, Export & Templates
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
2.4 Bulk Record Operations, Data Import, Export & Templates
Key Takeaways Explain This Topic AI
Dataverse provides diverse data ingestion modalities including Modern Excel/CSV Import, legacy Data Import Wizard, Power Query Dataflows, and enterprise Azure Data Pipelines.
Import column mapping requires careful resolution of lookup fields (matching against primary name columns or alternate keys) and choice/option set fields (mapping labels to integer values).
Bulk Record Deletion jobs run asynchronously using FetchXML filter queries to purge obsolete or non-compliant records on one-time or recurring schedules, with optional completion email notifications.
Export to Excel supports four formats: Static Worksheet (snapshot), Dynamic Worksheet (live ODC query), Dynamic PivotTable (live aggregated query), and Open in Excel Online (in-browser editing with real-time sync back to Dataverse).
Export and deletion capabilities are strictly governed by security role privileges ('Export to Excel', 'Bulk Delete') and field-level security permissions.
Last updated: August 2026
Bulk Record Operations, Data Import, Export & Templates
Enterprise business applications require efficient mechanisms for importing bulk data, synchronizing with external sources, performing bulk maintenance, and exporting data for analysis. In Microsoft Dataverse, functional consultants must master the spectrum of data ingestion tools, Bulk Record Deletion system jobs, and Excel Export modalities .
1. Data Ingestion Modalities in Dataverse
Depending on data volume, transformation requirements, and technical skill, consultants select from several ingestion pathways. +-----------------------------------------------------------------------------------+
- | DATAVERSE INGESTION PATHWAYS |
- | |
- | [INGESTION SCENARIO] |
- | | |
- | +---> Ad-hoc, one-time user upload (Excel / CSV) |
- | | ---> MODERN IMPORT / GET DATA FROM EXCEL |
- | | |
- | +---> Complex transformation, scheduled ETL, on-prem gateways |
- | | ---> POWER QUERY DATAFLOWS (M Engine) |
- | | |
- | +---> Enterprise big data, high-scale pipeline |
- | ---> AZURE SYNAPSE LINK / DATA FACTORY / FABRIC PIPELINES |
- +-----------------------------------------------------------------------------------+
- Ingestion Method Comparison
Tool Best Used For Transformation Capabilities Scheduling & Automation
Modern Import (Excel/CSV) Ad-hoc user uploads from model-driven command bars or Maker Portal Basic column-to-column mapping One-time interactive job
Power Query Dataflows Scheduled ETL from databases, SharePoint, Web APIs, CSVs Enterprise ETL via Power Query M engine (merge, pivot, split, clean) Automated recurring refresh schedules
Dataverse Web API / SDK Custom programmatic integrations, Azure Functions Custom code transformation Real-time or batch triggers
Azure Synapse / Fabric Massive-scale enterprise analytical storage and data lakes Distributed Spark / SQL pipelines Enterprise orchestration
2. Column Mapping, Lookup Resolution & Choice Sets
When importing data via CSV or Excel, mapping source columns to target Dataverse attributes requires special attention for complex column types. +-----------------------------------------------------------------------------------+
- | LOOKUP & CHOICE MAPPING ARCHITECTURE |
- | |
- | [SOURCE ROW] [DATAVERSE MAPPING] [TARGET TABLE] |
- | |
- | "Acme Corp" (Text) ---> Match against Primary Name ---> Account GUID |
- | (or Alternate Key) (Parent Account) |
- | |
- | "Tier 1 Customer" ---> Map Text Label to Integer ---> Option Value: 1001 |
- | (Choice Set Option) (Customer Tier) |
- +-----------------------------------------------------------------------------------+
- Resolving Lookups and Choice Columns
Lookup Fields:
During import, Dataverse matches text values against the Primary Name Column of the related table (e.g., matching text "Fabrikam" to an Account record named "Fabrikam").
If duplicate records exist with the same name in the target table, the lookup resolution fails or links ambiguously.
Alternate Keys: To ensure exact matching on natural keys (e.g., Customer ID or Social Security Number ), define an Alternate Key on the target table and map the lookup against that key.
Choice (Option Set) Fields:
Dataverse allows mapping incoming text labels to the corresponding integer values in the target Choice column.
If the source file contains an unmapped choice label, the import can be configured to fail the row or add the new option into the Choice definition (if permissions allow).
3. Bulk Record Deletion Jobs
Bulk Record Deletion enables administrators to remove large volumes of obsolete, inactive, or non-compliant records asynchronously without manual row-by-row deletion. +-----------------------------------------------------------------------------------+
- | BULK RECORD DELETION JOB CONFIGURATION |
- | |
- | 1. DEFINE QUERY: |
- | Select Table: [Lead] |
- | Filter: [Status Equals 'Disqualified' AND Modified On Older Than 2 Years] |
- | | |
- | v |
- | 2. CONFIGURE SCHEDULE & OPTIONS: |
- | - Job Name: "Monthly Purge of Stale Disqualified Leads" |
- | - Start Date & Time: 2026-08-20 02:00 AM |
- | - Run this job every: [ 30 ] days |
- | - Send an email notification to: [ admin@contoso.com ] |
- | | |
- | v |
- | 3. SYSTEM JOB EXECUTION & MONITORING: |
- | Status: Waiting ---> In Progress ---> Succeeded / Failed |
- +-----------------------------------------------------------------------------------+
Practical Bulk Delete Scenarios:
Regulatory Compliance (GDPR/CCPA): Purging customer personal data upon expiration of statutory retention windows.
Storage Optimization: Removing completed asynchronous workflow logs, transient sync records, and old email attachments.
Data Hygiene: Deleting closed test records or disqualified leads.
Caution
Cascading Delete Behaviors: Bulk deletion honors table relationship cascading rules . If an Account is deleted and the relationship to Contacts is configured as Cascade All , all associated Contact records will be permanently deleted as well. Always verify cascading behaviors prior to running bulk delete jobs.
4. Excel Export Modalities & Security Governance
Model-driven apps provide four distinct ways to export data to Microsoft Excel. +-----------------------------------------------------------------------------------+
- | EXCEL EXPORT MODALITIES MATRIX |
- | |
- | +------------------------+ +------------------------+ +---------------------+ |
- | | STATIC WORKSHEET | | DYNAMIC WORKSHEET | | OPEN IN EXCEL | |
- | | | | | | ONLINE | |
- | | - Snapshot in time | | - Live query connection| | - In-browser edit | |
- | | - Up to 100,000 rows | | - Requires Dataverse | | - Click 'Save' to | |
- | | - No live data refresh | | authentication | | sync back to DB | |
- | +------------------------+ +------------------------+ +---------------------+ |
- +-----------------------------------------------------------------------------------+
- Comparison of Export Types
Export Format Connectivity Use Case Security Behavior
Static Worksheet Offline .xlsx file Sharing historical snapshots with non-authenticated external stakeholders Exports only columns and records visible to the user at export time.
Dynamic Worksheet Live Office Data Connection (ODC) Ongoing ad-hoc reporting where Excel queries live Dataverse data upon opening Prompts for Dataverse credentials on open; query re-executes with user's permissions.
Dynamic PivotTable Live PivotTable connection Real-time dimensional slicing and aggregation in Excel Requires live user authentication; updates dynamically upon refresh.
Open in Excel Online In-browser session Fast bulk updating of existing records without leaving the browser Clicking Save triggers an asynchronous bulk update job back into Dataverse.
Security & Privilege Governance
Export to Excel Privilege: Located under the Business Management tab of Security Roles. If this privilege is removed, the entire Export to Excel menu is hidden from the user.
Field-Level Security: Columns protected by Field Security Profiles export as masked values (e.g., **** ) if the user lacks Read privilege on the secured column.