Understanding one-to-many and many-to-one relation in data verse

(0) Share

Report

Posted on by KrishR

431

Hello Power Users,

I'm trying to understand the functionality with the relations in data verse and little confused with the implementation.

Can we achieve the functionality same as we can achieve in SharePoint like,

List A is the Parent list with look up fields from List B

List B is the child list.

Would like to build a look up table like the above in data verse. Can this be possible in Data verse?

Can someone please help me understand. Thank you so much in advance!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

AhmedSalih 6,678 Moderator on at

Like (0)

Report

Hello, @KrishR, in the Child table, you need to create a Lookup column that is looking up to the Parent table. You will implicitly create a relationship between the tables.

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.

Visit my Blog: www.powerplatformplace.com

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

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report

Hi @AhmedSalih ,

Thanks for your help. Do I need to create all those look up columns with relation or looking up in a table and choose the columns we want to look up?

Can you please help?

Thanks again!

Was this reply helpful? Yes No
Parvez Ghumra 1,579 Moderator on at

Like (1)

Report

@KrishR No, simply create a single lookup column in your child table to target the parent table. The platform will automatically create the underlying 1:N relationship for you. Think of the lookup column as a foreign key column in classic RDBMS.

If you're building Model Driven Apps, you will then be able to build views in your child table to display columns from the related record in the parent table. Similarly, if you wanted to can create a Quick View form on your parent table, and surface this on the main form in your child table to show column values from the related parent record.

Was this reply helpful? Yes No
Hector73 6 on at

Like (1)

Report

Hi @parvezghumra ,

Can you please help me with an example? Also, the relationship set up. I'm very new to the data verse and I ended up having all the columns with same values. An example would be so helpful. Thank you so much.

Was this reply helpful? Yes No
Verified answer

Parvez Ghumra 1,579 Moderator on at

Like (1)

Report

@Hector73 Read here with examples/screenshots: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-entity-lookup#add-a-lookup-column-many-to-one-relationship

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report

Hi @parvezghumra ,

Thank you so much for the info. It was very detailed on the set up. I'm trying to find some examples related to this with displayed data. I'm under the impression that this will be similar to SharePoint lookup set up. When I lookup for a table I can choose all the columns that I wanted to display from child list in SharePoint.

Is this same in data verse? Sorry, I'm confusing or may be I'm looking in wrong direction.

Any help or suggestions that I can look for this details?

Thank you

Was this reply helpful? Yes No
Parvez Ghumra 1,579 Moderator on at

Like (1)

Report

@KrishR If you have configured the single Lookup column and underlying 1:N relationship then that is all that is required for the data modelling piece in Dataverse.

Your next question is really about how you surface the data from the related table in your application. I'm sorry I don't know anything about SharePoint, but I can try to help you achieve something similar in a Model Driven App if that is your intended application type to use this data model? Please read this article which explains detailed steps for configured views that can be used in a Model Driven App, including details of adding columns from related tables: https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/choose-and-configure-columns#adding-columns

Was this reply helpful? Yes No