Hi All,
Obviously this question has been answered a lot of times over here, but unfortunately, none of the solutions are working with my set up and if any of you encountered the same issue and got a solution, I really appreciate your help.
So, I have the following set up of my power app:
The Outlook and my Collection are source of my data.
I have a Vertical Gallery where I want the user to fill up some fields and after clicking on Submit, I would like the data coming on my email in a formatted table.
So, my "+" add icon, to add a new gallery item is set up as follow:
Collect(
DetailCollection,
{
Id: Text(Last(DetailCollection).Id + 1),
Sitename: "",
Maker: "",
Model: "",
Capacity: "",
Rrp: "",
Currency: "",
Accidental: "",
Liquid: "",
Theft: ""
}
)
After the user add as many gallery items as is needed, I placed a Submit button where the set up is as follow:
Office365Outlook.SendEmailV2("myemail@example.com", "Table Update",
"<table width='100%' border='1' cellpadding='5' style='border: 1px solid #000; border-collapse: collapse'>"&"<tr>
<th>Site</th>
<th>Maker</th>
<th>Model</th>
<th>Capacity</th>
<th>RRP</th>
<th>Currency</th>
<th>Accidental & Breakdown</th>
<th>Liquid Damage</th>
<th>Theft & Loss</th>
</tr>
<tr>"& Concat(
DetailCollection,
"<td>"& Sitename &"</td>"&
"<td>"& Maker &"</td>"&
"<td>"& Model &"</td>"&
"<td>"& Capacity &"</td>"&
"<td>"& Rrp &"</td>"&
"<td>"& Currency &"</td>"&
"<td>"& Accidental &"</td>"&
"<td>"& Liquid &"</td>"&
"<td>"& Theft &"</td>",
"</tr><tr>"
)&"</table>")
All items are text field where any word or number can be placed in.
I have no errors with the set up, the table with the headers are being sent to the email, but not the data from the fields.
Any help is appreciated.
Kind regards,
Fernando