Getting error while patching the data to the sharepoint(Network error when using Patch Function: An error occured on the server)

(0) Share

Report

Posted on by Community Power Pla...

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@Anonymous

Please post your Patch() function. You could check for yourself using @mdevaney 's suggestion of using the Errors() function in his example of a patch to a 'Test Scores' data source. Substitute your own values in it.

Patch( 'Test Scores', Defaults('Test Scores'), { TestName: txt_TestName.Text, StudentName: txt_StudentName.Text, Score: Value(txt_Score.Text) } ); If( // check if there were any errors when the test score was submitted !IsEmpty(Errors('Test Scores')), // if true, show any error message Notify( Concat(Errors('Test Scores'), Column&": "&Message), NotificationType.Error ), // else, go to success screen Navigate('Success Screen'); )

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

If(IsBlank(LookUp('Attrition Tracker Moody''s','Enterprise ID'=AttritionTextinput_1.Text)),
Patch('Attrition Tracker Moody''s',Defaults('Attrition Tracker Moody''s'),
{
'First Name':DataCardValue2.Text,
'Last Name':DataCardValue3.Text,
Title:DataCardValue1.Text,
'Enterprise ID':DataCardValue4.Text,
Gender:{Value:DataCardValue5.Selected.Value},
'Career Level':{Value:DataCardValue6.Selected.Value},
'Sub Level':{Value:DataCardValue7.Selected.Value},
Tower:{Value:DataCardValue8.Selected.Value},
'Sub Process':{Value:DataCardValue9.Selected.Value},
'Tower Lead Email':DataCardValue16.Text,
'Supervisor Email ID':DataCardValue17.Text,
'Resignation Date':DateValue7.SelectedDate,
LWD:DateValue8.SelectedDate,
'Managed / Unmanaged':{Value:DataCardValue33.Selected.Value},
'Is this Critical resource?':{Value:DataCardValue30.Selected.Value},
'Backfill Required':{Value:DataCardValue31.Selected.Value},
'Attrition Reason':{Value:DataCardValue32.Selected.Value},
'Reversal Date (If any)':DateValue9.SelectedDate,
'Roll Off Date':DateValue10.SelectedDate,
Comment:DataCardValue34.Text
}),
Patch('Attrition Tracker Moody''s',LookUp('Attrition Tracker Moody''s','Enterprise ID'=AttritionTextinput_1.Text),
{
'First Name':DataCardValue2.Text,
'Last Name':DataCardValue3.Text,
Title:DataCardValue1.Text,
'Enterprise ID':DataCardValue4.Text,
Gender:{Value:DataCardValue5.Selected.Value},
'Career Level':{Value:DataCardValue6.Selected.Value},
'Sub Level':{Value:DataCardValue7.Selected.Value},
Tower:{Value:DataCardValue8.Selected.Value},
'Sub Process':{Value:DataCardValue9.Selected.Value},
'Tower Lead Email':DataCardValue16.Text,
'Supervisor Email ID':DataCardValue17.Text,
'Resignation Date':DateValue7.SelectedDate,
LWD:DateValue8.SelectedDate,
'Managed / Unmanaged':{Value:DataCardValue33.Selected.Value},
'Is this Critical resource?':{Value:DataCardValue30.Selected.Value},
'Backfill Required':{Value:DataCardValue31.Selected.Value},
'Attrition Reason':{Value:DataCardValue32.Selected.Value},
'Reversal Date (If any)':DateValue9.SelectedDate,
'Roll Off Date':DateValue10.SelectedDate,
Comment:DataCardValue34.Text
}));
ResetForm(Form1_3);
ResetForm(Form1_4);
Set(newitem1,"");
If(IsBlank(newitem1),Notify("Details has been submitted successfully",NotificationType.Success),Notify("Details has been modified successfully",NotificationType.Success))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi, Please reply...it is urgent, same kind of patch function is working perfectly fine in other app.
But it is giving error in this one

Was this reply helpful? Yes No