cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidS47
New Member

Issues With Emailing a Collection

Hi,

 

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

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

ChrisR
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...

 

Thanks,

Chris

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (42,354)