cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CameronTCD
Helper II
Helper II

Date Formatting

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?

1 ACCEPTED SOLUTION

Accepted Solutions

@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

View solution in original post

4 REPLIES 4
RobElliott
Super User
Super User

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

Rob
Los Gallardos

YthUIey.png

 

@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

ChristianAbata
Super User
Super User

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,981)