Unanswered

Creating Relationship Between Tables with Existing Data and Model Driven App

(0) Share

Report

Posted on by jbyler

I am working on a project that takes existing data from several db tables, merges that information together and then using a model driven app allow users to view the data. I am using an on prem connector and dataflows to bring the data into dataverse. One of the data sources is a list of items my company sells and then another data source is a list of warehouses those items are located in. So the first data source each line is unique in that the item name is only ever used once. The second data source there will be multiple records for each item name as it will be stored in different warehouses. So I need to create a 1:many relationship from the item table to the warehouse table. Which seems straightforward reading the kb. Where I am struggling is then how to create the necessary relationship using Dataflows. So much of the documentation is around users entering data and when they create the new record manually add the relationship in form. Any help is appreciated.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@ppibeauty

I wanna clarify something , Have you already created the dataverse tables structure and then you move the data using data flows?

Was this reply helpful? Yes No
jbyler 8 on at

Like (0)

Report

Thats correct, I created the tables and fields and then use dataflows to populate the data in the tables.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@ppibeauty so I believe your issue is setting the lookup fields through the data flow?

Was this reply helpful? Yes No

Verified answer

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello @ppibeauty, If you have already created both tables then just make sure your relationship is set between them before you start importing the data. Follow the instructions below:

In the Parent Table, the One side of the relationship, Create an Alternate Key for the Line unique item name Column.
Create a 1:N relationship between the two tables.
The relationship will create a Lookup column in your Child table (The many table).
Make sure that you Load the Parent Table first.
When loading the Child table, you will see the Lookup column in the mapping page but it will have the relationship name. (This means that your relationship will work perfectly with your new data)

I have this tutorial to show how you can accomplish this but I am using Excel as the data source. Nonetheless, all the steps are applicable on any other data source.

Check the tutorial: https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & 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

Was this reply helpful? Yes No

jbyler 8 on at

Like (0)

Report

Perfect, this worked and is exactly what I need.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@ppibeauty, Happy to help 🙂

Was this reply helpful? Yes No