Update form rather than great new item when editing the item created in gallery

(0) Share

Report

Posted on by AB21

Hi all,

I have an app where it allows you to check/edit the details of a current item within Sharepoint:

Screenshot 2022-10-14 at 10.30.43 AM.png

However this takes you back to the form with the details but once I submit again this shows a new item in the gallery/Sharepoint where as when I edit I want to update the item.

Screenshot 2022-10-14 at 10.31.24 AM.png

I also want to keep the ability to create new items too!

Any ideas?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

AhmedSalih

6,680 Moderator on at

Like (2)

Report

Copy link

Link copied!

Hello, @AB21, Edit Form Control has three modes: Edit, New and View. In your use case, you need to use the Edit and New Mode. On the Screen that you have shared, check the OnVisible property of the screen and see what mode is set for the form.

To only Update records, Form must be on Edit Mode and the Item Property of the Form is set to your Gellery.Selected.
To create new records, the Form must be in New Mode.
Form should have the correct Data Source.
No need to use the patch formula if you are using the right mode. Just use SubmitForm(FormName) function.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

AB21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AhmedSalih

Thanks for this, I want to be able to submit on this page: ( Repair log form)

But edit the current item/update the record on this page: (Repair log details)

Both pages have no OnVisible property
What do I need to do in my situation?
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AB21

If you want to use Patch to perform modifications instead of adding features, you need to use the formula in the item property of the form instead of defaults('Repair log') in the second parameter of the Patch function.
But as @AhmedSalih said, you don't really need to use the Patch function.
You just need to use the SubmitForm function on the Onselect property setting of the submit icon.
EditForm, NewForm, SubmitForm, ResetForm, and ViewForm functions in Power Apps - Power Platform | Microsoft Learn

Best Regards,
Levi