cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Server Response ETAG mismatch clientRequestId serviceRequestId

Hi,

 

This issue has only happened since last week. I have two sharepoint lists (lets call them list A and list B) that the app updates. When the users click on button to send email for notification the app updates list B but does not update list A and get the attached error messages. No changes were done to the app and this issue suddenly appeared. I have already tried solutions on the boards like changing the formula First for Lookup, re-connecting to the SP list.

 

I went into Edit mode and only used the code to patch to list and was working ok, so then I told users to start using it again but it keeps coming up with the error attached. The ids change every error message.

 

The frustrating thing is that there are other buttons that update list A and there is no issue with them, it is only this particular code which updates customer names, approval status, approver and value that is not working and hence app can no longer be used.

87 REPLIES 87

Greate. I will digg into to see if I can find the root cause. In the meantime, was it any reason you used Patch instead of collect function? Collect function can be used on datasources. 

 

 

@mrdang@Reza

 

I'm setting the Form's item directly to what's selected in the gallery. Should I do this differently? I need to get this app working asap!

I want to repost the issue that I posted a month ago on this thread.  This issue is not resolved.

 

I found a pattern easy to reproduce

 

I republished the app and an item will save fine on the first edit and save but you will get this the second time you edit and try to save.

 

This is very consistant an easy to reproduce. 

 

Open item and edit and save - no problem.  Open another list item and save - no problem.  Go back to first item and try and save - you get the error.  Go to the second item that you edited and try and edit and you get the same error.

 

UPDATE - If you refresh the browser before you try editing the item for a second time in a session, then you will not get an error.

 

Would be happy to get on a shared session to show the team...

 

Data Connectors are to SharePoint Lists

@skylitedave@Reza@mrdang

 

This is the same issue I'm having.

 

Works fine when creating a new item and saving it to a sharepoint list. When selecting an item from the gallery and editing that entry is when the error occurs.

PaulD1
Community Champion
Community Champion

I'm also getting this error intermittently (at least in the designer, haven't tested in Play mode).

 

It is happening for me on a simple Patch command. It will work for a while, then break and the only way to start patching to the same SharePoint list again is to close and reopen the app.

Are you using PowerApps as a detail form behind a SharePoint list? 

 

If so,  I think the pattern to get the error is editing the same sharepoint item more than once in a session... It will work te first time but break the second time you try and edit and save the same item in the same session. See if that is the pattern you are experiencing. If so, please confirm here so the team know what to look for.

 

I have found that if I refresh the browser when I am in the SharePoint  list view and then try and edit for a second time in the same session then I dont get the error...  Let me know if that works for you as well.  

Anonymous
Not applicable

I'd like to provide some additional details for my scenario as I've tried and tried to work around the issue but I still see it sporadically. Like others have mentioned, my form is one that is tied to a SP list. The form starts with a user creating a SP item and then edits the item several times within each session. When an item is created we have a separate tool that calculates information and updates the list item. Then based on that, the user updates the item again. This can happen several times within each session but at the very least it is designed to be edited at least 4 times after it is created. I know this sounds cumbersome (and it's been quite the chore to design) but the end experience provides what has been requested. I also never ran into the ETAG issue until others started seeing it as well. Even though there is another source editing the item, the form is built to be refreshed until our internal tool has completed updating the item, so the user could never update an item that is still being edited (which is happening systematically and is nearly instantaneous).

 

I've used the refresh workaround and built in timers to give extra time between user updates, but the issue still happens occassionally. I'd obviously like to eliminate it outright so if there is any more information I can provide, please let me know. Thank you.

Please be patient with Microsoft folks, we did a debug session over Skype yesterday and it is very likely that ancillary updates to the list items (via flow in my case) are interfering with the "record locking" mechanism of the list items. Refreshes and such techniques are duct tape solutions, since the scheduled updates and concurrent updates all flip the version currency bit on the list item (the ETAG #) I am hoping to get some info very soon on this testing from the mothership , and we will test it out asap. I will post the findings, but Microsoft will probably beat me to it since they seem to have at least 3 people working on our problem. Thank you all for the VERY good diagnostic information, particularly in the (correct) perception that multiple concurrent updates to the list item are at the core of the issue. These guys are good, and I can commend their ability to debug, swap in and out code bases, and test this item for us. Keep up the input, but please be patient, they are good peeps who know we need it (my meeting is in 2 days with my patient but unhappy client.) Fingers crossed, SmartMeter

Today's the day folks, just got off a debug session with the mothership, and I have tested in my app to success. Smiley Happy The nature of the issue is an optimistic locking mechanism that they use to keep multiple concurrent updates from hammering the list item and resulting in a fractured record. PowerApps does this by using a binary check for "stale or current" list item status with an indicator byte called this evil "ETAG". When the error trips, it is because you are trying to update a stale version of the list item. Since we users have millions of ways to do this, I will share my scenario, but yours will likely be different. I have a flow that sends outlook emails when a task is assigned to a person. This is a rogue unpredictable visitation of my list item, as soon as the people picker data is submitted or saved from SharePoint or from the app. It could also happen two minutes later!  The flow is changing the ETAG of the list item, when it dances on it for whatever reason. It is logically triggered on list item create, and it notifies the worker of their duty asap as it should. So deep within my app I let the operator look at a main work ticket and patch in a child record to a list. (No worries, if you are using only one list, same thing can happen.) Now if anything or anyone else edits your list item between the time it was patched into being in my case, and the time of your current edit session, this will happen. So microsoft has this fine lock mechanism in power apps to keep us from messing our diapers, and it is a good thing.

 

So we have to use a local "bound copy" of our list item behind our power app edit screen, refresh the etag knowledge to current,  by refreshing the data source, then we submit the changes on the edit form to Sharepoint. It sounds difficult but it is quite easy.

 

In my case I am moving from a gallery button push to an edit form for a standard submit. So, I have to bind my form hard to the gallery item button push,  by navigating to the second form with the selected item in the optional parm of the navigate command. Nanoseconds before we submit our list item changes on the edited form, we must refresh the list data source, and submit with the form data mods. The issue I had, was the edit form was bound to the gallery selected item, and refreshing the source wiped the field edits I was typing in! (very disheartening to see the edits revert!)  Navigation with the bind option, you are updating a copy of the record that is submitted from what is essentially like a global variable cache. The refresh DOES wipe the visual data on the form at the instant of submission, which looks really wierd, but the submit works, and when the submit form closes on submit, and navigates back to the gallery, all the desired mods are there staring you in the face. Kudos to Microsoft on this little hack, particularly Resa who has guided us here, and a gent named Alan who's handle I do not know. I am including the two "magical" code snippets that saved my gluteous maximus in the meeting I have in 20 hours with a director to explain why this does not works! 

 

Nav to your edit form that is getting the ETAG error with this code from the gallery button selector to the edit form:

Navigate(MyEditScreen2, ScreenTransition.None, {SelectedItem: MyBrowseGallery1.Selected})

notice that third optional parm is the list item to gallery super glue.


Put this code in the submit on that form that gets the errors (check box upper right) of the submit form:

Refresh(MySharePointListName);SubmitForm(MyEditForm2)

 

The fundamental technique is to modify your data record on a form object, not tightly bound to the list item. In this case I believe the gallery "selected" table row variable is being modified on the form now, but the data is submitted to the backend list just as it would be if it were tightly bound to only the list item object. 

 

I hope this helps folks out, sorry if it is too wordy. I was in a bit of a quandry with this particular app, since it was very difficult to see hope when all you get is an evil red error. Flow is acting as a concurrent update, and multi user scenarios will hammer you the same way.  ( If you are wondering, the way you see all these amazing things happen is by using Chrome and hitting CTRL+SHIFT+i  These keys open a debugger window. Go to the network tab and you can filter down to all the behind the scenes traffic that the browser is spewing with your form submission.) 

Are you saying that the fix is to add a refresh of the list before you submit the form?

 

Thx

 

 

 

 

Helpful resources

Announcements

Exclusive LIVE Community Event: Power Apps Copilot Coffee Chat with Copilot Studio Product Team

  It's time for the SECOND Power Apps Copilot Coffee Chat featuring the Copilot Studio product team, which will be held LIVE on April 3, 2024 at 9:30 AM Pacific Daylight Time (PDT).     This is an incredible opportunity to connect with members of the Copilot Studio product team and ask them anything about Copilot Studio. We'll share our special guests with you shortly--but we want to encourage to mark your calendars now because you will not want to miss the conversation.   This live event will give you the unique opportunity to learn more about Copilot Studio plans, where we’ll focus, and get insight into upcoming features. We’re looking forward to hearing from the community, so bring your questions!   TO GET ACCESS TO THIS EXCLUSIVE AMA: Kudo this post to reserve your spot! Reserve your spot now by kudoing this post.  Reservations will be prioritized on when your kudo for the post comes through, so don't wait! Click that "kudo button" today.   Invitations will be sent on April 2nd.Users posting Kudos after April 2nd. at 9AM PDT may not receive an invitation but will be able to view the session online after conclusion of the event. Give your "kudo" today and mark your calendars for April 3rd, 2024 at 9:30 AM PDT and join us for an engaging and informative session!

Tuesday Tip: Unlocking Community Achievements and Earning Badges

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!     THIS WEEK'S TIP: Unlocking Achievements and Earning BadgesAcross the Communities, you'll see badges on users profile that recognize and reward their engagement and contributions. These badges each signify a different achievement--and all of those achievements are available to any Community member! If you're a seasoned pro or just getting started, you too can earn badges for the great work you do. Check out some details on Community badges below--and find out more in the detailed link at the end of the article!       A Diverse Range of Badges to Collect The badges you can earn in the Community cover a wide array of activities, including: Kudos Received: Acknowledges the number of times a user’s post has been appreciated with a “Kudo.”Kudos Given: Highlights the user’s generosity in recognizing others’ contributions.Topics Created: Tracks the number of discussions initiated by a user.Solutions Provided: Celebrates the instances where a user’s response is marked as the correct solution.Reply: Counts the number of times a user has engaged with community discussions.Blog Contributor: Honors those who contribute valuable content and are invited to write for the community blog.       A Community Evolving Together Badges are not only a great way to recognize outstanding contributions of our amazing Community members--they are also a way to continue fostering a collaborative and supportive environment. As you continue to share your knowledge and assist each other these badges serve as a visual representation of your valuable contributions.   Find out more about badges in these Community Support pages in each Community: All About Community Badges - Power Apps CommunityAll About Community Badges - Power Automate CommunityAll About Community Badges - Copilot Studio CommunityAll About Community Badges - Power Pages Community

Tuesday Tips: Powering Up Your Community Profile

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!   This Week's Tip: Power Up Your Profile!  🚀 It's where every Community member gets their start, and it's essential that you keep it updated! Your Community User Profile is how you're able to get messages, post solutions, ask questions--and as you rank up, it's where your badges will appear and how you'll be known when you start blogging in the Community Blog. Your Community User Profile is how the Community knows you--so it's essential that it works the way you need it to! From changing your username to updating contact information, this Knowledge Base Article is your best resource for powering up your profile.     Password Puzzles? No Problem! Find out how to sync your Azure AD password with your community account, ensuring a seamless sign-in. No separate passwords to remember! Job Jumps & Email Swaps Changed jobs? Got a new email? Fear not! You'll find out how to link your shiny new email to your existing community account, keeping your contributions and connections intact. Username Uncertainties Unraveled Picking the perfect username is crucial--and sometimes the original choice you signed up with doesn't fit as well as you may have thought. There's a quick way to request an update here--but remember, your username is your community identity, so choose wisely. "Need Admin Approval" Warning Window? If you see this error message while using the community, don't worry. A simple process will help you get where you need to go. If you still need assistance, find out how to contact your Community Support team. Whatever you're looking for, when it comes to your profile, the Community Account Support Knowledge Base article is your treasure trove of tips as you navigate the nuances of your Community Profile. It’s the ultimate resource for keeping your digital identity in tip-top shape while engaging with the Power Platform Community. So, dive in and power up your profile today!  💪🚀   Community Account Support | Power Apps Community Account Support | Power AutomateCommunity Account Support | Copilot Studio  Community Account Support | Power Pages

Super User of the Month | Chris Piasecki

In our 2nd installment of this new ongoing feature in the Community, we're thrilled to announce that Chris Piasecki is our Super User of the Month for March 2024. If you've been in the Community for a while, we're sure you've seen a comment or marked one of Chris' helpful tips as a solution--he's been a Super User for SEVEN consecutive seasons!       Since authoring his first reply in April 2020 to his most recent achievement organizing the Canadian Power Platform Summit this month, Chris has helped countless Community members with his insights and expertise. In addition to being a Super User, Chris is also a User Group leader, Microsoft MVP, and a featured speaker at the Microsoft Power Platform Conference. His contributions to the new SUIT program, along with his joyous personality and willingness to jump in and help so many members has made Chris a fixture in the Power Platform Community.   When Chris isn't authoring solutions or organizing events, he's actively leading Piasecki Consulting, specializing in solution architecture, integration, DevOps, and more--helping clients discover how to strategize and implement Microsoft's technology platforms. We are grateful for Chris' insightful help in the Community and look forward to even more amazing milestones as he continues to assist so many with his great tips, solutions--always with a smile and a great sense of humor.You can find Chris in the Community and on LinkedIn. Thanks for being such a SUPER user, Chris! 💪🌠

Find Out What Makes Super Users So Super

We know many of you visit the Power Platform Communities to ask questions and receive answers. But do you know that many of our best answers and solutions come from Community members who are super active, helping anyone who needs a little help getting unstuck with Business Applications products? We call these dedicated Community members Super Users because they are the real heroes in the Community, willing to jump in whenever they can to help! Maybe you've encountered them yourself and they've solved some of your biggest questions. Have you ever wondered, "Why?"We interviewed several of our Super Users to understand what drives them to help in the Community--and discover the difference it has made in their lives as well! Take a look in our gallery today: What Motivates a Super User? - Power Platform Community (microsoft.com)

March User Group Update: New Groups and Upcoming Events!

  Welcome to this month’s celebration of our Community User Groups and exciting User Group events. We’re thrilled to introduce some brand-new user groups that have recently joined our vibrant community. Plus, we’ve got a lineup of engaging events you won’t want to miss. Let’s jump right in: New User Groups   Sacramento Power Platform GroupANZ Power Platform COE User GroupPower Platform MongoliaPower Platform User Group OmanPower Platform User Group Delta StateMid Michigan Power Platform Upcoming Events  DUG4MFG - Quarterly Meetup - Microsoft Demand PlanningDate: 19 Mar 2024 | 10:30 AM to 12:30 PM Central America Standard TimeDescription: Dive into the world of manufacturing with a focus on Demand Planning. Learn from industry experts and share your insights. Dynamics User Group HoustonDate: 07 Mar 2024 | 11:00 AM to 01:00 PM Central America Standard TimeDescription: Houston, get ready for an immersive session on Dynamics 365 and the Power Platform. Connect with fellow professionals and expand your knowledge. Reading Dynamics 365 & Power Platform User Group (Q1)Date: 05 Mar 2024 | 06:00 PM to 09:00 PM GMT Standard TimeDescription: Join our virtual meetup for insightful discussions, demos, and community updates. Let’s kick off Q1 with a bang! Leaders, Create Your Events!    Leaders of existing User Groups, don’t forget to create your events within the Community platform. By doing so, you’ll enable us to share them in future posts and newsletters. Let’s spread the word and make these gatherings even more impactful! Stay tuned for more updates, inspiring stories, and collaborative opportunities from and for our Community User Groups.   P.S. Have an event or success story to share? Reach out to us – we’d love to feature you!

Top Solution Authors
Top Kudoed Authors
Users online (6,024)