web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : aoOP6efA1njZBa+S+JH0wX
Power Apps - Building Power Apps
Answered

Email help

Like (0) ShareShare
ReportReport
Posted on 27 Apr 2020 18:38:08 by 98

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:
I have the same question (0)
  • dandandsan Profile Picture
    98 on 28 Apr 2020 at 05:55:32
    Re: Email help

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

  • alrezac Profile Picture
    on 27 Apr 2020 at 21:06:09
    Re: Email help

    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.

  • Verified answer
    Ajityadav Profile Picture
    23 on 27 Apr 2020 at 21:01:37
    Re: Email help

    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.

  • Christopher S Profile Picture
    on 27 Apr 2020 at 20:16:50
    Re: Email help

    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!

  • RezaDorrani Profile Picture
    12,141 on 27 Apr 2020 at 18:44:09
    Re: Email help

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 892 Most Valuable Professional

#2
Power Apps 1919 Profile Picture

Power Apps 1919 356

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 310 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete