Unanswered

Bulk insert to Dataverse from Excel

(1) Share

Report

Posted on by drhorg

I need to create a solution for bulk inserting 2000 rows from an Excel file (located on user machine) to a Dataverse table. for each of the Excel rows there will are additional columns which can get from another Dataverse table (take that as lookup activity). How can this be done via power automate?

I found row by row takes way too long.

Many thanks,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @drhorg ,

Do you need this as a background process? If not, you can utilize CSV import process to import directly from the Excel file. I have done over 2K rows from Excel / CSV files. You will also be able to define and save the import mapping and reuse if needed.

Here is a good article describing the process if this would work for you: https://www.gestisoft.com/blog/use-import-data-wizard-dynamics-365

Was this reply helpful? Yes No
drhorg 45 on at

Like (1)

Report

hi @dpoggemann thank you for reply. I need to trigger the power automate flow from the portal. it is being done by the portal users.

Thank you,

Was this reply helpful? Yes No
Gowri Halan 262 on at

Like (1)

Report

@drhorg I assume your scenario could not be better handled via power automate unless someone already implemented. Power automate provides connectors to read excel though, if you retrieve it from some stored location (oneDrive,Sharepoint). But like you mentioned you cant handle bulk upload to Dataverse via connectors. Dataverse web API can be utilized.
Data Import SDK are available if you wish to go for coding based approach.
https://github.com/microsoft/PowerApps-Samples/tree/master/dataverse/orgsvc/C%23/ImportComplexDataMap

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @drhorg ,

You might want to take a look at Azure Data Factory, this might be a good option for you here. Azure Data Factory copy data can be bursted for performance.

https://learn.microsoft.com/en-us/azure/data-factory/format-excel

https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-performance

Was this reply helpful? Yes No
Hauke Jacobsen 64 on at

Like (1)

Report

Hi @drhorg
Please find the solution in this post. You can utilize bound actions on the Data Import table:
https://community.dynamics.com/365/f/dynamics-365-general-forum/436347/using-power-automate-to-initiate-importing-records
Best regards
Hauke

Was this reply helpful? Yes No
DynaTech Systems 4 on at

Like (1)

Report

hi,
We provide this solution
visit our site - https://dynatechconsultancy.com/

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

HI @drhorg

As Suggested by @dpoggemann we can simply use CSV export import to achieve the same

Was this reply helpful? Yes No
marinceanionut 6 on at

Like (1)

Report

I have the same issue. Do you guys have any update on bulk insert to dataverse using Power Automate flow?

Was this reply helpful? Yes No
Shashank Bhide 942 Moderator on at

Like (1)

Report

200 records aren't big, so ideally it shouldn't take a very long time, you can control concurrency of power automate to increase the speed, however if there are a lot of operations happening per row, then you can consider SSIS or azure data factory (ADF).

Was this reply helpful? Yes No
citdevpros 61 on at

Like (1)

Report

Hi @drhorg ,
You can create a DataFlow to read the Excel file, transform the data (the lookups), and load into the DataVerse table. Then create a Power Automate flow to call the DataFlow.

You can create an additional Power Automate flow that is triggered by completion of the DataFlow so it alerts you when the job is completed.

Was this reply helpful? Yes No