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
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
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...
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.