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

(0) Share

Report

Posted on by chinda

126

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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
chinda 126 on at

Like (0)

Report
Copy link

Link copied!

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

What am I still doing wrong?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

chinda 126 on at

Like (0)

Report
Copy link

Link copied!
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?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@chinda

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

Was this reply helpful? Yes No
chinda 126 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No