Answered

Power Automate HTTP Post Error when updating datetime field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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!!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-zhoqian-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
RickSavoy 24 on at

Like (0)

Report
Copy link

Link copied!

Thank you Habsburg. Your suggestion worked!

Was this reply helpful? Yes No
RickSavoy 24 on at

Like (0)

Report
Copy link

Link copied!

PS: Don't see how to accept your solution. No accept button.

Was this reply helpful? Yes No
RickSavoy 24 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-zhoqian-msft !

Was this reply helpful? Yes No