Announcements
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,
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
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,
@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
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
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
hi,
We provide this solution
visit our site - https://dynatechconsultancy.com/
HI @drhorg
As Suggested by @dpoggemann we can simply use CSV export import to achieve the same
I have the same issue. Do you guys have any update on bulk insert to dataverse using Power Automate flow?
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).
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 493 Most Valuable Professional
11manish 479
Haque 328
