
Announcements
Hi everyone and thank you in advance for helping me identify what I'm doing wrong.
I am able to update list item string and number fields just fine using Send HTTP Request to SharePoint but not Date Time fields.
This is the body. Yes, in this example I am hard coding the value for simplicity right now.
{
"Event_x0020_Date": "6/7/2020"
}
And this is the output:
Hi Ellsworth03054,
I'm pretty sure this would be the correct format of your value: 2020-06-07T00:00:00
That format is year-month-day, then T, then hours:months:seconds. If your field is date only, then the hours:months:seconds is 00:00:00.
Here is an example of a previous thread on this forum asking a similar question: https://powerusers.microsoft.com/t5/General-Power-Automate/Date-Time-Format-for-SharePoint-Calendar/m-p/451333/highlight/true#M44920
I hope this helps!
Tom