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.
Hi @Sunilprabha-2432 ,
I'm new to Logic App development , I'm trying to convert excel to csv and storing into Azure blob storage.
My flow is also same as you , created get file content (since I have multiple files in sharepoint)
In the below action I'm stuck in List rows present in a table checking for the values to be passed for that task
your help would be much appreciated.
Thank you
Hi @SanthoshReddy-4787 Could you open a separate post? We'd be happy to review and provide assistance.
Hi @SanthoshReddy-4787, Please let us know if you are still stuck with this issue, we would be happy to assist you in this matter.
Hi @SanthoshReddy-4787, Please let us know if you are still stuck with this issue, we would be happy to assist you in this matter.
Hi @Sunilprabha-2432 , Please let us know if you need further help in this matter.
Hi @Sunilprabha-2432 , Please let us know if you need further help in this matter.
Hello @Sunilprabha-2432 , 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.
Hi @Sunilprabha-2432 , Please let us know if you need further help in this matter.
6 people are following this question.
