Date Time Error in the Advanced Excel

0
I am importing the Data from Excel where all datatype values are importing only remains is the Date Time. How should I make it possible now?  
asked
4 answers
2

Hi Dipak Damor,

              Set the date and time in Excel using the custom format (yyyy/MM/dd HH:mm) when importing the Excel template.

answered
0

Try with date format in excel sheet MM/dd/yyyy 

image.png

 

image.png

image.png

answered
0

By changing the field type of the temporary table storing time types to string type, you will be able to successfully read the imported Excel content. Then, you can convert it back to the time type within a loop and write it into the object yourself.

answered
0

image.pngIn excel import template, you can use custom parser microflow to convert the text to exact date time format. ofcourse this will slow down the import, but it can be used if other solutions do not work.

answered