Server Response ETAG mismatch (Conflicts exist with changes on the server, please reload)

[karl · Accepted solution]

Fixed the problem!

I inserted the Refresh(DataSource) Function before the final patch.

On "Yes" Button:

UpdateContext({ showLoader: true});
Refresh(LeaveForm); I added this.
Patch(LeaveForm , LeaveDataSourceSelected,
{
LeaveTypeList: NewLeaveTypeList,
Approver: EditRequestItem.Approver,

});

On "Save" Button:

UpdateIf(LeaveRequestSelectedCollect ,LeaveTypeList <> EditLeaveTypeGallery.Selected.type, {LeaveTypeList:EditLeaveTypeGallery.Selected.type});

Instead of using Patch on the "Save Button" I used UpdateIf Function.

After changing the codes. Save and close your application and Open it again.

Cheers

[MiraGhaly]

Hello,

I am facing the same issue and i tried refreshing the data source before patch and it is not working:

I am actually doing bulk update:

ForAll(

processedLineItems,

Patch(

'Supplier Invoice Data',

LookUp('Supplier Invoice Data', ID = processedLineItems[@ID]),

{Status:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: "Portal Upload"},DataReadyForUpload:true,Portal_x0020_Reference:Concatenate("Portal Reference _",Text(Now()),"_Submit")}

)

)

ِAlso i am doing Individual Updates on Items in a gallery:

Patch('Supplier Invoice Data',ThisItem,{To:ToDate.SelectedDate})

[karl]

Hi,

Have you tried using UpdateIf Function?
On the screen property OnVisible,

Set(ProcessedLineItemsID, processedLineItems[@ID]))

ForAll(

processedLineItems,

UpdateIf(

'Supplier Invoice Data', ID = ProcessedLineItemsID,

{Status:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: "Portal Upload"},DataReadyForUpload:true,Portal_x0020_Reference:Concatenate("Portal Reference _",Text(Now()),"_Submit")}

)

[luuminhvuong93]

Adding the Refresh Button make the app run longer for about 10 seconds 😞 not ideally

[Macjan]

I can't get my SharePoint list to update after attempting to fix that ETAG error.

At first I had this on my Screen's OnVisible:

Refresh(SpTable);
ForAll(ClTable, Patch(SpTable, LookUp(SpTable, true), {index:index, power1:power1, power2:power2, (…)}))

And I changed it to this:

Refresh(SpTable);
ForAll(ClTable, UpdateIf(SpTable, true, {index:index, power1:power1, power2:power2, (…)}))

ClTable is a collection table, SpTable is the SharePoint one. Both have same columns but since PA was complaining about not being able to modify "Modified" column I told it to update only specific columns. It kinda works when I use Patch, but it skips random records, but with UpdateIf nothing gets updated. All records must be updated, hence why I used true as condition.

Any help would be appreciated.

[luuminhvuong93]

Added the Refresh data source slow the whole thing down significantly,

Is this a Sharepoint issues, ot Powerapps issues ?