Patch overwriting instead of coping

(0) Share

Report

Posted on by nemanjasovic011

240

Hello,

I have a need to copy number of records from a child table and with reference to main table (one to many). The records that need to get copied to child table are getting overwritten (update). I need to keep new rows and create a new row based on the original record(s)

(Using default(datasource) gives me: "Dataverse network error when using patch function the specified column is generated by the server and cannot be specified."

below is the code that incorrectly overwrites existing records and the line that is responsible is 'TPS UID': NewCloneRecord.TPS,:

ForAll(
TeamMemebersRecord As Stuff,
Patch(
'TPS Team Members',
// Defaults('TPS Team Members'),
Stuff,
{
ApproverEmail: Stuff.ApproverEmail,
'Member Status': "Active",
Email: Stuff.Email,
'TPS UID': NewCloneRecord.TPS,
'Training Status': "Yes"
}
)
);

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@nemanjasovic011 - assuming the relationship direction is one-to-many from the Parent (one) to the Child (many), you should be patching the LookUp column, and not the TPS UID field (which I am assume is the Dataverse GUID based on the error message).

I would suggest you remove "TPS UID" from your Patch statement and replace with the actual name of your LookUp field.

'Your LookUp Column': NewCloneRecord.TPS,