Create NEW record when existing record is edited

(0) Share

Report

Posted on by JonathanDavey1

Hi,

Using either Dataverse or SP as datasource.

How do I create a NEW record (with changes) when editing an existing record?

Or put another way, how do I retrieve the contents of an existing record, whereby the SAVE ("SubmitForm") function thereafter creates a NEW record with the same contents + any changes.

I have 45 Columns (fields), so something that doesnt require coding each datacardvalue would be preferred.

Thanks,

Jonathan

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @JonathanDavey1 ,
You can use below formula in OnSelect property of duplicate button on your screen -
Patch(SPListName, Defaults(SPListName), Form1.Updates)
Assumptions -
SPListName is Sharepoint List name or data source name
You are using a form control in Edit Mode named "Form1"

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@JonathanDavey1

Avoid using a Patch function on a form as it breaks the form functionality and features.

In your case, look to the Item property of your form and keep your form in Edit mode all the time.

If you have an existing record (let's say from a Gallery and on SharePoint), then the following formula in the Item property will provide what you want:

Patch(yourGallery.Selected, {ID: Blank()})

The key here is (no pun intended) the Primary Key column of your data source. If it is Blank, than SubmitForm will know that it is a new record and create it. If it has a value, then it will update.

In the case of DataVerse, you do the same thing, but you need to determine the name of the primary key column (the unique identifier column) of the list and then just substitute it into the above formula.

I hope this is helpful for you.

Was this reply helpful? Yes No
JonathanDavey1 69 on at

Like (0)

Report

Thanks Randy, sorry when you say formula the "Item" Property to: Patch(yourGallery.Selected, {ID: Blank()})
Can you be explicit please, is it the EditForm or the Datacard or the SubmitForm(EditForm1) OnSelect property.

Thanks
Jonathan

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@JonathanDavey1

Only the Form will have an Item property. That is the one to change.

If you are not sure what it should be, then what is the current formula in the Item property?

Was this reply helpful? Yes No
JonathanDavey1 69 on at

Like (0)

Report

EditForm1 - Item - BrowseGallery1.Selected
Changed to: Patch(BrowseGallery1.Selected, {SimpleTest_Records: Blank()})
Where "SimpleTest_Records" is the Unique Identifier for the DV Table.

Throws an error (as attached).

Screenshot 2022-1...

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@JonathanDavey1

What is SimpleTest_Records? Is this for Dataverse?

Was this reply helpful? Yes No
JonathanDavey1 69 on at

Like (0)

Report

@RandyHayes
Yes and the name of primary key column (as attached).

Screenshot 2022-1...

Was this reply helpful? Yes No