I have a couple of large CSV files that I am looking to import into the Dataverse.
There are hundreds of thousands of records, I am wondering how I go about filling in the Lookup portions of the tables. I think I could do it through Power Automate over a considerable amount of time due to the volume. But From past experience I have received throttling when attempting to have power automate run a large number of things through it.
As a side note, is there a way to import that data into multiple tables? What I am referring too is importing one table and assigning the data into 2 different tables as the data structure has changed.
Hi @Bahalzamon ,
Have you looked at the dataflows for powerapps?
I think you will need to to split your csv into 2 two and import the file which does not have dependency then import second file.
Another approach is to create dummy text field in your first entity and write plugin to create related table based on those text fields values.
Follow my Blog: https://xrmdynamicscrm.wordpress.com/
Kudos and Accept my answer if helpful!
Hi @Bahalzamon ,
I utilize Excel import primarily but agree this would take a while with hundreds of thousands of records! 🙂
If we have complex relationships / large numbers of records, we usually utilize eOne Solutions SmartConnect to accomplish as it has great capabilities for mapping to many different sources and destinations and can do more complex mapping relationships as needed. This is not a free tool though... As @bipinshan mentioned, Dataflows is an option as well, I have just not spent a ton of time working with this tool.
I am attempting to use this and am coming across a couple of issues.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.