HTML table duplicating the same row equal to the total rows in apply to each. Rather than sending 252 emails with a one row table it sends 252 emails with the table duplicating the correct row 252 times.

[MannOnion]

HI All, 

I have a flow that takes a user's credentials from an excel.

Each user is emailed their credentials and should be receiving one row with their credentials.  

Logon	Password
Name.Surname	Temppassword

instead, It duplicates the row for the number of users. There are 252 users to be emailed but they all receive a table with their own credentials duplicated 252 times. 

Do I need to change the order of my flow to prevent this?

[CFernandes]

Hey @MannOnion ,

I assume you have the send an email action inside the loop - If yes, you need to bring it outside the loop -

• Try to Initialize a variable outside the Loop 
• Set variable inside the loop.
• Use the variable in your email.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

[MannOnion]

Hi , 

I am not sure if I understood the instruction. 

I did set the variable but got an error as it wasn't a string. 

I changed the flow to this : 

initialise variable - outside of the loop

append to array - inside the loop using current item 

Then using the variable to create the table 

I ran a test with 4 users : 

1st user - 2 row table

2nd- 2 row table 

3rd - 3 row table 

4th - 4 row table 

 

[MannOnion]

I have just tried again using auto HTML table rather than custom and that sent : 

1st user - just their credential 

2nd - 2 users' credentials

3rd - 3 users' credentials

4th - 4 users' credentials

[MannOnion]

I have still been unable to get this working 😞