Can't read Datetime from Excel sheet using Azure Logic Apps

Question

Hello, Good day! I am trying to pull data from excel sheet and will ingest to SQL database using Azure Logic Apps but it was not ingesting any data due to DateTime format, even I already have parseDateTime in my workflow design. Can you please help me on this matter? Thank you

Answer 1

@Ceeeee-8261 Thanks for your offline discussion.

The main issue was with the workflow how the value iteration inside the loop and the SQL command that was used was not in the correct format/syntax that was causing the date field not getting inserted correctly to the SQL Database.

We fixed the workflow by debugging the failed run on the individual step along with the SQL command/schema of the Database for other columns that was causing the issue. On the data part it was coming as the string with the right format and it was converted and stored correct once we fixed mutiple issue in the workflow.

Answer 2

Hi Ceeeee-8261

What parameters did you pass to formatDateTime?

Have you tried this?:

formatDateTime('datevalue', 'yyyy-MM-ddTHH:mm:ss')

formatDateTime('9/1/2023 18:00', 'yyyy-MM-ddTHH:mm:ss')