In my App I have a gallery with button that should set a date field to blank for that item.
Problem is that it does not set to blank though, using correct syntax.
I have found posts that say this problem is solved by setting "formula level error management" on, but that experimental feature is not available in my app settings (now Settings -> Updates ->New/Preview/experimental/retired; "Updates" is a new label).
So it would seem the problem of updating a SP date field to blank still exists, but the workaround "formula level error management" is no longer available to resolve this?
This is the code I used:
Patch(
myTable,
LookUp(myTable,ID=ThisItem.ID),
{
myDateField:Blank()
}
);
Result: correct processing (no error raised), but nothing changed to the data, it stayed the same.
And tried also with myDateField:DateTimeValue(Blank()) and with myDateField:DateValue(Blank()) but same result, no blanking out of the date for this ID item.
As a check of my formula, tried also this one:
myDateField:DateValue("2000-01-01")
-> This worked, it stored the date 01/01/2000 in SP for that item. But I obviously do not want this, I want the date field to be blank.
Any suggestions on this?
