Unanswered

Create related records using model driven apps or flows

(0) Share

Report

Posted on by MSchd

I am creating a model driven app. I want to automatically create records that are related to related entities when creating another record. An example will follow.

Info

I have the following tables in my dataverse environment:

- Sessions

- Products

- Inspection Sets

- Samples

Relationships:

Inspection Set to Sessions 1:N

Inspection Set to Products 1:N

Product to Samples to 1:N

Session to Samples 1:N

An Inspection set contains a number of products. Many inspection sets and products exist currently in the dataverse environment. Now I want to create a session for an inspection set. When creating a session I also need to create its samples. These samples should be related to the products in the inspection set.

Example

So if my inspection set (called InsSet) has two products (prod1, prod2) and I want to create a new session for InsSet, than I also want to create two samples (sam1, sam2), such that sam1 is related to prod1 and sam2 is related to prod2. Is there a way to this in model driven apps?

Possible solutions

I thought of using a cloud flow to create related records, but I don't know if I can create multiple records that are related to related records of a session.

Should I maybe use a business flow for this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Jonathan Manrique 2,695 on at

Like (0)

Report
Copy link

Link copied!

Hi @MSchd

You can use Power Automate, the form will appear but it will not work. Only tendrias that are the conditions that we mention

"Now, if my inspection set (llamado InsSet) has products (prod1, prod2) and you want to create a new session for InsSet, you also want to create your products (sam1, sam2), how sam1 is linked to prod1 and sam2 was related to product 2. ¿Hay some ways to have these applications based on models?"

Must be established in the flow so that every product that creates a message for the product is created, and you can relate only to the fact that there are many messages in the product field. From this form when creating a message it will be said that the product is lost.

Please note that if your product relationship is a 1:N relationship it will allow you to create more of a message for a mismo product.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No
MSchd 70 on at

Like (0)

Report
Copy link

Link copied!

I'm sorry. I don't understand. I am having trouble finding good tutorials on using cloud flows with dataverse. Would you have any suggestions maybe?

Was this reply helpful? Yes No
Jonathan Manrique 2,695 on at

Like (0)

Report
Copy link

Link copied!

Hi @MSchd

Examinar todos los cursos, rutas de aprendizaje y módulos - Training | Microsoft Learn

Was this reply helpful? Yes No