Answered

Creating new child records in cds entity from canvas app

(1) Share

Report

Posted on by JFN

I have two custom entities: Entity1 and Entity2. There is a one (entity1) to many (entity2) relationship established. I have a canvas app with two gallerys; gallery1 to display entity1 records and gallery2 to display entity2 records based on the record selected in gallery1.

What is the best/recommended way to add a record to entity2 (child) in a way that establishes its relationship to a specific record in entity1(parent)?

I have a button and patch formula that saves all the required data and creates a new record in entity2, BUT it is not associated with any record in entity1.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Check this post if it can help:
https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Create-new-parent-record-with-child-records-using-a-collection/m-p/461804

Was this reply helpful? Yes No
JFN 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. That post makes sense, but I am getting an error...

I have attached screenshots of the entities and relationships. Below are the patch formulas. The first one saves the task request in the tasks entity but it is not associated with anything in the cases entity. I modified the patch formula based on the link that you sent but get an error.

Patch( MemberFeedbackTasks, Defaults( MemberFeedbackTasks ),{'Task Request' : ti_TaskRequest.Text})

Patch( MemberFeedbackTasks, Defaults( MemberFeedbackTasks ),{'Task Request' : ti_TaskRequest.Text},{'MemberFeedbackTasks':LookUp(MemberFeedbackCases,'MemberFeedbackCases' : dt_MostRecentCaseCreatedTaskScreen.Selected.MemberFeedbackCases))

The "dt_MostRecentCaseCreatedTaskScreen.Selected.MemberFeedbackCases" is a reference to a data table column that contains data on the most recent case created.

Thanks again for your assistance.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Two questions:

1. From your 3rd image, it seems like both fields (lookup and unique ID) in the MemberFeedbackTasks entity have the same display name? If that's true, strongly suggest changing the display name of the lookup field to something else.

2. Are you saying the 1st patch doesn't throw any error but the 2nd one does? If so, can you please share the error message?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
JFN 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Worked perfect. Thank you.

Was this reply helpful? Yes No