Answered

Review Form before Submit to Sharepoint

Like (1) Share

Report

Posted on 16 Jan 2020 20:32:15 by tperry

I am creating an app that has a form that the client wants to be filled out, then sent to a different page for review before submitting the form to the Sharepoint List, then have a success page that displays some of the information in the form so the user knows it was submitted.
Diagram:
Form --> Review --> Success

How do I save the data from the form to be displayed on a preview page before it gets submitted to Sharepoint?

I considered saving the form to a collection, but it seems a form can only have one data binding?

I also considered changing the "DefaultMode" of the form from "Edit" to "View", but this doesn't save any of the input values to be displayed in "View" mode.

I can provide more info if needed. Sorry, I am very new to PowerApps.

Categories:

Connecting to Data

Connectors

All responses (5)

Answers (2)

martatracik 297 on 28 Mar 2023 at 10:07:16

Like (0)

Report
Re: Review Form before Submit to Sharepoint

hi @v-yutliu-msft Phoebe, thank you for the above solution. i have just one problem, my Form is divided between different screens, so to submit it i was using Patch function:
Patch( Requests, varFormData, Form1.Updates, Form2.Updates, Form2_1.Updates, Form3.Updates, Form4.Updates, Form5.Updates );
now i would like to add that preview view, as there are many questions, and we would like to ensure that users are 100% sure what they select. What should i put in Items in Form in Summary screen? Patch function works. just updates doesnt work either. thank you 🙂
ChrisS81 134 on 13 May 2022 at 02:44:33

Like (0)

Report

Re: Review Form before Submit to Sharepoint

@v-yutliu-msft I understand that this is a very old post, but thanks for the response. Is there a reason why attachments don't seem to submit to the sharepoint list doing this method? I tried this and everything works except attachments do not display nor does it submit to the List.
tperry 44 on 21 Jan 2020 at 17:26:04

Like (0)

Report

Re: Review Form before Submit to Sharepoint

This was the perfect solution!
Thank you so much.
Verified answer

v-yutliu-msft on 17 Jan 2020 at 09:38:17

Like (3)

Report
Re: Review Form before Submit to Sharepoint

Hi @tperry ,

Do you want to insert a display screen before you submit?

I've made a similar test for your reference:

1)in edit form screen

insert an edit form and a button

set the edit form's datasource: tablename

set the button's OnSelect:

Navigate(Screen4)

2)in display form

insert a display form, two buttons

set the display form's data source: tablename (the same as edit form)

set the display form's Items: (the edit form's name)

Form3.Updates

set the back's button's OnSelect:

Navigate(Screen3)

set the submit button's OnSelect: //submit the edit form

SubmitForm(Form3)

Then, after you fill in data in edit form, you could click the view button. You could view your data in a display form, if you want to make any change you could click back button to back to the edit form. If you do not want to make any change, you could click the submit button to submit the edit form's data.

Please do not change the edit form's mode to view.If the edit form's mode is view,submitform function will not work for the form.

Best regards,
Verified answer

poweractivate 11,078 Most Valuable Professional on 16 Jan 2020 at 22:09:47

Like (1)

Report

Re: Review Form before Submit to Sharepoint

@tperry

No need to necessarily "Save" anything between anywhere.

On another screen (call it ReviewScreen), make another form that is set to DisplayMode.View for the FormMode property.
For the Item property, make it match the same Item as that on your Edit form (YourFormScreen) - using perhaps a variable - for the whole Item not just for individual fields.

See if general approach above helps you.