How to Submit Form which are splitted in multiple screen

(0) Share

Report

Posted on by justlearner1

Hi All

i have splitted Sharepoint From in to 4 screens and added submit button in all 4 Screens..

here user will use there Record only .

after submitted the form should display as editform.without created as New one.

onscreen 1 :

on Submit button : i used SubmitForm(Form1)

on Form1 Sucess: Set(varLastSubmit,Form1.LastSubmit)

on Form1 Item: If(!IsBlank(varLastSubmit),varLastSubmit)

the above code is working for 1 screen : after submit ,it is display editform.

but same code not working on other screens, where i changed Form1 as Form2,Form3&Form4.. in Sp it creating more rows.

how to fix it ?

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Checkout this Video by @RandyHayes

https://www.youtube.com/watch?v=2E4FXNPLVXw

And this one by @RezaDorrani

https://www.youtube.com/watch?v=9gI9OscTLD0
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

in this videos, there is only 1 submit button, but my case is different.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @justlearner1,

Do you want to submit multi forms using several buttons?

Could you please share a bit more about the scenario?

Actually, if you have split forms, the best method is using a single one button and refer to Form.Updates to submit all the forms. To this configuration, you could directly set the submit button OnSelect as below:

Patch(datasource,Defaults(datasource),Form1.Updates,Form2.Updates,Form3.Updates,Form4.Updates)

If each of your form screen has a submit form, I think you should refer to the Form.LastSubmit in the left three submit button OnSelect property.

Set the OnSelect property of the second submit button as below:

Patch(datasource,Form1.LastSubmit,Form2.Updates)

Repeat this step for the left 2 submit buttons:

Patch(datasource,Form1.LastSubmit,Form3.Updates)
Patch(datasource,Form1.LastSubmit,Form4.Updates)

Please check if this could help you at some degree.
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

i tried 2 option by Adding Submit button in each screen with above formula.

when i click on submit button on Screen 1 ,it showing error message as
"The requested operation is invalid. Server Response: New Joiner Training list - Test failed: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold. clientRequestId: la3e4566-de84-4efb-80bf-Oa9dbbc593cf serviceRequestId: la3e4566-de84-4efb-80bf-Oa9dbbc5g3cf "
Note: Sharepoint list consists of 175 columns- splitted them between 4 screens with 4 submit buttons.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@justlearner1

Yes, please avoid using the Patch function on forms! It is first a waste of the form as you will be losing all of the functionality of the form - especially the error checking and record management.

As @zmansuri mentioned - check out my video on doing this properly first.

You will need to make sure in your case (since you are working with submit buttons on each screen) that you are keeping all forms in Edit mode and that you are working with one common variable between them all.

So, in your first form, the OnSuccess action should have Set(glbCurrentRecord, Self.LastSubmit)

The Item property of Form 2 should be glbCurrentRecord.

The OnSuccess of Form 2 should have the same formula as the Form1.

Now, it should be known that the ONLY value of the variable in this case is to pass the ID (that gets created in Form1) to the next forms. This way, when you submit Form2 and etc. it will be working with the existing record and not creating a new one.

And again, make sure that the forms are all in Edit mode and never issue a NewForm function. If you want form1 to be a new record, then you just need to set the glbCurrentRecord variable to the Defaults of your datasource. Now, I don't know enough about your app process to tell you exactly where to put that statement, it could be either when screen 1 is reached, or some button before that or just always on Form1 it is new. So, it's hard to say without knowing more.

Anyway, these steps above should get you what you need.

I hope this is helpful for you.
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

same error it is displaying ,when i clicked on submit button on Screen1: SubmitForm(Form1)
error message as
"The requested operation is invalid. Server Response: New Joiner Training list - Test failed: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold. clientRequestId: la3e4566-de84-4efb-80bf-Oa9dbbc593cf serviceRequestId: la3e4566-de84-4efb-80bf-Oa9dbbc5g3cf "

and also i added same code on screen2 on Sucess button as Set(glbCurrentRecord, Self.LastSubmit)
and on ITEM as : glbCurrentRecord & changed to edit mode..
when i click on navigate button , and clicked on Submit button SubmitForm(Form2) on Screen 2 .nothing is showing data ( no items to display)
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

i fixed the issue
in SP - people picker columns exceeds above 12, i reduced them to 10 and tried ,it is working..
but in Screen2 : when i keep it in edit mode, without clicking submit button on Screen1, if i navigate to Screen2 ( nothing is displaying)..
and it also creating duplicate records ,when ever i press submit button
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

i fixed the issue
in SP - people picker columns exceeds above 12, i reduced them to 10 and tried ,it is working..
but in Screen2 : when i keep it in edit mode, without clicking submit button on Screen1, if i navigate to Screen2 ( nothing is displaying)..
and it also creating duplicate records ,when ever i press submit button