Power Platform Community Forum Thread Details

on my submit button I am using the patch function to populate a SharePoint table. It works great but I got this error once in about 30 trys.

can I wrap the Patch code and all my clear variables in a on error something? where do I look for the catch error function?

Patch(
'MyTab',
Defaults('MyTab'),
{
eMail: User().Email,
Team: {Value: varTeam},
Where: {Value: varWhere},
Date: Now(),
Yield: CounterFSY,
Jaywalking: CounterJ,
Distracted: CounterDD,
Speeding: CounterS,
Vehicles: CounterV,
Pedestrians: CounterP,
Comment: varComment,
TotalObservations:CounterV+CounterP
}
);
Set(varTeam, "");
Set(varWhere,"");
Set(varComment, "");
Set(CounterFSY,0);
Set(CounterJ,0);
Set(CounterDD,0);
Set(CounterS,0);
Set(CounterV,0);
Set(CounterP,0);
Reset(drpTeam);
Reset(drpWhere);
Reset(txtComment);

Categories:

Building Power Apps

Patch('MyTab',
Defaults('MyTab'),
{
Title: User().Email,
Team: {Value: varTeam},
Where: {Value: varWhere},
Date: Now(),
Yield: CounterFSY,
Jaywalking: CounterJ,
Distracted: CounterDD,
Speeding: CounterS,
Vehicles: CounterV,
Pedestrians: CounterP,
Comment: varComment,
TotalObservations:CounterV+CounterP
}
);
If(
// check if there were any errors when the data was submitted
!IsEmpty(Errors('MyTab')),
// if true, show any error message
Notify(
"submission failed resubmit",
NotificationType.Error
),
// else, clear the data
Set(varTeam, "");
Set(varWhere,"");
Set(varComment, "");
Set(CounterFSY,0);
Set(CounterJ,0);
Set(CounterDD,0);
Set(CounterS,0);
Set(CounterV,0);
Set(CounterP,0);
Reset(drpTeam);
Reset(drpWhere);
Reset(txtComment);
)