Use Excel Rows As Input Parameter in Stored Procedure

Beyza Kızılkaya 1 Reputation point
2021-06-09T08:46:32.407+00:00

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
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,463 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ChaitanyaNaykodi-MSFT 27,366 Reputation points Microsoft Employee
    2021-06-09T21:30:33.417+00:00

    Hello @Beyza Kızılkaya , 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!

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.