question

BeyzaKzlkaya-3739 avatar image
0 Votes"
BeyzaKzlkaya-3739 asked emilyhua-msft edited

Use Excel Rows As Input Parameter in Stored Procedure

Hello,
I'm working on a logic app.
In this logic app I have an excel table and there are 4 columns of this excel table.
I'm using list rows present table and then I need to run my stored procedure.
This stored procedure has 3 ınput parameters. Two of them is static, but the last one is an xml list.
I need to use these 4 columns as a input parameter in the stored procedure, because after that I'll insert this result set into a db table.
103811-logicapp.png



how can i handle this flow? thanks

azure-logic-apps
logicapp.png (26.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BeyzaKzlkaya-3739
As this issue is not related to Excel, I would remove the tag "office-excel-itpro".
Thanks for your understanding.

0 Votes 0 ·

1 Answer

ChaitanyaNaykodiMSFT-9638 avatar image
0 Votes"
ChaitanyaNaykodiMSFT-9638 answered

Hello @BeyzaKzlkaya-3739, Thank you for reaching out.

Based on this question here with similar issue. Could you try adding the input parameters via the code-view of the Logic App?

If this does not help resolve the issue, could you please elaborate more on the issue faced or the error received?
Please let me know if there are any additional concerns. Thank you!


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.