Answered

Powerapps edit item from sharepoint list and saving back to sharepoint as new item

(0) Share

Report

Posted on by michalison

108

I am just learning Powerapps so need some advice. I have created a edit form and use a dropdown box to pull in an item from sharepoint which can then be edited (Risk Assessment Form), this all woks fine, but when I save it modifies the existing item on the sharepoint list when I want to add it as a new item, (to build up can ayone help me here. Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

mdevaney 29,989 Moderator on at

Like (0)

Report

@michalison

Put the Edit Form in New Mode by putting this code in the OnVisible property of the screen

NewForm(Form1)

Now when you navigate to the screen and submit an entry it will create a new record

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
michalison 108 on at

Like (0)

Report

Thank you I tried that and it still doesn’t work. I am pulling a risk assessment in from a sharepoint list which I want users to be able to edit then save back to the list as a new item – what it does is overwrite the item in the list instead of adding a new item. Many thanks

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@michalison
Have you tried changing the DefaultMode of the Form to this code:

FormMode.New

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
michalison 108 on at

Like (0)

Report
If I do that all the text disappears. I have a dropdown box where the users select the Risk Asessment - it then populates the fields with the text for the Risk Asessment, I need users to be able to make any changes they need for their own department then resave as a new risk assessment. I cannot get it to do this as it just overwrites the original risk assessment pulled in from the drop down box

Was this reply helpful? Yes No
Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@michalison
Have you tried doing a PATCH to create a new record based off of an existing record?

Patch(your_datasource_name, Defaults(your_datasource_name, Form1.Updates)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

michalison 108 on at

Like (0)

Report

Thank you so much for your time yes this work perfectly I am very grateful

Was this reply helpful? Yes No