How to Send and Fetch Outlook Emails in PowerApps Using Office 365 Outlook Connector

Create Records from Excel Using Power Automate in Dynamics 365

Organizations frequently receive business data in Excel files. Instead of manually entering hundreds or thousands of records into Dynamics 365, Power Automate can automatically read Excel rows and create records in Dataverse.

This automation improves efficiency, reduces manual effort, and minimizes data entry errors.

In this article, we'll explore how to create Dynamics 365 records from Excel using Power Automate.

Why Import Excel Data into Dynamics 365?

Many business processes begin with Excel spreadsheets.

Common examples include:

• Customer Imports
• Lead Uploads
• Product Data
• Employee Information
• Project Records
• Vendor Details

Without automation, users must manually enter records into Dynamics 365, which consumes time and increases the risk of errors.

Solution Overview

• Excel File
• OneDrive or SharePoint
• Power Automate
• Dataverse
• Dynamics 365

Workflow: Excel File → Read Rows → Apply to Each → Create Dataverse Record → Success Notification

Prerequisites

Before creating the flow, ensure:

• Excel file is stored in OneDrive or SharePoint
• Data is formatted as a Table
• Dataverse environment is available
• Required security permissions are assigned

Step 1: Prepare the Excel File

Create an Excel spreadsheet.

Example:

Convert the data into an Excel Table.

Power Automate requires table-formatted data for processing.

Step 2: Create a Power Automate Flow

Create a new cloud flow.

Possible triggers:

• Manual Trigger
• Scheduled Trigger
• File Uploaded Trigger
• SharePoint Trigger

The trigger determines when the import process starts.

Step 3: Read Excel Rows

Add action:

• Excel Online (Business)
• List Rows Present in a Table

Configure:

• Location
• Document Library
• File
• Table Name

This retrieves all rows from the Excel file.

Step 4: Process Each Row

Power Automate automatically creates an Apply to Each loop.

Each row becomes available for processing.

Example:

• Row 1 - Create Contact
• Row 2 - Create Contact
• Continue until all records are processed

Step 5: Create Dataverse Record

Add action:

• Microsoft Dataverse
• Add a New Row

Configure:

• Table Name
• Field Mapping

Example Mapping:

• Excel First Name → Contact First Name
• Excel Last Name → Contact Last Name
• Excel Email → Email Address

The flow creates records automatically in Dynamics 365.

Real-World Example

Customer Import Automation

Sales teams upload customer spreadsheets.

Power Automate:

• Reads Excel Data
• Validates Information
• Creates Contacts
• Creates Accounts
• Sends Completion Email

Result: Thousands of records can be imported automatically.

Handling Duplicate Records

A common requirement is preventing duplicates.

Before creating records:

• List Rows (Dataverse)
• Check Existing Record
• Condition

Example:

• If Email Exists - Skip Record
• Else - Create Record

This improves data quality and prevents duplication.

Error Handling

Best practice:

Use Scope Actions.

Create:

• Try Scope
• Catch Scope

Track failures and generate reports.

Benefits:

• Easier troubleshooting
• Better monitoring
• Improved reliability

Common Use Cases

Lead Imports

Import marketing leads into Dynamics 365.

Customer Migration

Move customer records from legacy systems.

Product Uploads

Create product catalogs automatically.

Employee Onboarding

Import HR records.

Vendor Management

Create vendor records from spreadsheets.

Best Practices

Use Excel Tables

Required for Power Automate processing.

Validate Data

Check mandatory fields before record creation.

Handle Duplicates

Avoid creating duplicate records.

Log Errors

Maintain audit information.

Process Large Files Carefully

Use pagination and batch processing when needed.

Test in Sandbox

Validate mapping before production deployment.

Benefits

Faster Imports

Automate large-scale data entry.

Reduced Manual Work

Eliminate repetitive tasks.

Improved Accuracy

Reduce human errors.

Better Data Quality

Validate records before creation.

Scalable Automation

Handle large datasets efficiently.

Conclusion

Creating Dynamics 365 records from Excel using Power Automate is one of the most effective ways to automate data imports and reduce manual effort. By combining Excel Online, Dataverse, and Power Automate, organizations can build scalable solutions that improve efficiency, increase accuracy, and streamline business processes.

Whether importing leads, customers, products, or employee records, Power Automate provides a flexible and reliable approach for automated record creation.