Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : kNzc5vJ1mdnIoeECNLuRmy
Power Platform Community / Forums / Power Automate - Using Flows / String was not recogni...
Power Automate - Using Flows
Answered

String was not recognized as a valid DateTime

Like (0) ShareShare
ReportReport
Posted on 4 Feb 2020 07:42:43 by VinaySiddarth 2

Hi ,

I am creating the item based on excel data but the I am getting error with date, only date field is show the error to create item.

Error:String was not recognized as a valid DateTime

Connector: Excel Online Business
Please any one suggest with example.
  • v-alzhan-msft Profile Picture
    v-alzhan-msft on 20 Feb 2020 at 07:48:03
    Re: String was not recognized as a valid DateTime

    Hi @VinaySiddarth ,

     

    Does your issue still exists?

     

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-alzhan-msft Profile Picture
    v-alzhan-msft on 06 Feb 2020 at 09:55:30
    Re: String was not recognized as a valid DateTime

    Hi @VinaySiddarth ďĽŚ

     

    Please share the expression For the Start Date column in your flow.

    And please share the run history of flow when it flow has run failed.

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • VinaySiddarth Profile Picture
    VinaySiddarth 2 on 06 Feb 2020 at 05:21:45
    Re: String was not recognized as a valid DateTime

    Hi Alice,

    Please do find the  screen shot.

    Screenshot1Screenshot1Screenshot12Screenshot12

     
     
  • Verified answer
    v-alzhan-msft Profile Picture
    v-alzhan-msft on 04 Feb 2020 at 09:19:50
    Re: String was not recognized as a valid DateTime

    Hi @VinaySiddarth ,

     

    Could you please share a screenshot of the configuration of your flow?

    Hope the link below could helps:

    https://powerusers.microsoft.com/t5/Building-Flows/Unable-to-Process-Template-Language-for-Date-String-Integer/m-p/459934#M55065

     

    Best regards,
    Alice       
     
    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • efialttes Profile Picture
    efialttes 14,756 on 04 Feb 2020 at 08:35:15
    Re: String was not recognized as a valid DateTime

    Hi

    Are you trying to store data in a Date format excel column? If so, you need to convert it into an integer.

     

    Let's assume you want to write in Excel a date that is stored in a variable called 'myNewDate' in the standard string format PA flow uses internally. So, I would try the following:

    add(div(sub(ticks(variables('myNewDate'),ticks('1900-01-01')),864000000000),2)

     

    The reason is, that according to this post, the date calendar in Excel is an integer representing the number of days since January 1st, 1900. Please also note, that, according to this web site:

     

    Days Since 1900-01-01 (+2) is used in the Microsoft Excel date functions such as DAY(serial_number) and WEEKDAY().

    Note, Excel's serial number is 2 higher than the number on this page.

    • In Excel January 1 is serial number 1. In this converter midnight January 1, 1900 is 0, after 1 day it is midnight on January 2. To correct this you have to add/subtract 1.
    • Excel incorrectly sees 1900 as a leap year (for compatibility with Lotus 1-2-3) so you have to add/subtract 1 to all days when using in Excel. Also see: Excel incorrectly assumes that the year 1900 is a leap year

     Hope this helps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans