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.
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
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
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."
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:
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand