cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
slan2018
Level: Powered On

Issues with submitting forms to Sharepoint

I've created a very simple app with forms from scratch and my data source is a Sharepoint list. I am getting the "There was a problem saving your changes. The data source may be invalid" message when I try to SubmitForm at the end. I'm scratching my head as to what I'm missing here, but I'm sure it's something simple.

 

I have 7 screens and 6 forms (one on each screen but the last). All have the same data source (SP List). Only 1 field is required. This is essentially my form set up for each of the 6 forms. Also on each form i have the DataSource set as my SP list name and the Item set as Defaults('listname')

image.png 

 

I've granted everyone in my organization access to both my SP list and my App. 

image.pngimage.png

 

When I get to the screen before the confirmation I have a save button that has the OnSelect Property set as this: 

image.png

When I click it, I get the error. image.png

 

 

I'm sure i'm missing something simple. Any thoughts? 

Thanks,

Sara

1 ACCEPTED SOLUTION

Accepted Solutions
slan2018
Level: Powered On

Re: Issues with submitting forms to Sharepoint

Thanks everyone, I was able to successfully use the Patch OnSelect

14 REPLIES 14
Super User
Super User

Re: Issues with submitting forms to Sharepoint

Hi @slan2018 

I don't believe that you can submit multiple forms in one statement.   Typically you would need to have a separate SubmitForm() function for each form.  in the English version it would be

SubmitForm(form1); SubmitForm(Form2); etc.

 

There may be a problem with your design.  If all of your forms are set to New and you are using the same datasource for all of the forms, you will create new records for each one of your forms rather then creating one record that contains all of the fields on your forms.  If each form is supposed to add data to a single record, you will need to create the record with the first form (Mode set to New) and then edit that record by specifying it as the Item property of the subsequent forms.  

slan2018
Level: Powered On

Re: Issues with submitting forms to Sharepoint

Thank you! I'm sure that is part of the issue! Unfortunately I'm still getting the same data source error still. 

image.pngimage.png

Super User
Super User

Re: Issues with submitting forms to Sharepoint

Hi @slan2018 

You may want to take a look at how @murali and @Meneghino  solved a similar problem in the following thread. https://powerusers.microsoft.com/t5/General-Discussion/Save-data-from-multiple-screens-to-submit/td-...

v-tkmasz
Level: Powered On

Re: Issues with submitting forms to Sharepoint

Hi @slan2018 ,

Could you check if you also get this error when you submit a single Form?

 

There is a bug since Aug 13 affecting a number of apps that also gives this error - link to my incident https://icm.ad.msft.net/imp/v3/incidents/details/140571669/recommendations 

Community Support Team
Community Support Team

Re: Issues with submitting forms to Sharepoint

Hi @slan2018 @v-tkmasz ,

It seems that there's some problem about submitting form to sharepoint list.

Could you tell me your PowerApps Version, App ID and Session ID?

Could you describe more clearly about the problem ? (show me more details)

I will report this to my product team.

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-tkmasz
Level: Powered On

Re: Issues with submitting forms to Sharepoint

Hi @v-yutliu-msft @slan2018 

Thank you so much for your reply -the situation is getting quite dire. 

 

App ID: 2199a078-6059-435c-acd8-9cff163232d9

Session ID: a1399702-8772-45ee-83ac-3f1c21c32a69

PowerApps version of currently published App is 3.19071.13  - As part of troubleshooting i tried rolling back versions and republishing (but there was no difference) - attached snip with other versions used. 

 

We're experiencing an intermittent issue when a form is being submitted to a SharePoint list. Ocassionally data is not being saved to the list and most of the times we will see the following error message: 'There was a problem saving your changes. The data Source ay be invalid' (snip of error & app attached). 

 

This issue has been ongoing since Tuesday August 13. 

 

I've experienced something similar in May & June - but in those cases it seemed to have been triggered by publishing a new version of the app. At the time rolling back version stopped the issue. It's not the case now. 

 

Please let me know if I can provide any additional details, or maybe we can jump on a quick call?

Tomasz Kasprzyk

v-tokasp

 

 

 

 

slan2018
Level: Powered On

Re: Issues with submitting forms to Sharepoint

Hi, yes, I am receiving the error with just one Form

slan2018
Level: Powered On

Re: Issues with submitting forms to Sharepoint


@Drrickryp wrote:

Hi @slan2018 

I don't believe that you can submit multiple forms in one statement.   Typically you would need to have a separate SubmitForm() function for each form.  in the English version it would be

SubmitForm(form1); SubmitForm(Form2); etc.

 

There may be a problem with your design.  If all of your forms are set to New and you are using the same datasource for all of the forms, you will create new records for each one of your forms rather then creating one record that contains all of the fields on your forms.  If each form is supposed to add data to a single record, you will need to create the record with the first form (Mode set to New) and then edit that record by specifying it as the Item property of the subsequent forms.  


Hi @Drrickryp !

I am trying to follow your suggestions above. I have Form 1 set to New. On subsequent forms 2-6, what would I change the "Item" property to specifically? Prior I had it as Defaults('SP list name'). Above you mention specifying Form 1 (I believe) in the item property but I'm not sure exactly what to put there. 

Super User
Super User

Re: Issues with submitting forms to Sharepoint

Hi @slan2018 

You are not the first person to encounter this problem and there are many ways to solve it.  PowerApps forms are designed to deal with a relatively small number of fields.  When you have to enter a large number of fields in a single record, it may be better to create your own forms as these will be much more flexible.  Please check out @Meneghino  blog post https://baizini-it.com/blog/index.php/2017/09/28/powerapps-101-create-your-own-forms/ for a flexible way to deal with more complex data entry issues. If you follow his logic, you will also learn a great deal about how PowerApps works by going through the process. 

 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 199 members 5,750 guests
Please welcome our newest community members: