cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User III
Super User III

Re: Date Formatting

@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
Highlighted
Super User III
Super User III

Re: Date Formatting

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

Rob
Los Gallardos

Highlighted
Helper II
Helper II

Re: Date Formatting

YthUIey.png

 

Highlighted
Super User III
Super User III

Re: Date Formatting

@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

Highlighted
Super User III
Super User III

Re: Date Formatting

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (9,120)