Answered

Importing hierachicly related data into dataverse

(0) Share

Report

Posted on by a_debiec

Hello Guys,

I am trying to import data into a table in dataverse and I want it to be hierarchicly related. I already created a table with hierarchical relationship and I can add data to it and display it visually in hierarchy but in the end my dataset has over 10 thousand records and I must import it and relate it quicker than one by one.

Can someone please help me with importing related data into dataverse.

Best Regards!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @a_debiec ,

There are a number of approaches to do this from data flows, API, etc. but I find the easiest is Excel Import using the Data Mapping Templates.

You would want to import all of the records first as "new" records using the Data Import Template for that table and then export all the records and set the Lookup field for the Parent to the Primary Name field of the Parent record.

Note, you can not have duplicates in this Primary Name field or it will fail on those records as it will not know which to match.

Data flows is another option here as well but this has been the simplest for me in the past.

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,660 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @a_debiec,

Step 1: Import the Lookup/Relationship data to the table
Step 2: Make Sure Step 1 Doesnot have duplicate Records
Step 3 : Import the Final List of data which contains Step 1(loopup/Relationship) data

Please let me know if you need more clarity

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
a_debiec 6 on at

Like (0)

Report
Copy link

Link copied!

Hello @dpoggemann ,

Thank you for your response. Nevertheless I can't seem to get it right. Is it possible that you will record a video of the whole process with some sample data?
Also when I try to import from excel I get an error that multiple sheets files are not supported, even though I only have one sheet.

Best Regards!

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

Like (0)

Report
Copy link

Link copied!

Hi @a_debiec , send me a private message and we could do a screen share to walk through if that works….

Was this reply helpful? Yes No
a_debiec 6 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I managed to make it work. One thing that I missed was that I didn't set any key for the table that I wanted to import data into. Only after adding key to main column, I was able to map data to lookup column. Nevertheless your suggestion to use data mapping template was very helpful.

Best Regards!

Was this reply helpful? Yes No