How do I create a copy of a record from an Editform

(1) Share

Report

Posted on by UniDeen22

Hi All,

I have an App to create Permits for my Organisation, linked to a SharePoint List. As you can see in the image attached all the saved forms created are shown in a DataTable. I've created a Button(Copy Item) to duplicate the selected item in the DataTable. But The code I used dosent work just produce a blank record in my SharePoint list. Does anyone know what I should do ?

Categories:

General Questions

Screenshot 2024-0...

All responses (2)

Answers (0)

Suggested answer

dmb 12 on at

Like (0)

Report

How do I create a copy of a record from an Editform

Use Patch, although Collect should also work if you don't need to handle subsequent patching of the created record and image columns.

Remove the system columns that will fail the operation. For Dataverse those columns are:

- GUID and CreatedOn as they are generated by the platform and invalid upon create;

- Status and Status Reason in case your gallery is not filtered to show only Active records. Records in Dataverse cannot be created in Inactive state so you will need to send those in another update request. The Patch function returns the created/modified record, so we will use it to patch it.
For SharePoint, you should check "invalid for create" columns by yourself.

The Table and DropColumns expressions below are used just to remove the properties from the selected record object. Making those fields 'null' (with Blank expression) won't work as it is not the same as making them 'undefined'.

Patch(

<YourTable>,

Patch(

<YourTable>,

First(

DropColumns(

Table(Gallery1.Selected),

<YourTableGuidColumn>, 'Created On', Status, 'Status Reason'

)

)

),

{Status: Gallery1.Selected.Status, 'Status Reason': Gallery1.Selected.'Status Reason'}

)
Suggested answer

MichaelFP 1,831 Super User 2025 Season 1 on at

Like (0)

Report
How do I create a copy of a record from an Editform

try to using the patch like this

Patch('Permit App List', Defaults('Permit App List'),{});

inside the brackets you put the fields that you want to created the record.

In the way that you trying to do it, you are merging data and after setting only the data with ID as Blank(), generating a blank data.

Please read the documentation for more details; Patch function - Power Platform | Microsoft Learn