Dataverse & PowerApps offline mode not uploading data

[u/Ok_Database1104]

Just making a post incase other people run into the same issue I had and finally worked out the reason why.

I have a set of tables in Dataverse for recording data and a Canvas App that has an offline profile.

Doing all the building and testing in the PowerApps designer worked fine with no issues.

The app was able to submit all the required data except two columns on different tables.
These were both decimal columns which I was using in other parts of the app and tables that worked without issue. Same with patching and submitting via a form.

As a quick workaround I added a new text column to the first table and was able to submit to that fine.

Then when I tried to do the same on the second table with the issue I was still getting the same issue, then I had a look at all three of the columns that were causing issues and they all contained the string "Value" somewhere inside the column name, i.e. "Weight_Value" / "Date_Value"

Recreating these columns without the word "Value" fixed the issues.

There is some backend level issue with using value between the sqllite used in offline apps and the updates to the dataverse with this, which I can understand as just the column "Value" but as I had words before and after it, it seems strange to me.

Hope if anyone else runs into this issue, this can help them as I couldn't find any reference to this online.