SubmitForm not always working

(0) Share

Report

Posted on by Jakegolden

151

Hello,

I am currently experiencing a very troublesome issue with the SubmitForm action.

To start with I have a SharePoint list that is housing my data and I have multiple forms that are tied to this sharepoint this. The user will select a specific SharePoint record on the homepage of the app from a gallery. This record data will then display across my forms (EditForms).

For example - I have a SP record that has 12 columns. 4 columns are on tied to 1 form each. So 3 forms total.

The forms may already contain data based on the record being selected from the gallery.

Once the forms have been filled out I use a button to Submit the forms to the current record being updated.

Example - SubmitForm(Form1);SubmitForm(Form2);SubmitForm(Form3)

Anyways, this method works like 60% of the time. Sometimes I submit the forms and all the data is stored. Other times, I submit the forms and no data is stored.

Not sure what to do.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Jakegolden ,

Your approach is not quite good. Imagine that you send to the server almost simultaneously 3 patch requests of the same record. Actually There is no time to execute correctly all 3 requests. To avoid that, you need to collect all the data in one form.

So, my proposal to you, is to modify Form3 (the last one to be completed chronologically speaking) and add all 12 columns. Modify the Update property of Datacard controls with values added in Form1 or Form2 to:

Form1.Updates.NameOfTheColumn

and set the visible property to false.

The submit button should have on OnSelect property only:

Submit(Form3)

as the Form3 contains all the necessary data.

Hope it helps !

Was this reply helpful? Yes No
Jakegolden 151 on at

Like (0)

Report
Copy link

Link copied!

@gabibalaban

Thank you for the quick reply. I was afraid of this being the case. Reason for the separations of the forms is because I actually have 13 forms. each form contain about 30 data cards. I separated the forms to keep the user from needing to have an extremely long 1 form and having to continuously scroll down.

So if I am understanding correctly, basically I could keep the 12 prior forms, create the 13th form to contain EVERYTHING, follow your procedures with Updates, and this should work?

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!

Yes, it will work for sure ... There is no many things to change, only add in the last form all column you need to be update and the Update property to each other based were the data resides (and of course hide the ones that are not necessary in the last form).

Was this reply helpful? Yes No
Jakegolden 151 on at

Like (0)

Report
Copy link

Link copied!

@gabibalaban Thank you very much. I will begin implementation now.

Was this reply helpful? Yes No