cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
eenochs
Level: Powered On

Multipage Form Issues

I am working on creating a multipage form with a Large SharePoint list.  I have 5 pages with a Patch/Submit button at the end.  When i submit the form its only submitting the last page of info.  Not sure where i'm missing info.  

 

The Form Datasource is set for all three pages.  Each page is called FormPage1, 2, 3, 4, 5.

The Form Item field is set to Defaults(datasource)

Each button to go to the next page has the following code:  Navigate(FormPage2, Fade)

Submit button on the last page is set to "Patch(InternationalCareerSurvey, Defaults(InternationalCareerSurvey), EditForm1.Updates; EditForm2.Updates; EditForm3.Updates; EditForm4.Updates; EditForm5.Updates); Navigate(Screen1, Fade)"

 

The problem i have is when i submit the form its not bringing the data from the previous forms/pages. 

3 REPLIES 3
Super User
Super User

Re: Multipage Form Issues

@eenochs 

Hi there.  I have not seen an approach to multi-page forms like the one you are using.  Therefore, I'm not sure why you code does not work.  I would prefer to give advice on how to make your current idea work, however, I must suggest a different approach instead.

 

Is all of your data stored in the same table?  If yes, there is no need to create multiple forms and screens.  You can use a single screen and show/hide datacards when the user clicks a button to goto the next section.  It will appear like there are multiple screens but there aren't.  An advantage of doing things this way is your only have to submit the form once.

 

Put this code in the OnVisible property of your screen

Set(currentPage,1)

 

Then for every datacard you want showing on Page 1 you must put this code in the visible property.  For any datacards showing on other screens use the appropriate page number

currentPage=1

 

Create a button to browse to the next page with the following properties.  We will say for this example there are 3 screens.

Text: "Next Page"
OnSelect: Set(currentPage,Min(currentPage+1,5)
Visible: currentPage<>5

 

Create another button to browse to the previous page with the following properties.

 

Text: "Previous Page"
OnSelect: Set(currentPage,Max(currentPage-1,5)
Visible: currentPage<>5

 

 

Finally create a button to Submit the form with the following properties

Text: "Submit Form"
OnSelect: SubmitForm(your_form_name_here)

 

Let me know if you have questions.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." 

Community Support Team
Community Support Team

Re: Multipage Form Issues

Hi @eenochs ,

Do you want to update multiple forms?

Could you tell me

1)whether all the forms is used to update one record (different forms include different fields)

2)or one form is used to update one record (update multiple records)?

 

If you want to do (1), please do not display repeated field in different forms. For example: field1 only displays in form1, other forms do not have field1

Because the next page field's data will write over the previous field data.

In this situation, your listed formula is right.

Patch(InternationalCareerSurvey, Defaults(InternationalCareerSurvey), EditForm1.Updates; EditForm2.Updates; EditForm3.Updates; EditForm4.Updates; EditForm5.Updates); Navigate(Screen1, Fade)

 

If you want to do (2), you could use this formula:

SubmitForm(EditForm1);SubmitForm(EditForm2);SubmitForm(EditForm3);SubmitForm(EditForm4);SubmitForm(EditForm5)

 

 

 

Best regards,

 

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
eenochs
Level: Powered On

Re: Multipage Form Issues

The form would be submitting one record.  Any updating would be done through the list.  So this form is just submitting their information. 

 

 

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,049)