Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
Also, below is my updated flow:
XML List as Input Parameter of Stored Procedure in Logic App
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 62%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Beyza Kızılkaya
1
Reputation point
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
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 87%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Mike Urnun 9,792 Reputation points Moderator2021-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.
-
Sign in to comment
2 answers
Sort by: Most helpful
-
Beyza Kızılkaya 1 Reputation point
2021-07-05T14:24:59.053+00:00 -
Mike Urnun 9,792 Reputation points Moderator
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 -
-
Mike Urnun 9,792 Reputation points Moderator
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.
-
Mike Urnun 9,792 Reputation points Moderator
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 -