cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MannOnion
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.  

LogonPassword
Name.SurnameTemppassword

 

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. 

 

t2flow.PNG

t2flow1.PNG

 

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

 

 

 

 

4 REPLIES 4
CFernandes
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 

 

t2flow3.PNG 

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
Helper I
Helper I

I have still been unable to get this working 😞 

Helpful resources

Announcements
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)