Nested Query, need help!

[Draax]

Hi,

I cant figure our why I cant add the result from the 'Execute a SQL query (V2)' to Apply to each 3.

I want to create a task in planner for each record found in the SQL query.

I have tried this but it just generates an error:   <body('Execute_a_SQL_query_(V2)')?['resultsets']>

What am I missing?

[Jcook]

Hello,

Can you try to use a Compose action and pass the value of the SQL in there and reference the Output of the Compose in the loop.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Draax]

Hi Josh,

Many thanks for your reply!

I tried your advice, unfortunately I received this error:

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_3' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose')' is of type 'Object'. The result must be a valid array.

Any idea why?

-Draax

[Jcook · Accepted solution]

Hi,

In the last run you just had copy the contents of the Compose output (this will be JSON most likely)

Now go back to edit flow and add a Parse JSON under your Compose. Add the input from the Compose, and click generate from sample payload. Paste the Compose output from the run in there.

Now in your Apply to each loop 3 there should be values you can reference.

What I think is going on here is that there are multiple objects that can be used and that’s why the loop is not picking up dynamic content.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Draax]

@Jcook 

Many thanks!

Everything now works as intended, excellent work!

/Draax 

[Shadow06]

I am in similar Position, not able to access the body/Result of the 2nd loop which is nested inside. and i am using this exp in second apply to each, <@{outputs('Execute_a_SQL_query_to_the_the_ attendence_in_each_class')?['body/resultsets/Table1']}> and gives the following error : "Correct to include a valid reference to 'Execute_a_SQL_query_to_the_the_ attendence_in_each_class' for the input parameter(s) of action 'Apply_to_each_2'."