Answered

String was not recognized as a valid DateTime

(0) Share

Report

Posted on by VinaySiddarth

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.

All responses (5)

Answers (1)

v-alzhan-msft on at

Like (0)

Report

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 on at

Like (0)

Report

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 2 on at

Like (0)

Report

Re: String was not recognized as a valid DateTime

Hi Alice,
Please do find the screen shot.
Screenshot1Screenshot12
Verified answer

v-alzhan-msft on at

Like (0)

Report

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 14,756 on at

Like (0)

Report
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