Showing results for 
Search instead for 
Did you mean: 
New Member

Issues With Emailing a Collection



I am new to power apps but have gained some ground in the last 2 months and now I have hit a road block and was wondering if someone could help me? I have built a portion of my app where my regional sales managers can request product samples and send me an email notification. I have built the collection and can email my collection - NO PROBLEM. My problem is that My collection will ONLY email the latest entry. So lets say I have 5 Unique entries in my collection - When the email notification is sent - I will only see the latest entry - 5 times in a row, I don't get the rest od the unique entries in the email. Has anyone come across this before? Please help and thanks

Resolver I
Resolver I

Would you be able to provide a bit more detail about how you are sending the email? What service are you using (Flow, the Office365 connector etc.)? What are the formulas you are using/have tried? How is the collection being sent (csv file attached, HTML table etc.)?

Thanks for getting back to me. 


1: I am using Office 365 Outlook to send the email

2: I am sending a TABLE

3: I have attached images of how I have set everyting up


The 1st image is of the way I have set up the code to collect the info to create the collection

The 2nd image - You see that the collection IS working because you see 2 unique entries

The 3rd Image is the code used to email the collection




Here is an image of the email the receiver actually gets. You see that it does identify 2 entries BUT it repeats the LAST entered entry as many times as there are entries in the collection. In this case - 2

Resolver III
Resolver III

The column name in your collection is RSM and I_IRDSM is the control.


So, when you say Concat(SampleReq2, "RSM: " & I_IRDSM... the I_IRDSM control's value will have the last data entered.  It is iterating though the collection the correct amount of times, just pulling the same data from the control I_IRDSM everytime.


Use the collection's column name, try:


Concat(SampleReq2, "RSM: " & RSM...




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,637)