Patch to SharePoint, NO From, sporadic: Network error when using patch function: conflicts exist with changes on the server, please reload

(0) Share

Report

Posted on by DaFloDo

Hi all,

I am updating an existing record in a SharePoint list using following code:

Patch(SP_LIST, {ID: 4711, Status:"newStatusValue"})

4711 is the ID of an existing record.

Most of the time this is working as expected, but sometimes the user gets the above error:

Network error when using patch function: conflicts exist with changes on the server, please reload

I am not able to reproduce this issue, trying to modify the record in parallel using multiple instances of the app or modifying the record directly within the SharePoint list.

When I track the (successful) patch-action using the power apps monitor, I see this simple post:

https://germany-001.azure-apihub.net/apim/sharepointonline/some_ids_pointing_to_sharepoint/tables/LIST_ID/items/4711"

"body": {
 "Status": "newStatusValue"
 }

So I am wondering - how can there be conflicts at all?

Any ideas what I am doing wrong and what is going on behind the scenes?

regards

florian

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DaFloDo ,
Please try using below formula to update Status column if the column type is of single line of text -

Patch(SP_LIST, LookUp(SP_LIST, ID = 4711), {Status:"newStatusValue"})

If the column type is choice, you can try using below -

Patch(SP_LIST, LookUp(SP_LIST, ID = 4711), {Status:{Value: "newStatusValue"}})
DaFloDo 33 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you for your suggestion,
I know this lookup-pattern from the docs, and will see if that will solve this sporadically occurring issue.

But I still wonder, what the technical reason for this error is, since no version information or timestamps or other information seems to be sent in the patch request at all.
DaFloDo 33 on at

Like
a
(0)

Report
Copy link

Link copied!

so I guess that internally power apps is tracking the version of the item I want to patch and passes this version info automatically as if-match header info, even if I use the minimalistic patch-one-value-by-item-id.
The lookup-solution/workaround does work, however I wished there would be a patch-whatever-the-server-version-is variant, without the need to reload the whole item before patching.
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DaFloDo ,
Before patching you can check if use has changed Status value by using If condition -

If(LookUp(SP_LIST, ID = 4711).Status <> DataCardValue.Text, <Patch code>)