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 ?
whether it would allow me to pass the variable values from this flow to the child flow ?
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...
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?
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.