read Excel data with dates Logic apps and convert to CSV

sunil 21 Reputation points
2020-06-02T19:14:24.23+00:00

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.

8910-flow1.jpg

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
    2020-07-21T16:44:07.973+00:00

    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.

    13137-image.png

    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.

    13242-image.png

    13175-image.png

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

    1 person found this answer helpful.