Send email with all information from PowerApps as body

[Anonymous]

Hi I have faced a problem with combining all information from my PowerApps form to send and email. Please take a look into my screenshot. What I am trying to do is to fit into email BODY all information from combo boxes, text input field, date picker, checkbox and invisible field of submitters name.  Honestly I have no idea how to combine all that together to sent this email. 

My problem is only (sic!) the body of the email. I kind of handle the rest of it.

Thanks,

M.

[TheRobRush]

@Anonymous try removing the attachment portion of the email formula. Have suspicions that is where the error is located, but need to verify

[v-albai-msft]

Hi @Anonymous ,

So strange, I have tested this with attachment, but everything works well on my side.

Not sure but you can have a try to remove AddColumns function, use this:

{
Attachments: RenameColumns(AttachmentAdd.Attachments, "Value", "ContentBytes" ),Importance: "Normal"}

If still not work, to narrow down your issue, add a gallery and set its Items to AttachmentAdd.Attachments, I need to check the structure of this table, here is my result:

Best regards,

Allen

[Anonymous]

Hi, I don't think it has anything to do with attachmentt. I just tried to remove this part where code gathers information from combo boxes and it worked - meaning it created text in a html box. So the question would be what in this part:

***

"<ol>"&
"<li>"&Concatenate(Text(Concat(xCode.SelectedItems, Value&" ")), " ", Concat(Country.SelectedItems, Value&" "))&"</li>"
&
"<li>"&Concatenate(Text(Concat(xCode_1.SelectedItems, Value&" ")), " ", Concat(Country_1.SelectedItems, Value&" "))&"</li>"
&
"<li>"&Concatenate(Text(Concat(xCode_2.SelectedItems, Value&" ")), " ", Concat(Country_2.SelectedItems, Value&" "))&"</li>"
&"</ol>"&

***

is incorrect. This is the only part that does not work here... Any ideas @v-albai-msft @TheRobRush ?

[TheRobRush]

Did a test on my side with two of my own combo boxes and a date picker. Combo Boxes were named combobox4 and combobox5  in my code. Below is code I used an a screenshot of them email it sent me. ComboBox4 was a list of country names (text), ComboBox5 was a list of numbers (values).

Office365Outlook.SendEmailV2(
"microsoft.powerapps@randomcompanyname.com",
"New Ticket",
"Please create new ticket for:" & 
"<ul>"&
  "<li>"&Concatenate(Text(Concat(ComboBox5.SelectedItems, Value&" ")), " ", Concat(ComboBox4.SelectedItems, Value&" "))&"</li>"&
  "<li>"&Concatenate(Text(Concat(ComboBox5.SelectedItems, Value&" ")), " ", Concat(ComboBox4.SelectedItems, Value&" "))&"</li>"&
  "<li>"&Concatenate(Text(Concat(ComboBox5.SelectedItems, Value&" ")), " ", Concat(ComboBox4.SelectedItems, Value&" "))&"</li>"&
"</ul>"&
"Due date: "&DatePicker1.SelectedDate&"<br>"&
"BR,"&"<br>"&
"John Barrow")

[Anonymous]

Thanks, but still, it does not work for me. When I use plain text instead of combo boxes, it's working, but not when I'm using the code. I will try to figure out why it is like that...maybe it's about the connection with the data source that does create this error. 

[Anonymous · Accepted solution]

Hi, so i have figured it out. The line of code should look like that:

"<li> "&Concatenate(Concat(xCode.SelectedItems,x_x0020_Code_x0020_ID,";"),";;", Concat(Country.SelectedItems,CountryCode,";"))&" </li>"&

where I am not pointing to "VALUE", but rather to the source column name.

[mogulman]

I have to send out about 20 different emails types and who they go To, CC'ed or BCC'ed is complicated.   Also some emails have Calendar (.ics) files attached.  We use Azure SQL DB.  I wrote an Azure Function App that handles emails.  They are timer triggered and look for emails that need sending.  Some run every 2 hours between 8-18 ("0 2 8,10,12,14,16,18 * * Mon,Tue,Wed,Thu,Fri" ) others run every 5 minutes ("0 2/5 8-20 * * Mon,Tue,Wed,Thu,Fri").  I wrote it in C#.  Works great and keeps Powerapp simple.

[TheRobRush]

Yes, if it's from a combo box linked to a sp list or other source data, always call on the results column value, not just the combobox value. Glad you got it fixed!

[v-albai-msft]

Hi @Anonymous ,

Glad you have solved the issue.

We all miss the most basic point. 

Since the issue is solved, you can mark the helpful reply as solution. This will benefit other community members who stuck with the same question.

Best regards,

Allen