Submit a Multi Custom form to SharePoint list

[MRauscher]

Hi everyone,

I wanted to make PowerApps an input facility for a SharePoint list.
I distributed the form on several FormScreens. So that the user can fill the form up more clearly. Unfortunately, only the first form screen (SubmitForm (SharePointForm1)) is transferred. There is no AND linking in PowerApps.
I've tried it with &&, but unfortunately no success

SubmitForm (SharePointForm1) && SubmitForm (SharePointForm1_1) && SubmitForm (SharePointForm1_2)

Then I tried it with patch, which unfortunately does not work or I have set the order for it wrong.

Patch (GDPR; SharePointForm1; SharePointForm1_1; SharePointForm1_2; SharePointForm1_4; SharePointForm1_5; SharePointForm1_6)

Is there no solution for that?

The last thing that occurred to me was that you could hide the SharePoint form. For this you would have to rebuild the fields and then let fill the mold. For SubmitForm then the whole form should be sent. As far as the plan.
Is this possible?

Greats

Michael

[Jeff_Thorpe]

Have you tried:

SubmitForm(SharePointForm1); SubmitForm(SharePointForm1_1); SubmitForm(SharePointForm1_2)

FYI: if the language you are using (ex: German) uses ";" instead of "," in formulas then in my example the ";" should be ";;". The only reason I mention this is because your Patch() example is using ";" where "," are normally used.

[v-xida-msft]

Hi @MRauscher,

Do you want to submit multiple forms from multiple screens into a one entry of your SP list?

Or submit multiple forms from multiple screens into multiple different SharePoint lists?

If you want to submit multiple forms from multiple screens into multiple different SharePoint lists, I agree with @Jeff_Thorpe's thought almost, please take a try with the following formula:

SubmitForm (SharePointForm1);SubmitForm (SharePointForm1_1);SubmitForm (SharePointForm1_2)

If you want to submit multiple forms from multiple screens into a one entry of your SP list, I think the Patch function could achieve your needs. The user @PhilatBaker has faced similar issue with you, please check the response I made within the following thread:

https://powerusers.microsoft.com/t5/Connecting-to-Data/Submitform-button-not-publishing-data/m-p/122...

In addition, please check and see if the following thread would also help in your scenario:

https://powerusers.microsoft.com/t5/General-Discussion/Submitting-multiple-forms-to-a-single-table/t...

More details about the Patch function in PowerApps, please check the following article:

Patch function

Best regards,

Kris

[MRauscher · Accepted solution]

Thanks guys for your tips.
Unfortunately they did not bring the desired success.
The path via SubmitForm had not been bad. But unfortunately did not always update all items or just submitted the one form. I think it was because of the caching of data in PowerApps.
The second way through Patch would have been a tedious one. In patch you can not put whole forms together. One would have to query each individual field of the list and put it together. This is very tedious but probably would bring the desired success.

Did it now with tabbed forms. Went quite fast and also brought the desired result.
Here is a link:https://youtu.be/NdiQ802dG3E

thx

Michael