How to send query results to sharepoint folder through for each loop

Naveen 0 Reputation points
2023-11-29T01:40:20.9666667+00:00

Hello,

I have two SQL queries that should be executed and results be stored in sharepoint with two different CSV file names.

Below is the picture of my logic app flowUser's image

User's image

Upon executing the logic app, I am getting the error below at Create CSV table operation inside for each loop.User's image

Please find initialize variable values below.User's image

Can someone help me to store results set of above queries with the given file names of each in Sharepoint folder.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,982 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MayankBargali-MSFT 69,991 Reputation points
    2023-12-01T02:30:38.72+00:00

    @Naveen It should be expression value and not copy paste the expression directly in the from body.

    Remove the value and Click on your From text box and there would be one pop up and then click on expression.

    Now use the value that I provided and paste it and click on OK.User's image

    Note: The value could be changed inside body as per your name of the action.

    body('Execute_a_SQL_query_(v2)')?['resultsets']?['Table1']}

    In case if you are still facing the issue then I can connect with you offline to assist you.

    0 comments No comments