Import multiple CSVs with data and create relationships

[BartVM]

hi

I am importing several CSV files with for each CSV file several columns that refer to records in other CSVs. Is there an efficient way to import the data of all these CSVs in Dataverse (power app) tables and create the corresponding relationships that was provided in the CSVs via referring to the primary keys in each CSV.

thanks for some help

Bart

[AhmedSalih]

Hello, @BartVM, I have this full tutorial of how we import related Excel sheets to Dataverse tables. You will treat the CSV files the same:

https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1?blogcategory=Dataverse

If my reply helped you, please give a 👍  , & if it solved your issue, please give a  👍& Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

[BartVM]

hi @AhmedSalih , thanks for the info.

When I look at your documentation it seems I need to create all the dataverse tables manually. It will cost me a huge amount of time since I have alot of columns in the CSVs. Is there not a possibility to create the tables more automatically?

Thanks

Bart

[AhmedSalih]

@BartVM, because you will have to create alternate keys and relationships, there is no easy way to do this Automatically at this time. 

[BartVM]

@AhmedSalih ok I understand - in your video it is not so clear how you create the alternate key to be honest. You show it when importing the customers sheet but the key column 'demo_customerID' is mapped automatically. So where do you define the alternate key and how/why is it mapped automatically? As you see I am a novice 😉

[AhmedSalih]

@BartVM 

[BartVM]

@AhmedSalih thanks, loud and clear