Parent data to Child Record

(0) Share

Report

Posted on by Mridula1

Hi,

We are trying to create a Model driven app in data verse.

We have a parent table and a child table and its already has a relationship.

At parent level we have 3 fields which we want to bring to child level while creating a child record.

Is there way to bring parent level field data to child.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @Mridula1

Hope you are doing good,

Use Can use Quick VIEW to Show the Data from Parent Record to Child Record.

Let me know if you need more clarity.

1, Navigate to https://make.powerapps.com

2. Click Tables --> Expand Parent Table --> Select View --> Select Quick View Form

3. Add the Field you need to show in the Child

4. Now Save and Publish that

5. Click the Child Table

6. Click Forms --> Open the Main Form --> Select Quick View Form --> Click Related and Select the Form which you created in Point 2

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

Hi @Mridula1 ,

You can use Relationship field mapping feature to map the field data from parent entity to child entity. Please see below link for more details.

https://www.gestisoft.com/blog/field-mapping-dynamics-365

Thanks,

Bipin

Was this reply helpful? Yes No
Mridula1 2 on at

Like (0)

Report

Hi,

Thank you for your answer. I have tried this option but in this way we are only showing the data but actually storing it at child level. My intension is to store it at child level so that I can build data validation rule on top of it.

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

Like (0)

Report

Hi @Mridula1 ,

The mappings given by @bipinshan help when creating the child record from the Parent record in a subgrid or related tab. This does not populate the data if you start from the child record though and do a "New" and set the Parent record.

Most of the time I do this through a Real Time Workflow https://docs.microsoft.com/en-us/power-apps/maker/data-platform/overview-realtime-workflows.

1. Setup the real-time workflow on Create of the child record

2. Step with Update record in the workflow and set the fields on child record from the Parent record.

Was this reply helpful? Yes No
HD-30040748-0 56 on at

Like (0)

Report

Hi @dpoggemann ,
This is working fine in my case when ever a child case is created from the parent case sub grid and after saving of the child record then only the data getting updated but I need those fields to be auto populate when a new child record is creating not on the save of child record

Thanks in advance

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

Like (0)

Report

Hi @Hareesh2728 ,

You would need to do this with JavaScript to autopopulate before save then if not coming from a related grid.

Example post: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Model-Driven-App-JavaScript-function-to-populate-related-form/td-p/1397470

Was this reply helpful? Yes No