Unanswered

Multipage Form Issues

(0) Share

Report

Posted on by eenochs

147

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

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

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
eenochs 147 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MShelnutt 381 on at

Like (0)

Report
Copy link

Link copied!

@v-yutliu-msft I am not sure why the OP did not respond, but I have a question regarding your solution. You confirmed the OP had the correct formula, however, this does not explain why the OP was having the stated issue. If the formula is correct, why was it only submitting the last page and not the previous?

I am trying to do the same thing- a 3 screen form writing to the same SharePoint list, so I am very interested in this formula.

Was this reply helpful? Yes No