Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

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.

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.  



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?





Super User
Super User

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.


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 



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


Helper I
Helper I

I have still been unable to get this working 😞 

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (3,551)