Unanswered

Using SQL Query Results from the SQL Action used inside a Apply to each

(0) Share

Report

Posted on by dsab81 Microsoft Employee

Hi,

I have situation where i have to run a sql query within a 'apply to each' to get some results from the variables within in the 'apply to each' , and pass it down stream to other new action with in the same 'apply to each'

But when i do it , the SQL objects results are not being shown on the right, when i wanted to use the 'Result Sets' into the compose action ( the last compose action at the end ).

The lock here is that the SQL query needs paremetres from the variables within Apply to each , so i cannot move it outside Apply to each.

Please suggest an alternative approach?

Can i Setup another flow to run SQL Query within the apply to each ?

and

whether it would allow me to pass the variable values from this flow to the child flow ?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

PrasadAthalye on at

Like (0)

Report

Resultsets should be available in compose. Are you not able to see it in dynamic content? I am able to find it...

May be you can remove and add the action again...

Was this reply helpful? Yes No
dsab81 Microsoft Employee on at

Like (0)

Report

i could not find the results of sql in dynamic content when i use Execute SQL Query , but works when i use some other action like 'Get rows' etc..

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report

Something strange. as you can see, I am able to get it in dynamic content. Is your connection to action broken? Can you add another action? What happens when you click compose and open dynamic content?

Was this reply helpful? Yes No