cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chinda
Helper III
Helper III

Need Help Submitting Form that has multiple pages (ResponseCollect or SubmitForm)

Hello All,

 

I am currently making a form that collects data across multiple pages, and is connected to a Sharepoint data source. 

 

Attached is a photo of the final page of the form, which collects data on 5 pages (EditForm1 - EditForm1_4) before giving the end user the option to submit.

 

What is wrong with my current formula? How do I fix it t submit the data from all of my pages? Looking for guidance

1 ACCEPTED SOLUTION

Accepted Solutions

Hey  @Drrickryp  I removed the SubmitForm but am still getting the same error. Here is my code: 

Patch(
splist,
Defaults(splist),
EditForm1.Updates,
EditForm1_1.Updates,
EditForm1_2.Updates,
EditForm1_3.Updates,
EditForm1_4.Updates
)

 What am I doing wrong?

View solution in original post

7 REPLIES 7
Drrickryp
Super User
Super User

Patch(splist, Defaults(splist),EditForm1.Updates,EditForm1_1.Updates,EditForm1_2.Updates,...etc)

Could you explain what this code does? Also, I still have the following error:

 

What am I still doing wrong?

Remove the SubmitForm(). Patch does the same thing.

Hey  @Drrickryp  I removed the SubmitForm but am still getting the same error. Here is my code: 

Patch(
splist,
Defaults(splist),
EditForm1.Updates,
EditForm1_1.Updates,
EditForm1_2.Updates,
EditForm1_3.Updates,
EditForm1_4.Updates
)

 What am I doing wrong?

Drrickryp
Super User
Super User

@chinda 

You need to replace splist with the name of your sharepoint list.

chinda
Helper III
Helper III

Awesome that worked, how can I incorporate a Navigate() as well to go to the final success screen @Drrickryp ? 

Drrickryp
Super User
Super User

@chinda 

From Matt Deveney's blog https://www.matthewdevaney.com/power-apps-patch-function-error-handling/ 

 

Patch(....);  //Put your patch statement here
If(
     // check if there were any errors replace splist with your actual list name
     !IsEmpty(Errors('splist')),
     // if true, show any error message
     Notify(
         "Submission failed",
         NotificationType.Error
     ),
     // else, go to success screen
     Navigate('Success Screen')

See the blog for the formula for a more detailed error message.

 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,979)