Patching - Submit button

(0) Share

Report

Posted on by jamesmdc1

110

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

WarrenBelz 155,378 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
jamesmdc1 110 on at

Like (0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
WarrenBelz 155,378 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
jamesmdc1 110 on at

Like (0)

Report
Copy link

Link copied!

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'

Was this reply helpful? Yes No
leonsig93 229 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,378 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
jamesmdc1 110 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
leonsig93 229 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jamesmdc1 110 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jamesmdc1 110 on at

Like (0)

Report
Copy link

Link copied!
@WarrenBelz @leonsig93 Hello All, I was able to fix this weird patching issue by trial and error. Just kept removing items and code until I said "nuke it" and started fresh. Built this time directly from sharepoint using the integrate option. I appreciate both of your time you lent me and appreciate your troubleshooting methods.

Form fully functional. Added a pdf option and don't really have much of a flow beyond that. I added the PDF feature and while it does take a PDF of the form and lands in SharePoint, its an extra step. I was wondering if I can build that function into my submit button as well and also have it emailed. I am opening up a new post as this is completed, thanks again.

Submit button -
SubmitForm(SharePointForm1);Navigate(SuccessScreen,ScreenTransition.Fade);

Pdf Button (onSelect)
PDFfromEDF.Run({file:{name:"EmployeeDisciplinaryForm.pdf", contentBytes: PDF(FormScreen1,{ExpandContainers:true})}})

Two flows for this process
1.) PDF from EDF
And a Second for the report itself. (assuming I can combine the two)
2.)Employee Disciplinary Report

Thoughts on how to do this? A flow or video you recommend to complete this?
Thanks guys

Was this reply helpful? Yes No