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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,283)