Email help

(0) Share

Report

Posted on by dandandsan

Hello,

I'm struggling to get my head around this one and hoping someone can help me.

I have an email button which looks like this and works fine

Office365Outlook.SendEmailV2("emailaddress","Stock", "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
 "<tr style='background-color:#efefef'>
 <th>Description</th>
 <th>Device</th>
 <th>Current Level</th>
 </tr>" & 
Concat(colTonerStock,
 
 "<tr>
 <td>" & Title & " </td>
 <td>" & Device & " </td>
 <td>" & CurrentLevel & " </td>
 </tr>"))

I have created a dropdown which is using basic Sharepoint list of usernames and email addresses

If I use the following it works fine and sends an email based on the dropdown selection

Office365Outlook.SendEmailV2(Dropdown4.Selected.email,"Test","Test")

If I add the line into the HTML code I get a red X and can see why this would be a problem

Office365Outlook.SendEmailV2(Dropdown4.Selected.email,"test","Test1") "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
 "<tr style='background-color:#efefef'>
 <th>Description</th>
 <th>Device</th>
 <th>Current Level</th>
 </tr>" & 
Concat(colTonerStock,
 
 "<tr>
 <td>" & Title & " </td>
 <td>" & Device & " </td>
 <td>" & CurrentLevel & " </td>
 </tr>"))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

RezaDorrani 12,143 on at

Like (0)

Report
@dandandsan

try this

Office365Outlook.SendEmailV2(Dropdown4.Selected.email,"test","Test1", "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th>Description</th> <th>Device</th> <th>Current Level</th> </tr>" & Concat(colTonerStock, "<tr> <td>" & Title & " </td> <td>" & Device & " </td> <td>" & CurrentLevel & " </td> </tr>")))

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Christopher S on at

Like (0)

Report

Hi @dandandsan

At the end of the first line, there is a ")" that is making issues with the function, as @RezaDorrani you will have to remove it and input a "," instead.

Best Regards,
--
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

Ajityadav 23 on at

Like (1)

Report
Hi @dandandsan
use this formula:- it will work
Office365Outlook.SendEmailV2(Dropdown4.Selected.email,"test","<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th>Description</th> <th>Device</th> <th>Current Level</th> </tr>" & Concat(colTonerStock, "<tr> <td>" & Title & " </td> <td>" & Device & " </td> <td>" & CurrentLevel & " </td> </tr>"))
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
alrezac on at

Like (0)

Report

Hi,

Looks like there have been quite a few good replies here. If you are still having trouble after these suggestions you can always create a ticket with Microsoft Support to help take a look. I'll include a link below; if you would like to go down that route. In addition remember to mark the answer that helped you the most as the answer.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
dandandsan 98 on at

Like (1)

Report

Thank you to everyone for your help and advice. Removing the ")" did the trick 🙂

Was this reply helpful? Yes No