Unanswered

Dataverse Table relationship

(0) Share

Report

Posted on by Echo4674

In dataverse I have table A,B,C and table A and B have 1:N relationship and tables B and C have 1:N relationship as well. I want to get a column value in table A to auto-populate and display in Table C. I have a quick view in table B to show the field from table A. How do I achieve that.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (2)

gulshankhurana 1,397 Moderator on at

Like (0)

Report

Hi @Echo4674

Is it a model driven app or canvas app you're building?

Kind regards

Was this reply helpful? Yes No
Echo4674 22 on at

Like (0)

Report

Its Model driven app

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (1)

Report
@Echo4674

You can create a new simple main form in Table B which has the Quick View form to show the field from Table A. Then, embed that new form in Table C with the Form Component control and show it.

Here are some useful links about Form Component Control

https://www.youtube.com/watch?v=TBNgVH-DZts

https://d365goddess.com/configuration-form-component-control/

https://nishantrana.me/2021/02/03/form-component-control-in-dynamics-365-power-apps/

Here's the outcome

How it looks without populating the lookup B on table C.

The main form of Table B itself with the Quick View to the fields from Table A.

Was this reply helpful? Yes No
Federico Pelliccia 143 on at

Like (0)

Report

Do you want just show the value from table A or do you want to set value on a column on table C?
If you want populate the field on the table C, you can just create an easy javascript resource with a fetchXml inside it. When you load your form on create, you can read that value through your fetch and populate the field on table C

Was this reply helpful? Yes No
Echo4674 22 on at

Like (0)

Report

I want to get the value from Table A and display it in Table C. Javascript seems the way, Do You have any sample script by any chance or resource recommendation? Thank you.

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

Like (0)

Report
Hi @Echo4674 ,

I have created a number of applications with this situation. I normally carry the A table to the C table in the mappings or in real-time workflows. I know you shouldn't have to since the relationship is two levels up but it really makes it a lot easier.

What I normally do:

Add the lookup of A on the C table.

On the relationship from B to C in the Mapping, I will add the A to map from B to C table

This is really nice when working in Model-Based Power Apps because you can now see A and B lookups on C table. The only challenge here is if B changes relationship to have a different parent (i.e. moving from A to E or something like that), this will not update the A value on the C table. Normally this is not the case with what I am working with and you could always write a Power Automate Flow to update this relationship if needed.

Was this reply helpful? Yes No
Verified answer

Linn Zaw Win 2,996 on at

Like (1)

Report

@Echo4674

Just for display purposes, you don't need any JavaScript. You can achieve it by configuring the Quick View form and the Form Component control as in my reply above.

Was this reply helpful? Yes No
Echo4674 22 on at

Like (0)

Report

Hi @dpoggemann thank you ffor the help and One more question, I am having difficulty with the relationship adding A to map from B to C table

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (2)

Report

You can do this in the "Mappings" in the relationship. Go into the classic interface and into the 1:N relationship from B to C and you will see "Mappings" as an option on the left navigation. This is where you add...

See below...

Was this reply helpful? Yes No
anacarolinagr 48 on at

Like (0)

Report

@LinnZawWin How can I do that in Dataverse for Teams?

Was this reply helpful? Yes No