cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CameronTCD
Level: Powered On

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
Super User
Super User

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
Super User
Super User

Re: Date Formatting

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

Rob
Los Gallardos

CameronTCD
Level: Powered On

Re: Date Formatting

YthUIey.png

 

Super User
Super User

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

Super User
Super User

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 😉


Proud to be a Flownaut!





Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,696)