Patching - Submit button

[jamesmdc1]

After Fixing the errors in code, Upon using the "submit" button in my app, I am prompted with this error in PowerApps

Code for the "submit" button 

Patch('Disciplinary Forms',Defaults('Disciplinary Forms'),{'Date Of Occurrence':DataCardValue4.SelectedDate,'Employee Name':DataCardValue2.Text,'Shift':DataCardValue3.Selected,'Reason For Discipline':DataCardValue5.Selected, 'Explanation':DataCardValue6.Text,'Machine Crash':DataCardValue7.Value,'Machine ID':DataCardValue8.Text,'Require Training':DataCardValue9.Value,'Action Taken':DataCardValue10.Selected,'Additional Notes':DataCardValue11.Text,'Employee Signature':DataCardValue12.Text,'Supervisor Signature':DataCardValue13.Text,'Operations Manager Signature':DataCardValue14.Text,'Human Resources Signature':DataCardValue15.Text});

If(!IsEmpty(Errors('Disciplinary Forms')),Notify(Concat(Errors('Disciplinary Forms'),First(Errors('Disciplinary Forms')).Message & " " & Column),NotificationType.Error),Notify("Record Saved Successfully",NotificationType.Success))

Data not landing in Sharepoint. 

[WarrenBelz]

Hi @jamesmdc1 ,

Firstly I have to assume: -

• You are getting no errors (red cross) on the formula itself
• You have no Required fields you are not writing to
• Permissions are correct
• You have made several attempts, after saving and re-opening to ensure it is not a temporary connection issue.

The next things to check are the field types - from your code, I assume: -

• Date Of Occurrence': Date/Time
• 'Employee Name': Text
• 'Shift': Choice ?
• 'Reason For Discipline': Choice ?
• 'Explanation': Text
• 'Machine Crash': Yes/No ?
• 'Machine ID': Text
• 'Require Training': Yes/No ?
• 'Action Taken': Choice ?
• 'Additional Notes': Text
• 'Employee Signature': Text
• 'Supervisor Signature': Text
• 'Operations Manager Signature': Text
• 'Human Resources Signature': Text

[jamesmdc1]

Hello @WarrenBelz 

 Thank you for the detailed response. Both assumptions are accurate. I’ll get better at posting, my apologies for the lack of details. 

• no errors in the formula 
• all fields are filled; some required 
• permissions are okay
• Ive been tinkering a few hours now and taking a break 

field types

• correct

Appreciate your time and feedback. I’m new to the PowerApps world and I suspect I’m missing something. I will post back any changes/advancements tomorrow. Next up, PDF functionality, approvals and Mail and maybe even signatures. Really excited about all the possibilities within powerapps. 

thanks! 

[WarrenBelz]

Hi @jamesmdc1 ,

OK - the next question is have you changed the Items of any of the Combo Boxes containing the Choice columns from the standard Choices(@ListName].FieldName) ? If so, which ones and what to ?

[jamesmdc1]

Hello @WarrenBelz 

All Fields were pulled in from the Sharepoint site. All Fields have been have been set to false for required. Same network error today. 

Choices([@'Disciplinary Forms'].'Shift')

Default - ThisItem.Shift

Choices([@'Disciplinary Forms'].'Reason For Discipline')

Default - ThisItem.'Reason For Discipline'

Choices([@'Disciplinary Forms'].'Action Taken')

Default - ThisItem.'Action Taken'

[leonsig93]

Hey not sure if related, but one of the reasons I get this issue is when I have an SPO field that is marked as required within SharePoint itself.

I noticed you are using a form so when you said you marked them as not required, did you mean within each Datacard in the PowerApps form?

If so, that only works if you use the SubmitForm function. Using Patch you ignore anything you did with the datacards since you end up referring directly to the input controls. Try adding another button and use the SubmitForm function and see if you run into the same problem.

So the OnSelect ends up being SubmitForm(yourFormName)

Just make sure that if you didn't include any other required fields within the form, you add them back in and mark their required property as false, then you can make them invisible so they don't interfere with your form.

[WarrenBelz · Accepted solution]

Hi @jamesmdc1 ,

OK - the next thing is some basic debugging - delete all the fields patches and put them back in one at a time until you get the error.

[jamesmdc1]

Hello @leonsig93 Thanks for the Response! Appreciate the comment as this detail could be easily missed. I validated none of the sharepoint columns were set to required and likewise within the apps datacards. Upon adding a second button SubmitForm(FormName) and testing I receive both the same error and no data in sharepoint. Alternatively I tried (below) with the same results, no data w/ network error. 

Button2.OnSelect =  SubmitForm(Form1)
Button2.OnSelect = SubmitForm(FormName) 

@WarrenBelz I think this is my only option left. Start with the choice columns an yes/no sliders. Work my backward until I find the problem. 

Thanks All

[leonsig93]

The other thing you could try is adding a new form and do nothing to it except add a button with the SubmitForm function with the new forms name. Fill out the data and see if there is still an issue when using the unmodified form. If the new form submits without an issue, you could then compare your original form and the new form to see what differences might exist. Might help narrow it down a bit.

You could also open the Monitor and see if that provides any additional insights. Does come in handy sometimes, but it might just give you the same error information.

https://learn.microsoft.com/en-us/power-apps/maker/monitor-canvasapps 

[jamesmdc1]

@leonsig93 Thanks Again! The result? 4 Errors from the submit button.