Answered

How to edit multiple forms in app without creating a new form submission

(0) Share

Report

Posted on by shgall02

I am using SharePoint Custom Forms. I have 2 forms on a screen that I need to submit to the same data source. I have used the Patch function and it works as far as submitting the forms together, but I am not able to Edit the current form. When I click the submit button after editing my form, it creates a brand-new form. Below is my code for OnSubmit.

Patch('Sharepoint Form',Defaults('Sharepoint Form'),Submitter_Info.Updates, IT_Form.Updates));

Here is my OnEdit in SharePointIntegration and also my Edit Button OnSelect:

EditForm(Submitter_Info); EditForm(IT_Form);

I am not using a Gallery. I want to make this form as simple as possible to navigate for our users. I have added an ID field to both forms. What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @shgall02 ,

Defaults(<data source>) means create a new record.

So please try this:

If(Submitter_Info.Mode=FormMode.New&&IT_Form.Mode=FormMode.New,Patch('Sharepoint Form',Defaults('Sharepoint Form'),Submitter_Info.Updates, IT_Form.Updates), Patch('Sharepoint Form',SharePointIntegration.Selected,Submitter_Info.Updates, IT_Form.Updates))

Best Regards,

Wearsky

Was this reply helpful? Yes No
shgall02 26 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked! I am forever grateful! Than you so much 😁

Was this reply helpful? Yes No
Lucas_Santana_ 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-xiaochen-msft

I tried to use your code but I found a problem in sharepointintegration.selected.

My code doesn't recognize it. Could you please help me?

Was this reply helpful? Yes No
shgall02 26 on at

Like
a
(0)

Report
Copy link

Link copied!
In your app do you see SharePointIntegration?
If not, this code won't apply. If you do, in each of my form Items, I have
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('Sharepoint Form'),SharePointIntegration.Selected)
Hopefully, this works for you and here is a link with more info on SharePointIntegration:

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration

Was this reply helpful? Yes No