Do until is not stopping after the variable met the condition of loop termination

(0) Share

Report

Posted on by TreeTreeTree

I was doing automation for exporting a table for 10 stores and save as a csv file from Power BI to sharepoint.

The output of the flow is good, but the flow does not stop as defined.

At first, I was thinking maybe I shall put the 'Increment variable' outside of 'Apply to each', but not working.

Then, I was thinking maybe the 'Apply to each' shall only include 'Create file in sharepoint', still not working.

Could someone help me to see which step did I do wrong? The variable 'StoreIndex' does increment, but the stopping point 'StoreIndex' <= 3 is not executed.

Below are two versions of this flow.

Thanks in advance.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

TreeTreeTree 18 on at

Like (0)

Report

I kind of figured out it was caused by referring Power BI columns while creating sharepoint files, the Power BI column involvement forced the step to be put in 'apply to each'. Without referring Power BI columns, the 'apply to each' is not automatically added. Continuing fixing the issues. This brings a point that the variable 'StoreIndex' defined in Power Automate is not equivalent to the 'StoreIndex' column I defined in Power BI. They are parallel independent code running by themselves, even though I use one to model the value of the other.

Was this reply helpful? Yes No
Verified answer

TreeTreeTree 18 on at

Like (0)

Report

The 'Apply to each' is the cause of endless loop for this case and the cause of 'Apply to each' automatically added for a step is the referring of Power BI Columns.

Was this reply helpful? Yes No