read Excel data with dates Logic apps and convert to CSV

sunil 21 Reputation points

I am using Logic apps to read excel content using "List rows present in a table" and trying to convert to CSV. I was able to covert using the following setting in CSV. How ever the date columns in excel are converted into integers. How can i keep the same date field and create csv files.
How do i correct the date column values. Any pointer is appreciated.


Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,994 questions
{count} votes

1 answer

Sort by: Most helpful
  1. QuantumCache 20,261 Reputation points

    Hello @Anonymous , Sorry for the delay in response. Thanks for reaching out to us.

    Please make sure that the Date column in your excel is in Text format, as we know that sharepoint stores date in different format. This would be the cleanest solution.


    Once you make sure the Excel file Date column is formatted as Text, then please trigger your logic app flow again to check the conversion.



    Please let us know if you need further help in this matter.

    1 person found this answer helpful.