Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Import many to many relationships

(1) ShareShare
ReportReport
Posted on by 55
I have an instance where we have a many to many relationship. I'm familiar with using data flows to import a one to many relationship but how do we utilize the out of the box many to many relationship when we have pre-existing data that needs to be imported. How do i access the junction table that gets created to import the data into it?
Categories:
  • Suggested answer
    SteRe Profile Picture
    SteRe 247 on at
    Import many to many relationships
    There is a tool in xrm toolbox for exactly this. 
    I think this tool is part of the standard installation, if not just search for it in tool library. 
    Use is simple. 
    1. Login to your environment
    2. Search for first entity
    3. Tool provides you a list om MN linked entities , so you can select second entity
    4. If you like, check existing data / export to get understanding for the format
    5. Prepare a csv with record information you would like to like
    6. Import via tool

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics