Please reload ETAG mismatch

[OsmandFernando]

Dear Admin, 

I am receiving the following error when I am patching data to a SharePoint list. Issue is intermittent.  I tried searching the similar issue here and found some answers. I tried those solutions, e.g removing the Refresh() from back to to the front of the formula but in vain. Therefore kindly help me resolving this otherwise my users will loose their faith on powerapps. I am promoting largely the powerapps within my community

Osmand

[sriniD · Accepted solution]

@OsmandFernando 

Problem

When editing an item from the server multiple times the user experiences an error indicating that there has been a conflict.

"Conflict exists with changes on the server, please reload"

This mostly happens when using SharePoint as a data source.

Scenario Variants

User creates or edits a new item in a list and has a Flow or a 'SharePoint workflow' that is triggered when items in SharePoint are created or modified and as part of the Flow (or 'SharePoint workflow') the item gets modified.

Because the Flow (or 'SharePoint workflow') is executed outside of PowerApps, the list items in the client session can get out of date as soon as the item is modified. Consider the following scenario:

1. User modifies item A with Etag 1 and Patches the item to the server, PowerApps sends Etag 1. Item is successfully modified.
2. PowerApps refreshes the data source and item A has now Etag 2
3. The Flow runs outside of PowerApps and makes changes to the item, item A in the server has now Etag 3
4. User tries to modify the item inside PowerApps and Patches the item to the server, PowerApps sends Etag 2 (the last Etag we got from the service). Item fails to updated because we have an out of date item with Etag 2 and we get the error above.

This behavior is by design since the purpose of ETags is to detect conflicts when saving entities.

Probably here submitforms and patch happening same time on same sharepoint list  which causing etag issue. may be some timer around submitform and patch.

Try

Refresh

SubmitForm

Refresh

Patch

Next steps

If the above doesn't work, the customer will need to take some actions to find out what else is causing the ETag issue. Here are some steps the user can follow to track this:

Enable SharePoint list history

1. Click on the 'gear' icon on the top right corner of the list.

2. Select 'List settings'

3. Select 'Versioning settings'

    <div class="thumb tnone">
    
    <div class="thumbinner" style="width:302px;">
    
    <br/><a href="https://supportability.visualstudio.com/898c202b-ad1e-4509-9795-de4c3b29a293/_apis/git/repositories/7cb67651-1295-46b5-9973-3cb42b65665b/Items?path=%2FPowerApps/.attachments/493854fd-95aa-d195-57dc-3366a20ff8ab300px-ListSettingsMenu.png&download=false&resolveLfs=true&%24format=octetStream&api-version=5.0-preview.1" class="image"><img alt="" src="https://supportability.visualstudio.com/898c202b-ad1e-4509-9795-de4c3b29a293/_apis/git/repositories/7cb67651-1295-46b5-9973-3cb42b65665b/Items?path=%2FPowerApps/.attachments/493854fd-95aa-d195-57dc-3366a20ff8ab300px-ListSettingsMenu.png" width="300" height="339" class="thumbimage" srcset="/images/thumb/e/e1/ListSettingsMenu.png/450px-ListSettingsMenu.png 1.5x, /images/e/e1/ListSettingsMenu.png 2x"></a><br/>
    
    <div class="thumbcaption">
    
    <div class="magnify">
    </div>
    
    List settings menu
    </div>
    
    </div>
    
    </div>
   

4. Select 'Yes' on the 'Create a version each time you edit an item in the list?' question.

5. Check the checkbox on the option 'Keep the following number of versions' and add '50' on the textbox.Versioning settings

eview SharePoint workflow

1. Click on the 'gear' icon on the top right corner of the list.

2. Select 'List settings'

3. Select 'Workflow settings'

4. If a workflow is active it should be listed

[OsmandFernando]

@sriniD  Thank you for your detail reply. I will follow the instructions 

Osmand

[OsmandFernando]

@sriniD 

Hi, 

I followed the instructions. 1st I tried Refresh , Submit form, Refresh, Patch. But I want to say that I do not have Submit form function in that action. Following is one of a formula I facing this ETAG issue, 

IfError(Patch(Inventory,LookUp(Inventory,ModelNumber=Label25_2.Text),{PurchaseQty:LookUp(Inventory,ModelNumber=Label25_2.Text).PurchaseQty-Label24_2.Text});Remove(OrderDetails,ThisItem),Notify("Error,Please try again",NotificationType.Error),Notify("Data Saved",NotificationType.Success))

Only the 1st one is successful, if I click on the 2nd line button it gives me the Etag error

Then I tried your suggestion on Versioning settings and then check the workflow settings, but found that no workflow is running 

Then when I go back to the button and check the function the error part which is the patch function is with red line underlined. 

I am really worrying on this as this might fail my app

😞

Osmand 

[confusedpowerad]

Hi, I know this is old but I am running into the same issue. Were you able to find a solution to this?