I am trying to use checkbox control topatch data to sharepoint list and received following error:
The requested operation is invalid. Server Response: Save Conflict Your changes conflict with those made concurrently by another user. If you want your changes to be applied, click Back in your Web browser, refresh the page, and resubmit your changes. clientRequestId: 8cec5d9c-6973-45d6-9373-5f1b10c1dfb9 serviceRequestId: 8cec5d9c-6973-45d6-9373-5f1b10c1dfb9
OnCheck property for CheckBox is:
Patch('List Main',First(Filter('List Main', Display=ThisItem.Display)),{Approver: "Approved by "&User().FullName});
Refresh('List Main')
Solved! Go to Solution.
Hi @Anonymous ,
Based on the error message that you mentioned, I think you have faced a Conflict issue with your Patch formula.
The Conflict issue would occur when you and another user are edit same record in your data source at the same time. More details about the Conflict issue when patching data to data source, please check the following article:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-errors#description
As an alternative solution, you should add a Refresh(...) formula before your Patch function to make sure the changes are done within your data source completely. I have made a test on my side, please take a try with the following workaround:
Set the OnCheck property of the Checkbox control to following:
Refresh('List Main'); /* <- Add formula here to your refresh your data source */
Patch(
'List Main',
LookUp('List Main', Display = ThisItem.Display),
{
Approver: "Approved by " & User().FullName
}
);
Please take a try with above solution, then check if the issue is solved.
Best regards,
Hi @Anonymous ,
Based on the error message that you mentioned, I think you have faced a Conflict issue with your Patch formula.
The Conflict issue would occur when you and another user are edit same record in your data source at the same time. More details about the Conflict issue when patching data to data source, please check the following article:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-errors#description
As an alternative solution, you should add a Refresh(...) formula before your Patch function to make sure the changes are done within your data source completely. I have made a test on my side, please take a try with the following workaround:
Set the OnCheck property of the Checkbox control to following:
Refresh('List Main'); /* <- Add formula here to your refresh your data source */
Patch(
'List Main',
LookUp('List Main', Display = ThisItem.Display),
{
Approver: "Approved by " & User().FullName
}
);
Please take a try with above solution, then check if the issue is solved.
Best regards,
User | Count |
---|---|
252 | |
112 | |
92 | |
48 | |
38 |