Power Apps Form - How to edit SP list item in form from gallery and save it as a new SP list item

(0) Share

Report

Posted on by mesan123

Dear Power Apps gurus,

I would like to ask your advice for the following case:

1. I have an app with a standard form created from a predefined SP list

2. Besides the new Form records submitted to SP list I have also included a gallery containing all SP list items (previously submitted forms). I would like to give users a chance to go to app, get existing SP list item/record (previously submitted app record) and make subsequent changes if needed.

Details:

- a gallery with search where I find the item to be modified

- if arrow is clicked it takes me to the form with pre-filled fields from the gallery

Now I would like to change a couple of fields and submit the form as a new one. If I do it now, the original SP record is overwritten/updated by the changes I made.

Could you please advise how to save edited form as an new record in SP list?

Thanks a lot for your comments.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@mesan123

If you want it to be a new record, then set the Item property to:

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

This will create a duplicate of the record you are editing.

I hope this is helpful for you.

Was this reply helpful? Yes No
mesan123 85 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes,
Using the code Patch(gal_Existing_Form.Selected, {ID:Blank()}) the new record is created but if I do changes in the form the changes are disregarded and the new SP list item is created as a duplicate of the original item. But I would need to save the form with edits.
Thank you for your help.

Was this reply helpful? Yes No
mesan123 85 on at

Like (0)

Report
Copy link

Link copied!

I am just thinking if there is a way how to only prepopulate the fields in the new form from the gallery (original form), then change whatever is needed and submit it as a new record, this would help..
Thank you

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

Like (0)

Report
Copy link

Link copied!

@mesan123

Yes, the original formula I provided will give you the capability to select a gallery record and then have that appear in the EditForm, make changes, and then when saved, it will create a new record with all of the edits made.

I am not sure if you are asking that not only does it create a new record, but that it is supposed to also edit the existing record as well !?!? I am not sure what issue you are having...please explain.

Was this reply helpful? Yes No
mesan123 85 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes
Sorry for the confusion. What I wanted to say is that Patch(gal_Existing_Form.Selected, {ID:Blank()}) in my case creates the new record which is 100% identical with the original one even though changes have been made in the EditForm i.e. all the edits are disregarded and the original form is duplicated in SP list with a new ID.

Was this reply helpful? Yes No