I've been given a layout for a dataverse design with a Parent-Child-Grandchild layout.
I've no issue with how it works in the dataverse, but I've not done something with three layers like this in Power Pages (which is the ultimate goal of this.
Do you know if it's going to cause me serious issues in Power Pages?
No, it won’t cause serious issues, but you need to plan your form design and relationships carefully because Power Pages does not automatically handle deep hierarchical relationships out-of-the-box.
Challenges in Power Pages
Form Design:
Power Pages forms typically handle one table at a time. Displaying related records (especially two levels deep) requires subgrids or custom Liquid code.
Permissions:
Ensure table permissions are configured for all three tables so users can view and edit related records.
Navigation:
Out-of-the-box, you can show a subgrid for Child records on the Parent form. For Grandchild records, you’ll need:
Either a custom page for Grandchild records.
Or use Liquid templates and FetchXML to display them.
Best Practices
Use Subgrids for Child Records
Add a subgrid on the Parent form for Child records.
Add another subgrid on the Child form for Grandchild records.
Consider Custom Web Templates
If you need all three levels visible on one page, use Liquid + FetchXML to query and render related records.
Performance Considerations
Avoid loading too many related records on a single page.
Use pagination or filtering for large datasets.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
4
Share
Report
All responses (
Answers (
