XML List as Input Parameter of Stored Procedure in Logic App

Beyza Kızılkaya 1 Reputation point
2021-06-29T14:26:31.277+00:00

Hello,
I'm trying to create a logic app flow. I have an excel file and I need to use columns of excel file as xml list. Because I'll use these xml list for an input of stored procedure.
I have initialized variable as empty at first step.
Then I have listed my excel file, then I have set variable such as xml format.
But when I choose the stored procedure, I cannot see my variable to set parameter value.
Is there any way to handle this problem?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,827 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mike Urnun 9,646 Reputation points Microsoft Employee
    2021-07-01T03:43:29.897+00:00

    Hi @Beyza Kızılkaya - Thank you for providing more information. It looks like you have initialized your variable as a type of Array. In order to populate an Array with values, you'll want to choose the Append to array variable action:

    110843-image.png

    Could you try that out and see if that helps? Set variable action is for non-collection types such as Strings, Integers, etc.

  2. Beyza Kızılkaya 1 Reputation point
    2021-07-05T14:24:59.053+00:00

    Also, below is my updated flow:

    111885-image.png