Add Date time to Sharepoint

Like (0) Share

Report

Posted on 20 Dec 2023 13:12:43 by Skybluekid

254

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,932 Super User 2025 Season 2 on 20 Dec 2023 at 15:03:23

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 254 on 20 Dec 2023 at 14:03:48

Like (0)

Report

Re: Add Date time to Sharepoint

HI @Chriddle

Would this still work if I used convertfromutc?
Chriddle 7,932 Super User 2025 Season 2 on 20 Dec 2023 at 13:48:52

Like (0)

Report

Re: Add Date time to Sharepoint

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

Just use utcNow() without formatDateTime()