XML List as Input Parameter of Stored Procedure in Logic App

Beyza Kızılkaya 1

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?

Mike Urnun 9,821 Reputation points Microsoft Employee

2021-06-30T01:51:56.733+00:00

Hello @Beyza Kızılkaya - If the data transformation is done correctly with Excel -> XML, the intended values should become available & be represented as Dynamic Content in the subsequent Actions. Could you share a screenshot of your Logic Apps workflow? Be sure to omit any private details.
Beyza Kızılkaya 1 Reputation point

2021-06-30T08:59:02.96+00:00

Hello @Mike Urnun
You can find below my flow step by step:

2 answers

Mike Urnun 9,821 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:

Could you try that out and see if that helps? Set variable action is for non-collection types such as Strings, Integers, etc.
Please sign in to rate this answer.
Mike Urnun 9,821 Reputation points Microsoft Employee

2021-07-02T00:30:18.637+00:00

Hi @Beyza Kızılkaya - Just checking in here, let me know if you were able to get the values as Dynamic Content in your Logic Apps workflow or had any further questions.

Beyza Kızılkaya 1 Reputation point

2021-07-05T14:23:52.633+00:00

Hello @Mike Urnun ,
Sorry for late return, I could try today. I have changed set variables with the append to array variable.

But while I'm trying to save I'm getting below error:
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Beyza Kızılkaya 1 Reputation point

2021-07-05T14:24:59.053+00:00

Also, below is my updated flow:
Please sign in to rate this answer.
Mike Urnun 9,821 Reputation points Microsoft Employee

2021-07-12T07:05:34.23+00:00

Hey @Beyza Kızılkaya - It looks like you're using the Append operation in two places (both outside and inside of the For each loop) and that's maybe where the issue is.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

XML List as Input Parameter of Stored Procedure in Logic App

2 answers

Your answer