web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps "Submit" after "Edit A...

Power Apps

Answered

"Submit" after "Edit All" creating a new item in SharePoint

(0) Share

Report

Report

Posted on by ebraga

118

Hello Friends,

I'm having an issue with SharePoint integration and I can't find a solution that is specific to my needs.

When opening the PowerApp in the SharePoint list to make edits ( via "Edit All"), my submit button creates a new item instead of updating the forms. I have more than one form on the screen to submit.

My submit button formula is:

Patch('PCAR- Testing',Defaults('PCAR- Testing'),Form4.Updates,Form5.Updates,Form6.Updates,Form7.Updates,8.Updates)

If I'm using .Updates, I'm not sure why it is creating a new item. I am also very NEW at powerapps. Any and all help is appreciated.

Thanks! & Happy Holidays Everyone

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

The problem is in your Patch statement on the submit. When the second parameter of a patch statement is set to defaults(datasource) it will always create a new record. To update an existing record you need to supply something that selects the specific record you want to update as the second parameter. This is usually a Lookup.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ebraga ,

The major source of conflict is Defaults('PCAR- Testing'). Defaults function in Patch is to create a new record. Reference: Patch .
You have to add a condition into Submit button to check if the form is in Edit or New mode. Put the following codes to OnSave property of SharePointIntegration.

Patch('PCAR- Testing',If(SharePointForm1.Mode=FormMode.Edit,SharePointIntegration.Selected,SharePointForm1.Mode=FormMode.New,Defaults('PCAR- Testing')),SharePointForm1.Updates);ResetForm(SharePointForm1); RequestHide()

Sik

Was this reply helpful? Yes No

Join the conversation