cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcastr02
Helper I
Helper I

String was not recognized as a valid DateTime.

flow1.pngFLOW 2.pngI am setting up a flow for everytime a row is added in Excel, an item is added to sharepoint.  I have  a few date columns that I can't figure out what format I need to set them to in Excel for it to read and flow into sharepoint list.  I've included the sharepoint setting screen shot, excel screen shot (currently date is set as a text value), and screen shots of the FLOW and respective error.  

 

I've tried short date format, long date with time, text, etc.  I am at a lost and the flow keeps failing because of the date format.  

2 REPLIES 2
v-litu-msft
Community Support
Community Support

Hi @jcastr02,

 

The issue will happen is caused by the return value of the Date format of Excel file will be a number of days, which is start from "1899-12-31", so you should convert this number into the Date format, trying the addDays() function:

 

addDays('1899-12-31',int(item()?['Start_Time']))

 

Annotation 2019-11-06 103637.png

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

Hi @v-litu-msft ,

It is adding one more day additionally. 1899-12-30 worked fine. Not sure if there any other conditions?

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,448)