How to create a CSV with every result of the Loops?

[jroberto]

Hi;

My flow has 30 loops, each loop has 50 lines, 1500 lines total.
How to create a CSV with 1500 lines?
I only managed with the last 50 lines (loop 30).

Thank`s for the attention.

[Pstork1]

It will be somewhat slow, but the easiest way to do this is to create an array variable before entering the loop.  Then append each line to the array variable inside the loop.  After exiting all the loops you can create the CSV from that array variable.

[jroberto]

Hi;

I created a variable before the loop (varData2CSV).
In the loop I created "Append to Array Variable" for this variable.
Returned the error message:
"ActionFailed. An action failed. There are no successful dependent actions."

Grateful for the attention!

[Pstork1]

Please show the Initialize variable declaration and how you are formatting the append to array.  The append to array has to be in the format of a JSON record.

[jroberto]

Variable before the loop (varData2CSV) type "Array".
"Append to Array Variable" into the loop.

Thank`s.

[Pstork1]

You can't just append the values as a string to the array if you want to create a CSV.  It needs to be in the form of a JSON record.  It would look something like this

{
  "Column1": <<dynamic value>>,
  "Column2": <<dynamic value>>,
  "Column3": <<dynamic value>>
}

Where Column 1, 2, and 3 are the column names you want in the CSV and the <<dynamic value>> is replaced with whatever values you are getting in the loop.

[jroberto]

Hi;

I change the flow and receive message "ActionFailed. An action failed. There are no successful dependent actions."
"Append to Array Variable" into the loop received Compor values.

I tried using "union(outputs('Compor'),variables('varDados2CSV'))", but it also got an error.

Thank`s for the attention.

[Pstork1 · Accepted solution]

You can't append an array to an array.  You have to append an individual record.  That means the append needs to happen when you process each line, not all 50 lines.  If the HTTP call returns 50 lines in an array, then you'll need another loop inside this loop to process each line and append it to the array.

[jroberto]

Hi;

This is solved.

Many thank`s.