Answered

Data source may be invalid and ETAG mismatch error

(0) Share

Report

Posted on by sec4zj

Hello,

I am working on an app for marking off tasks in an investigation as that investigation moves to completion. I am getting a couple different errors when submitting the data with the PowerApp. I've gone through all the other forums and tried some of their solutions, but they are not working for me 😥

My goal is to remove these two errors:

When I submit the data in the PowerApp, I get a "There was a problem saving your changes. The data source may be invalid." error across the top of the screen. However, the PowerApp seems to write correctly to the associated Sharepoint list.
Particularly if I check or uncheck multiple checkboxes in quick succession, I get an ETAG Mismatch error. This data usually writes partially correctly - for example, if I check 4 boxes, 2 will write correctly to the Sharepoint list. I have tried putting Refresh('Sharepoint List'); before my Patch function, but it made no difference - I just got the ETAG Mismatch error in my App Checker instead of across the top of the screen when I attempted to submit data.

The OnCheck code is: Patch('Sharepoint List',Update_List.Selected,{'Column1':Now(),'Column2': { Value: "Completed"}})

The OnUncheck code is: Patch('Sharepoint List',Update_List.Selected,{'Column1': Blank(),'Column2': { Value: "Not Completed"}})

Default: If(Update_List.Selected.'Column1'.Value="Completed", true, false)

Submit: Navigate(SubmittedScreen,ScreenTransition.Fade);SubmitForm(Form1)

I have no issues with the Sharepoint list connection - I've refreshed it, etc. and it's made no difference. Please help!

Categories:

Building Power Apps

InkedPowerApp Dev...

InkedDeviation Ta...

I have the same question (0)

All responses (3)

Answers (1)

v-siky-msft on at

Like (0)

Report
Hi @sec4zj ,

The first error means there is something wrong with Form property. How did you customize the edit form? Could you please share the detailed steps of your customization? I would recommend you to delete the current EditForm and re-create one, all data card and property is set by systems to check if the error is gone?
The second error means there is a conflict on your data source. It is likely that you chose too quickly and submitted multiple requests to the data source at the same time, resulting in conflicts and ETAG error. Some workarounds:
1. Slow down the selection and submit the request one by one
2. Add Refresh('SP list') code before Patch function in OnCheck and OnUnCheck property
3. Submit all checkbox values at once by Submit button, instead of by OnCheck and OnUnCheck property.

Patch('Sharepoint List',Update_List.Selected,{'Column1':If(Checkbox1.Value,Now(),Blank()), 'Column2':If(Checkbox1.Value,{ Value: "Completed"},{ Value: "Not Completed"}), 'Column3':If(Checkbox2.Value,{ Value: "Completed"},{ Value: "Not Completed"}), etc.})

Hope this helps.
Sik

Was this reply helpful? Yes No
sec4zj 45 on at

Like (0)

Report

I've deleted my current EditForm and re-created it; I am still getting the error. I haven't done any customization to it - I just loaded in the form from Sharepoint and selected the data fields that are tied to the checkboxes.

For the ETAG error, I added Refresh('SP list') to before the Patch function, but it made no difference. I still got the error. I will try the option presented in #3 (Submit all checkbox values at once by Submit button, instead of by OnCheck and OnUnCheck property.) and let you know if it works!

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (0)

Report
Hi @sec4zj ，
What do you mean that tie data fields to the checkboxes.?
Could you please check if you encountered the following 3 cases that cause the Data source invalid error?
1. There is a required field that is not on the edit form. Therefore the person filling out the form is attempting to submit data without values for required fields.
2. You are submitting a partial value to a complex field. Perhaps you are submitting just text to a choice field which needs two values: id and value (normally this results from someone creating the control versus using the control being created via app generation from the ribbon).
See this blog please: https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/
3. There was a change to the schema between the last publish and the issue. Save and close the app, then reopen and fields should adjust. When you do this check the App Checker for troubleshooting assistance.
As an alternative workaround, could you please change to use Patch function to save the form value?
Submit button OnSelect:

Patch('SP list',Update_List.Selected, FormName.Updates)

Hope this helps.
Sik

Was this reply helpful? Yes No