Excel row to Sharepoint list item - Date Error

[ArshUser]

Hi, 
I am trying to populate my SP list using an Excel Sheet. 

I am using "When a file is created" trigger and adding a new Excel sheet (formatted as a table) in the folder to trigger the flow.

I am facing the issue in a date column.

Any ideas for this issue? 

[Gopala_Krishna · Accepted solution]

@ArshUser 

In the "LIST ROWS PRESENT IN A TABLE" action if you click on the "Show advanced options" you will see an option called datetimeformat.

click on the drop down and select ISO 8601 as date time format.

This will resolve your issue

If the information shared helps you please consider giving a thumbs up 👍 and mark solution as resolved

Please follow my website PowerCards for more information related to Power Platform

[ArshUser]

@Gopala_Krishna  It worked. Thankyou!