Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ZmOMC7ZbgTUOpLqf42qiPP
Power Apps - Microsoft Dataverse
Answered

How to display columns in a parent form from child table dataverse

Like (0) ShareShare
ReportReport
Posted on 1 Nov 2023 17:26:40 by 35

I have Parent-Child tables, where the lookup column is inside Parent. (both tables have ID, Name .. IDs are PK).
I'm trying to create a form from the Parent table, where this form I can choose Name from Child.

What  I can display so far in the form, is the lookup column which is the child ID, but It's not human-readable and doesn't mean anything to my user, they need to see the Name instead of the ID.

I tried to add a new component "form" to my Parent form and edit this newly added form and add the Name to it to display both ID and Name. 

What I get after the previous step, 2 created components instead of one

Screenshot 2023-11-01 at 7.23.06 PM.png

the default one, is related to lookup column, the other form component is the one that I added manually and the one I want it to be displayed.

But what I get is always showing this thing

Screenshot 2023-11-01 at 7.24.37 PM.png

and whenever I remove the "Form Component Control", it displays the lookup column 😞

Any thoughts about how to achieve this and display not just lookup column in parent form, but display more than 1 column from child into parent form.

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 06 Nov 2023 at 22:56:29
    Re: How to display columns in a parent form from child table dataverse

    Hi @Adham-Nawito ,

    Is this what I suggested with the last recommendation or did you do something different?  If it is, can you please mark as a solution, if not you can mark yours as the solution.

     

     

  • Verified answer
    Adham-Nawito Profile Picture
    35 on 06 Nov 2023 at 18:53:11
    Re: How to display columns in a parent form from child table dataverse

    I solved the issue by adding a from component next to my lookup fields, where this form component maps which column I want to display and made the field as read-only

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 05 Nov 2023 at 18:11:48
    Re: How to display columns in a parent form from child table dataverse

    Hi @Adham-Nawito 

     

    Sorry, didn't know you are looking to edit, missed that...  If you want to embed a form to edit the parent fields, please check out the following:  https://www.ameyholden.com/articles/quick-view-forms-with-edit-form-component-control 

     

    Let me know if this is not what you are looking for...

  • Adham-Nawito Profile Picture
    35 on 05 Nov 2023 at 15:53:24
    Re: How to display columns in a parent form from child table dataverse

    @dpoggemann Quick form is not allowing me to edit any of the fields, I want them to be editable.
    or I'm missing something here?

    Like in this image, as you can see while searching for an owner it shows me ID and Name which is totally fine.
    But on final displayment you can see that It was only ID, I just want to get the Name instead of the ID in the same area
    Screenshot 2023-11-05 at 5.54.52 PM.png

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 05 Nov 2023 at 15:51:22
    Re: How to display columns in a parent form from child table dataverse

    Hi @Adham-Nawito 

     

    You can display the parent fields from the related table (i.e. from the Lookup column) on the form for the child table by using a "Quick View Form" - https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/create-edit-quick-view-forms 

  • Adham-Nawito Profile Picture
    35 on 05 Nov 2023 at 15:11:00
    Re: How to display columns in a parent form from child table dataverse

    @dpoggemann Can I display in the form any data from the child table (not just the lookup column)?
    I mean if I have relation M:1 where it's connected by ID as FK, but I don't want to display ID column in the parent, but instead I want to display Name of a person for example. Is this doable or just the lookup column can be displayed in edit form nothing more than that ?


    My use case:
    edit formedit form

    I've projects table that have lookup fields to other tables (writing script, locale, ...).
    Projects table, have lookup fields to the other tables inside it, (wiritng_script_id, locale_id,...),
    and I'm displaying them inside the edit form when u select a record from projects.

    Is there anyway to display Names from other tables (as the consists of ID & Name) rather than ID as IDs are not user friendly to be selected and user shouldn't see them I want him to select something like "English" in locale, instead of "ID" 1.

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 02 Nov 2023 at 10:28:56
    Re: How to display columns in a parent form from child table dataverse

    Hi @Adham-Nawito ,

    If you are displaying the child data in the form in a sub-grid, there is the ability to add a new child record from that grid.  Depending how you configure this it could launch the form as a popup (quick entry form) or navigate to the full form.

  • Adham-Nawito Profile Picture
    35 on 02 Nov 2023 at 09:29:58
    Re: How to display columns in a parent form from child table dataverse

    But isn't subgrids are used for table display kinda, not as form display. 
    What I mean, it's used for displaying the data, editing the data in the table, not for creating a new record for example as it's done with the form

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 02 Nov 2023 at 00:28:40
    Re: How to display columns in a parent form from child table dataverse

    Hi @Adham-Nawito ,

    Few things here:

    1. You mentioned the "lookup column is inside parent".  To setup a Parent / Child relationship in Dataverse, you should be adding a Lookup field to the Parent table as a column on the Child table.  This is specifically a field type of Lookup and you select the table.  There is no ability to select a different column etc. when setting up this relationship
    2. You can display a sub-grid on the main Parent form to display the list of child records (https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/form-designer-add-configure-subgrid) on the parent form. 
    3. If you want to select a primary Child entity (example for an Account, who is my Primary Contact) you can add a lookup on the Parent table to the Child table and then have this Lookup column on the form filtered to the child table with related records (https://blog.magnetismsolutions.com/blog/dominicjarvis/2017/10/19/how-to-filter-lookups-by-related-records-in-dynamics-365/
    4.  
  • a33ik Profile Picture
    3,304 Most Valuable Professional on 01 Nov 2023 at 19:21:45
    Re: How to display columns in a parent form from child table dataverse

    If you want to show the data from child records you can use the subgrids. Because for 1 parent there might be from 0 to infinity child records - which one of children records should be shown?

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.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started