Flow to format Date and Time values in my flow is now failing (worked last week...)

[linlin88]

Hi everyone,

Last week I set up a flow to format Date and Time values. It was successfully working last week but now it's failing and throwing up an error (images below):

Snapshot of my flow and the error (in orange)

The expression I'm using in the relevant field is:

formatDateTime(body('Current_time'), 'dd/MM/yyyy hh:mm tt')

I got this from the help article: https://docs.microsoft.com/en-us/troubleshoot/power-platform/power-automate/how-to-customize-or-form...

Just wondering, has anyone else experienced this error? Otherwise, I wonder if there was a change in the system in the last week - seems strange that it was working perfectly before and now it's not...

Thanks!

Lin

[Expiscornovus · Accepted solution]

Hi @linlin88,

Quick question, have you tried using the current time value without formatting? As far as I am aware that should work with a standard DateTime SharePoint column.

[linlin88]

Hi @Expiscornovus,

Thanks so much, your solution worked 🙂 Much appreciated!

Lin