Variable with each for loop

[Bapt_69]

Hi everyone,

I wrote something on this post (solved) :

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Using-apply-to-each-create-HTML-table-an...

I create again a new post with my problem.

I want to create an array for each provider (with orders). Then, I send an email with it.

I initialize the variable (type=array) then I start a loop "each for". I append the array variable then, the mail is sending.

But.....when the loop "restart", the initialisation is not setting! So the array become bigger and bigger...

here is my Flow :

Apply2 details :

Thanx for all,

Baptiste

[v-bacao-msft]

Hi @Bapt_69 ,

You could add Set variable action below Create HTML table action to empty the current array.

Like:

Best Regards,

[Bapt_69]

lol

I already tried...

Not working cause the "set variable" action is not available in a loop. You are able to set it only out of every loop.

[v-bacao-msft]

Hi @Bapt_69 ,

Best Regards,

[Bapt_69]

Sorry,

I'm confusing between "set" and "intialize" 😉

"Set" is ok. Thank you.

I guess "[]" means you make the variable empty? Cause you have to fill the field.

[v-bacao-msft]

Yep.

[Bapt_69]

Something wrong...sorry... 😞

My variable stay empty...even after the loop, after appending values.

Take a look on my flow :

Take a look on the "apply 2" details :

[v-bacao-msft]

Hi @Bapt_69 ,

You could add Set variable action below Create HTML table action to empty the current array.

Best Regards,

[Bapt_69]

Ok I put "create the HTML table" right before "Set variable" (at the start of my loop) and the issue is the same...

My table is empty...

[v-bacao-msft]

Hi @Bapt_69 ,

Please try to observe the execution result of each action in Flow run history, whether it is in line with expectations.

For example, check whether there is value in Append to array variable action, or it is only null value every time. Your current configuration is no problem. It seems that data that is not in accordance with expectations is filtered out and appended to the array variable.

Or you could try to configure Set variable action to the last step of Apply to each 3.

Best Regards,