Answered

Power App is not submitting one column to Sharepoint

(1) Share

Report

Posted on by gstredny

134

I have built a very basic Canvas app to submit information to a sharepoint and for some reason the last multiline text box will not submit the information to the sharepoint. I have 4 other multiline text boxes that are exactly the same and they work fine. But this one box will work like 1 every 50 submissions. It's very odd.

My update for the data card is the correct box (DataCardValue13_3.Value) and the default is ThisItem.NewBusinessKeptComments which is the correct column name in the sharepoint. I get no errors from Power Apps either. The DataCard value dropdown is Parent.Default.

Like I said this works for all my other multiline text boxes, but just randomly stopped for this last box. I have deleted the field and re-added, also tried deleting the column in sharepoint and re-added. I added a new screen and tried submitting and even tried adding a new text input box to submit and still would not consistently post to the Sharepoint.

My submit button is this:

SubmitForm(Form1_2); Navigate(Screen1); Set(CurrencyValue,Blank()); Refresh('Advanced Technical Training')
 
Any ideas would be greatly appreciated!!

Categories:

Building Power Apps

I have the same question (2)

All responses (3)

Answers (1)

Sort by

gstredny 134 on at

Like (1)

Report
Copy link

Link copied!

Well I figured it out. It was something with those DataCard multiline boxes. I changed them to RichTextEditor boxes and those work!

Was this reply helpful? Yes No
gstredny 134 on at

Like (1)

Report
Copy link

Link copied!

The issue actually appears to be the inputs that say "Preview" that causes issues. You have to use the classic.

Was this reply helpful? Yes No
Verified answer

ivan_apps 2,189 Moderator on at

Like (2)

Report
Copy link

Link copied!

Glad you figured out a workaround!

If I could give you any other advise is to not Navigate() directly after a form submit. If your form submit fails or succeeds, you have navigated away so you don't see it. SubmitForm() should generally be the last thing your button press does, add everything else to the form's OnSuccess or OnFailure events so that you let the async processing work and then react on the result.

Perhaps the form submission is failing, if you chain your navigate to form success you may see the error. Add Notify() to alert you of changes. Form.LastSubmit will then let you know what the pushed values are, so you can check to see if your multiline succeeded, and perhaps do a Patch() in case it didn't.

Last troubleshooting advise is to run the "Monitor" to see the network traffic and see if you see any failures.

Good luck!

Was this reply helpful? Yes No