Date Formatting

(0) Share

Report

Posted on by CameronTCD

108

Hi all,

Hoping you can help with this.

I'm passing a:

formatdatetime(utcnow(),'dd/MM/yyyy')

which will give me an output of 13/02/2020. As expected.

Now, when I try and pass that into a 'create item' for a SP list... it fails... stating that 'String was not recognized as a valid DateTime.'

Despite the fact that the forumla states that it converts to a datetime format.

edit: Changing the format to yyyy/MM/dd works... this doesn't seem very logical. Is there a simple explanation as to why it would accept in the y/m/d format as opposed to the d/m/y format?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

RobElliott 10,428 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CameronTCD can you post a screenshot of your flow steps?

Rob
Los Gallardos

Was this reply helpful? Yes No
CameronTCD 108 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

RobElliott 10,428 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@CameronTCD it's invariably better to do the formatDateTime expression with 'yyyy-MM-dd' and let your SharePoint regional settings put it into the correct format

Rob
Los Gallardos

Was this reply helpful? Yes No
ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes @CameronTCD as @RobElliott just what you need to change is your regional time zone in sharepoint.

Was this reply helpful? Yes No