Add Date time to Sharepoint

(0) Share

Report

Posted on by Skybluekid

252

Hi All

I am looking to update a sharepoint list with Date/Time an action is completed. The Column is specified as Date/Time. Yet when I pass the value in my flow, using formatDateTime(utcNow(),'yyyy-MM-dd HH:mm'), it fails. Anyone please advise where I am going wrong.

Thanks in Advance.

All responses (3)

Answers (0)

Chriddle 7,300 on at

Like (0)

Report

Re: Add Date time to Sharepoint

Like all date functions in Power Automate (except formatDateTime(), of course), convertFromUtc() returns a valid date/time string.

But why would you want to do that? The Sharepoint connectors expect a datetime in UTC.
Skybluekid 252 on at

Like (0)

Report

Re: Add Date time to Sharepoint

HI @Chriddle

Would this still work if I used convertfromutc?
Chriddle 7,300 on at

Like (0)

Report

Re: Add Date time to Sharepoint

Your datetime format has to be according to ISO-8601.

Just use utcNow() without formatDateTime()