cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Juul
New Member

Adding multiple products to one order (Model-driven app)

Hi All

 

I have following tabels:

- Account

- Product

- Order

 

I would like to the following in my order tabel

- Connect one Account (lookup), done

- Multiple products, fail

 

How can i add multiple products to my order?

 

Thanks, 

 

BR

Juul

 

2 REPLIES 2
Mira_Ghaly
Dual Super User
Dual Super User

@Juul 

  • Is your tables custom or the out of box tables?
  • What is the issue you are facing adding multiple products the relationship should be 1:N between order and products or more better it should be through a custom table in case you need to add more info. about order and products but it all depends on your business scenario.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
dpoggemann
Super User
Super User

Hi @Juul ,

 

I would recommend adding another table called Order Line that would be a N:1 to the Order.  This table would contain a lookup to the Product entity and would also have things like quantity, price, tax, and other fields that would be tied to the order line for that specific order.  

 

 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,942)