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?
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.