Duplicating Records along with its related Records

(0) Share

Report

Posted on by Ethan_009

4,838 Moderator

Hi All,

I'm having a specific requirement where on a button click, need to duplicate that entity's Related record along with its related records.

Basically entity A -> entity B -> entity C.

What I have achieved so far,

On click of Record(X) of Entity A, collect data in collection of all related records (Y) in Entity B and another collection of records relating to Record(Y) in entity C.

Now I have duplicated Record(X) in Entity A and related Record(Y) to Entity B.

I'm stuck where I need to duplicate Record(Z) from entity C related to new Record(Y) from Entity B.

I'm gone through MS Docs. came across With() function which can help but I have no idea how to use. With Function

I need to perform ForAll() into With.

Need Advice.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi All,
Any idea on above requirement ?

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Referring to my previous post: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Duplicating-Records-along-with-its-related-Records/m-p/948816#M11896

You would need to do something like this. Notice the difference in the names EntityA, EntityB and EntityC. EntityAID/EntityBID is the ID of the respective patch results.

With( Patch(EntityAs, Defaults(EntityAs), {Column1: "XYZ", Column2: "ABC"}), ForAll(EntityBsGallery, With( Patch(EntityBs, Defaults(EntityBs), {EntityA: EntityAID, Column1: EntityBGalleryColumn}), ForAll(EntityCsGallery, Patch(EntityCs, Defaults(EntityCs), {EntityB: EntityBID, Column1: EntityCGalleryColumn}) ) ) ) )

Hope this helps!

Was this reply helpful? Yes No