ETAG Mismatch

(0) Share

Report

Posted on by kscharber

I've read every thread I can find, and still no solution to such a constant issue.

My App connects to Sharepoint lists.

I can't even get this to work and it's infuriating:

Refresh(tblCoverageCalendar);

Patch(tblCoverageCalendar,First(Filter(tblCoverageCalendar,
CoverID = ThisItem.CoverID And CoverPeriod = ThisItem.CoverPeriod)),
{StaffidIn: ComboBox10.Selected.StaffID}
))

I've done the same with Updateif, doesn't make a difference. First goes through, 2nd attempt fails with ETAG Mismatch all day long.

Reloading the Editor again and again is not an option to troubleshoot this. Assume that Refresh isn't the fix, Updateif isn't the fix as every form of these has been used to try to work around it.

Someone save me.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Could you explain a bit more by what you mean when you say "First goes through, 2nd attempt fails with ETAG Mismatch all day long." Are you doing multiple Patches with only one Refresh? If so, then I think that's the problem. ETag is there to make sure that multiple updates by different users can be managed. So if you are trying to do multiple Patches I don't think it currently works unless you use a Refresh before each Patch.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Hi @kscharber ,

Could you please share more details about the ETAG Mismatch error within your app?

The ETAG Mismatch error seems to tell that, same other users are editing same record from your SP List as you at the same time. The user @AJ13 has faced same issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/ETAG-mismatch/m-p/237814

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Server-Response-ETAG-mismatch-Conflicts-exist-with-changes-on/m-p/131599

On your side, please consider modify your formula as below:

Refresh(tblCoverageCalendar); UpdateIf(
tblCoverageCalendar,
CoverID = ThisItem.CoverID && CoverPeriod = ThisItem.CoverPeriod, {
StaffidIn: ComboBox10.Selected.StaffID
} )

Also please consider take a try to turn on the "Formula-level error management" option within Advanced settings of App settings of your app, then re-publish your app, check if the issue is solved.

If the issue still exists, please consider re-create a new connection to your SP list from your app, then try your formula again, check if the issue is fixed.

Best regards,

Was this reply helpful? Yes No