Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Create related records...
Power Apps - Microsoft Dataverse
Answered

Create related records in model driven apps on one form

(0) ShareShare
ReportReport
Posted on by julijazas 820

Hi

I am creating an order management system and it's data is stored in different dataverse tables.

The tables ofcourse are linked via lookup tables.

Is it possible when creating a new order to add like a subgrid order lines(table) and fill the order lines being in same windows(not needing to navigate to other table) select order number and enter order lines? AS order and order lines are linked via lookup table i would like to pass automaticaly the order number to every new order line i create?

Is that possible with out of the box dataverse or i need to go with custom pages?

Categories:
Microsoft Dataverse
  • julijazas Profile Picture
    julijazas 820 on at
    Re: Create related records in model driven apps on one form

    @dpoggemann 

    Thanks mate!

  • Verified answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,278 Most Valuable Professional on at
    Re: Create related records in model driven apps on one form

    Hi @jja ,

     

    I read your question a few times and from what I understand you have the Order Header table and you want to:

    1. Display a sub-grid on that form for the order lines
    2. Add new lines to the sub-grid automatically populating the order number from the header

    Yes, you can do both of the items above out of the box if this is what you are asking.

    • Sub-grid - There are many articles / videos for adding sub-grids to forms, here is one (https://youtu.be/rkyyc7K6m1s).  If you have a 1:N relationship setup between your Order Header Table and your Order Line Table you will have the ability to select this relationship in your sub-grid and select the appropriate view for your records
    • Set Order Number - Easy way here is to utilize column mapping so when you create the order line it will set information from the Order.  https://docs.microsoft.com/en-us/power-apps/maker/data-platform/map-entity-fields.  This should work when adding items to the sub-grid or when you go to the "Related" tab in your entity and choose "Order Lines" it will set the value here as well when creating a new Order Line

     

  • Ram Prakash Profile Picture
    Ram Prakash 5,289 Super User 2025 Season 1 on at
    Re: Create related records in model driven apps on one form

    Hi @jja 

     

    As per OOB Behavior it is not Possible but you can give a try with below scinarios,

     

    1. Write a PCF Control and Trigger from a Button and Create a Data and Store it in Cache or Session and Trigger it once after the parent Record gets Saved

    2. You can try the same in HTML with the Same Format as well.

     

    If there is any static data then we can use Plugin or Microsoft Flow to Achive the same..

     

    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

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans