How to show multi level relationship data on forms

(1) Share

Report

Posted on by KoJaPD

601

Dear,

I have a multi level (5 levels deep) one-to-many table structure.

On a form (on a model driven app and/or power page) of a record in the fifth level, what is the best way of showing data from all the levels above (up to the first level)?

I have tried using form components showing fields of related records, but somehow power pages does not like this, it only shows the data after multiple refreshes. In model driven apps, it takes some time to show the (nested) form component details, causing the interface to shift down each time a new level is being shown...

There must be a better out-of-the-box way, but I don't find it...

Best regards,

Koen

Categories:

Microsoft Dataverse with Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

KoJaPD 601 on at

Like
a
(0)

Report
Copy link

Link copied!

I have found a good solution: formula fields, where I can just get the parent fields like: parententity_lvl4.parententity_lvl3.parentitiy_lvl2.name
pwalsh02 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @KoenJanssensPD ,

Would you be so kind and explain your solution a bit further? Example of your Formula?
I am trying to show related One to Many data on my Main Form inside a Model Driven App so users dont have to click away from the form.

Thanks,
KoJaPD 601 on at

Like
a
(0)

Report
Copy link

Link copied!

It depends on which side of the relationship you are. On the form of the parent, you can show a subgrid with all the children. If you are on the child form, you can show fields of the parent (or grandparent) with a formula field like "parent.fieldname" or "parent.parent.fieldname" and so on...