Showing results for 
Search instead for 
Did you mean: 

Nested for each loops implementation for sql actions



I am working on a flow and the i have the below steps to work on


Step1:- Using Get-Rows sql action to pull all the data

Step2:- Using the apply to each action then compose to take out the specific column and to send it to kusto to check for update.

Step2(a):- Using update sql action to update all the values but i am unable to go ahead to do an update as it is showing me an error as an output is an array and hence a foreach loop cannot be nested inside another foreach loop

Can you please implement the nested loops functionality in Flow for the sql actions



Thanks in Advance




Status: New
Frequent Visitor

Just a workaround. 


Split your flow into two flows.

Connect them via file or Azure Service Bus.

In my case, I use OneDrive and file.