Bulk create with One-to-Many (1:N) relationship

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I'm trying to implement a Bulk Create option in a model driven app.

We have 2 entities(Order & Positions) in 1:N relationship.

One Order can have multiple Positions assigned to it.

Any idea how a bulk create option can be implemented for such structure?

Best thing I came up for now is build a canvas app that can handle the bulk create by patching & relating the records in the tables. However, the issue is that when the canvas app is embeded in the model driven form, you actually need to create the item in the database in order for the app to appear.

Tried also with a custom page, but I'm not able to find a way to display a dropdown on a custom page, and that is needed.

Any feedback is appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

When you create one order you want to create N related position records? Or is this relation already set somewhere?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi jcfDaniel,

Yes, I want to create from a single screen multiple orders and all the related N positions for each order.

The order and position details are entered by the user. Afterwards they should click on "Create" and all the records & relations between them should be created in the two Dataverse tables.

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

You should be able to it in a form with a subgrid. Create the order and then add the details in the subgrid.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That works for creating a single order with multiple sides. However I'm looking for a way to create multiple records in both tables at once.

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You want to create several orders at once? And they all share the same details?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, we want to create several orders at once. They don't share the same details. In addition, every order will have positions entered for it.

So, at one screen the user should be able to enter multiple orders, enter the multiple positions for each order and create them with a single button press.

Best thing I came up with is a Canvas app that uses two collections in galleries and a very, very long Patch() setup for both tables in Dataverse. 😄

I'm looking for a way either to embed the canvas app somewhere in the UI of the model driven app, where it can be used, or use a native model-driven app component that can achieve the same result.

Embeding the canvas app on the form does not work in my case, as you need to create an actual item in the database, before the app is rendered/presented on the form.

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Embedded Canvas/Custom seems the way forward.

Embedded Canvas shouldn't need a record to relate with.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Is there another place where I can embed a canvas app or it can be only a form?

Custom page doesn't provide dropdown control so for now it's not an option for me.

Was this reply helpful? Yes No
Verified answer

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Take a loom at this:
Embed a Canvas App in a Model Driven App (full-screen) – Dynamict

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

This actually does the trick! Thank you very much for your time and help on this, jcfDaniel! 🙂

Was this reply helpful? Yes No