Question 240063 in Azure Question posted in
The official documentation to get you started can be found here.

Azure – How to add all the dates list from excel sheet and will ingest to SQL Server using Logic Apps

I would like to know on how we ingest add all the dates in column from excel sheet to SQL Server using Logic Apps. I tried to use Compose and addDays expression but there’s an error. Can you please help us what would be the right expression to show all the dates to the SQL tables:

enter image description here

enter image description here

enter image description here

Looking forward to ingest all the dates in the SQL Tables.

Tags:

3

Answers


  1. Chosen as BEST ANSWER
    0

    RithwikBojja, Thank you for all the help. I tried to update the addDays expression but there's still an error:

    Input from Excel:

    enter image description here

    Error in Designer:

    enter image description here


  2. 0

    I have reproduced in my environment and expected results are as below:

    My table in Excel (Input):

    enter image description here

    Design:

    enter image description here

    addDays('1899-12-30', int(items('For_each')?['Date']))

    Output:

    enter image description here

    Login or Signup to reply.
  3. 0

    Apologies, here is the screenshot of the error:

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search