Indirect Related Table

(0) Share

Report

Posted on by barbossa_94

Hi All,

i have the following situation:

-Table 1: Account ( the default dataverse one)

-Table 2: Opportunities

-Table 3: Sites

Each Account can have multiple opportunities (one to many)

Each opportunity can have multiple sites

On my account form i want to display all sites that this account owns. Unfortunately i can't display the sites in a subgrid. He either shows all (also non related records) or none at all.

I did set the relationships as follows:

Account (one to many) Opportunities

Opportunities (one to many) sites

Is there a way to achieve this?

Regards,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Drew Poggemann 9,287 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @barbossa_94 ,

I usually carry the parent fields down my child tables. I have done this for multiple projects in the past and there are some things to be aware of with doing this but it has honestly served me well.

Example:

Add Account field to the Site table

Setup mapping in relationship so when you create a site from the Opportunity it will also map the Account to the Site

Once you set this up then you will have created that direct relationship to the Account and you can also click to the Account from your Site or even show a Quick View form on your site from the Account.

The only thing to be aware with doing this type of mapping is that if your Opportunity changes to point to a different Account, there is nothing that would change the Site's Account, this would need to be a Flow to update that if it is possible.

Was this reply helpful? Yes No
barbossa_94 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dpoggemann
This is the solution I am looking for.
thanks for the reply. Could you explain where and how i set up the mapping correctly?

Thanks,

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @barbossa_94 ,

Check out the following: Map table columns in Power Apps - Power Apps | Microsoft Learn

Was this reply helpful? Yes No