Automate Excel-Dataverse Import

Job ID: 40211077

Budget: $10 – $30 USD

I have an Excel file in my local disk that stores user information in eight columns, and I need a repeatable Power Automate flow that moves this data straight into a Dataverse table. The goal is to eliminate manual data entry completely.

Here’s what I already have:
• A structured Excel sheet stored in my local disk.
• A Dataverse environment with the destination table created and the columns mapped 1-to-1 with the spreadsheet.

What I need from you:
• Build and configure a Power Automate flow that takes the file, reads every row, and inserts or updates the matching records in Dataverse.
• Make sure errors—such as duplicate rows or missing required fields—are handled gracefully with clear email or Teams notifications.
• Provide a short walkthrough or video showing how to adjust the flow if additional columns are added later.

Acceptance criteria
• Running the flow imports all eight columns correctly and shows in Dataverse without manual edits.
• No failed runs when the Excel sheet follows the current format.
• Clear, commented steps inside the flow so any admin can maintain it.

If you have built similar Excel-to-Dataverse automations before, let me know; a quick example or screenshot of a previous flow will help me move fast on awarding the project.