cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Unable to generate line items in PowerApps

Hello Community,

I have a table called Orders (parent table) which has OrderID as a unique column. I have another table, OrderLine (child table) which has OrderID and OrderLineItems columns. I would like to create an app that inserts record initially in the parent table and then grab the OrderID from the parent table and insert into child table. 

Example:  Table 1

             Order ID        Date                  Name  

                 1              5/15/2020           John

 

Table 2

OrderID   OrderLineItems     Price  Qty

  1                      1                   $5     1

  1                      2                    $3    2

   1                     3                   $6     2

 

Can this be achievable in powerapps? Any tips or suggestions would be helpful. Thank you

 

2 REPLIES 2
Highlighted
Super User III
Super User III

Hi @bakgou1 

I have an example of that in my series on database principles in PowerApps. That one is an illustrated example of how to implement one to many relationships in PowerApps.  See https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Design-fundamentals-Imple... 

Highlighted

Hi @Drrickryp ,

I saw the tutorial. I was able to insert the row in my parent table but unable to insert all rows related to the order id from parent table. Powerapps errors out "Item has already created on the server". 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,628)