Answered

Power Automate HTTP Post Error when updating datetime field

(0) Share

Report

Posted on by Community Power Pla...

I have a SharePoint list that I am building a flow for in Power Automate. When a certain field's value is changed, I need to set an associated datetime field (SetToCC) to the date and time the value was changed. Purpose is to later use that date to notify users if the next required action is not taken within 24 hrs. When I run flow with a literal quoted date, it works fine. The error I'm getting is "Invalid JSON. The value '05-15-2023' is not a valid number"

Any help would be appreciated!!

All responses (4)

Answers (1)

RickSavoy 24 on at

Like (0)

Report

Re: Power Automate HTTP Post Error when updating datetime field

Thanks @v-zhoqian-msft !
RickSavoy 24 on at

Like (0)

Report

Re: Power Automate HTTP Post Error when updating datetime field

PS: Don't see how to accept your solution. No accept button.
RickSavoy 24 on at

Like (0)

Report

Re: Power Automate HTTP Post Error when updating datetime field

Thank you Habsburg. Your suggestion worked!
Verified answer

v-zhoqian-msft Microsoft Employee on at

Like (1)

Report
Re: Power Automate HTTP Post Error when updating datetime field

Hi @rsavoy ,

Based on my test, there may be two points that need to be modified
1. Formula should be wrapped in quotation marks
2. Format of time:
formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss')

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.