Hi,
I'm getting an error updating a SharePoint list using the Update statement.
The error is:
ErrorKind.GeneratedValue: An attempt was made to change a column that the data source generates automatically.
The error in on the column ID. I understand the message, but I don't know how to avoid it.
In the app I do this:
Saving the old version of a record:
UpdateContext({ChangeExpenseRecord:First(Filter(Expenses;ExpenseId=EntryExpenseId))})
Later in the app:
Update(Expenses;First(Filter(Expenses;ExpenseId=EntryExpenseId));ChangeExpenseRecord)
This generates the error.
In the docs I read the following:
"If the data source generates a column's value automatically, the value of that column must be reaffirmed."
I don't know what it means or what I have to do.
Any ideas to solve this issue?
Thanks in advance