cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Updating a SharePoint Date and Time Column using "Send an HTTP an Request SharePoint" action

I'm trying to update a SharePoint date and time column via the "Send an HTTP Request to SharePoint" action, and I'm struggling to get the formatting correct.  Does anyone have the correct syntax or can tell me what's wrong with this action?  Thanks!

flow.png

 

flow2.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Hi @PowerAppUser875,

 

Could you try to change the body to this format? In other words, remove the curly brackets around the date time value.

 

{
  "__metadata": {
    "type": "SP.Data.@{variables('ListName')}ListItem"
  },
 "Title": "New title",
 "DateAssigned": "2020-11-24T18:39:05Z"
}

 

updatelistitem_datetime02.png

View solution in original post

2 REPLIES 2
Super User II
Super User II

Hi @PowerAppUser875,

 

Could you try to change the body to this format? In other words, remove the curly brackets around the date time value.

 

{
  "__metadata": {
    "type": "SP.Data.@{variables('ListName')}ListItem"
  },
 "Title": "New title",
 "DateAssigned": "2020-11-24T18:39:05Z"
}

 

updatelistitem_datetime02.png

View solution in original post

Thanks!  I was at a total loss for what was wrong.  Such an obvious issue! 

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (6,389)