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

Question

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

Naveen 0

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 flow User'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.

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-29T06:12:16.22+00:00

@Naveen Thanks for reaching out. Have you validated the output of your Execute a sql query V2 action? As per the error it looks like the return value is not of type array or it is null therefore your Create CSV table action failed.

In case if it returns the array then first validate if the result is not empty or not null then only execute your Create CSV table action.
Naveen 0 Reputation points

2023-11-29T08:14:07.3166667+00:00

Hi @MayankBargali-MSFT

Yes it is returning the values of object. It is not null. Can you help me out how to convert results into Array. I have tried all possible ways like compose, parse JSON and etc but failed to store the results in CSV table followed by sharepoint folder.

I am attaching results output from Execute SQL query below

and the above results, I am passing as input to create CSV table action
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-29T08:39:46.9066667+00:00

@Naveen The output that you share is from Execute_a_SQL-query_(V2) action? As the output should be starting from Table1 property and not from property.

You need to use something as below i.e. get the Table1 property which has the array value

body('Execute_a_SQL_query_(v2)')?['resultsets']?['Table1']}
Naveen 0 Reputation points

2023-11-29T09:19:30.6533333+00:00

You are right, the above one is the input of create CSV table action. The output of execute query is below

So you mean I have to use below expression as input in create CSV table action?

body('Execute_a_SQL_query_(v2)')?['resultsets']?['Table1']}
Naveen 0 Reputation points

2023-11-29T09:31:41.97+00:00

I have used the expression you have given and throwing below error while saving
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-12-05T07:41:17.1666667+00:00

Hi @Naveen

Following up to see if my answer helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-12-06T06:20:12.47+00:00

Hi @Naveen

I hope the answer and comment helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.

1 answer

Your answer

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-29T06:12:16.22+00:00

@Naveen Thanks for reaching out. Have you validated the output of your Execute a sql query V2 action? As per the error it looks like the return value is not of type array or it is null therefore your Create CSV table action failed.

In case if it returns the array then first validate if the result is not empty or not null then only execute your Create CSV table action.
Naveen 0 Reputation points

2023-11-29T08:14:07.3166667+00:00

Hi @MayankBargali-MSFT

Yes it is returning the values of object. It is not null. Can you help me out how to convert results into Array. I have tried all possible ways like compose, parse JSON and etc but failed to store the results in CSV table followed by sharepoint folder.

I am attaching results output from Execute SQL query below

and the above results, I am passing as input to create CSV table action
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-29T08:39:46.9066667+00:00

@Naveen The output that you share is from Execute_a_SQL-query_(V2) action? As the output should be starting from Table1 property and not from property.

You need to use something as below i.e. get the Table1 property which has the array value

body('Execute_a_SQL_query_(v2)')?['resultsets']?['Table1']}
Naveen 0 Reputation points

2023-11-29T09:19:30.6533333+00:00

You are right, the above one is the input of create CSV table action. The output of execute query is below

So you mean I have to use below expression as input in create CSV table action?

body('Execute_a_SQL_query_(v2)')?['resultsets']?['Table1']}
Naveen 0 Reputation points

2023-11-29T09:31:41.97+00:00

I have used the expression you have given and throwing below error while saving
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-12-05T07:41:17.1666667+00:00

Hi @Naveen

Following up to see if my answer helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-12-06T06:20:12.47+00:00

Hi @Naveen

I hope the answer and comment helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.

Answer 1

MayankBargali-MSFT 70,936 Moderator

@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.

Share via

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

1 answer

Your answer