cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Please reload ETAG mismatch

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

 

Annotation 2019-11-17 230910.jpg

  

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Apps
Power Apps

Re: Please reload ETAG mismatch

@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.untitled.pngVersioning 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

untitled1.png

 

 

 

 

 

View solution in original post

3 REPLIES 3
Highlighted
Power Apps
Power Apps

Re: Please reload ETAG mismatch

@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.untitled.pngVersioning 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

untitled1.png

 

 

 

 

 

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Please reload ETAG mismatch

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

 

Osmand

Highlighted
Post Prodigy
Post Prodigy

Re: Please reload ETAG mismatch

@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 

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,329)