cancel
Showing results for 
Search instead for 
Did you mean: 

Nested for each loops implementation for sql actions

Hi,

 

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

 

Regards

Lohit

Status: New
Comments
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.