Create View in Dataverse with parent´s parent´s column

[RaSa]

Hi, as you can see in screenshot I have enclosed, I have 3 Dataverse tables with one to many relations.

In the Car_Parts table I´m trying to create a view which will show some columns from Cars table as well as some columns from Owner table.

Can you please help me how to do that ? What I was able to do was to only show related columns from Cars table.

Thanks for any help

 

[joaodsantos]

Hi,

There's a couple of options but no easy out of the box to just bring the fields two relationships away (as far as I'm aware).

You could:

- Copy those needed owner table fields to the Cars table on create/update of the owner field on the cars table, you can then use them on a view since they'll be only one relationship away. You could probably do these with relationship mapping or a workflow/power automate flow on create/update of the owner field on Cars could bring those values across

- Create a relationship on the Car Parts table to the Owners table and populate it using the one on the related Cars table; again, a WF or flow on create/update of the car lookup could keep the owner field updated

maybe someone else knows of a different option but I think these might your options

[Mira_Ghaly]

@RaSa 

As mentioned by @joaodsantos Second Option is the way to go "relate a relationship on the Car Parts table to the Owners table and populate it using the one on the related Cars table; again, a WF or flow on create/update of the car lookup could keep the owner field updated"

If you need more elaboration or help  on this one please let us know.