I have made an app, which controls my working hours, with dates and time.
But when i want the app to save the dates in my excel, it's returning an error message saying:
"The requested action is invalid. Server response: Invalid value '1551194100000' for field 'Date', expected a string. clientRequestId: 89cb7c6e-d3b6-4990-b65e-262734cbe808 serviceRequestId: 89cb7c6e-d3b6-4990-b65e-262734cbe808"
The excel table is a pivot table, and the field that its posting in, is a "Time" field, but i can handle both dates and time.
Can anybody tell me how i come arrond this?
Thanks in advance
Hey @SofiePeriti, my guess shot will be to use text(<your date>) function in your Dato field on Update. If that not works I will try to format string in the format like 2011-08-12T20:17:46.384Z
Could you share more details on the Excel table?
You said it is a Pivot table, however, I am afraid that a Pivot table inserted in an Excel table could not be selected as the data source of an app.
I have created an app which is started from data with an Excel table which includes a date and time column.
The Update property of the Date and time field is:
DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)
All the data could be saved to the table without issues.
Please take it for a reference.