cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tianaranjo
Level 8

Html text to email - multiple tables

Greetings, 

I created a Gantt chart:

  • 1 - HTML Text control
    • 3 tables within the control for each 'bar'

I would like to email the results via PowerApps Office365 datasource:

Office365.SendEmail("name@bnsf.com","Gantt",
eMailText3_1.HtmlText,
{IsHtml: true}
)

This (almost) works. Gantt piece works great.  And the first table emails as intended.  However, the other tables do not pass into email correctly. 

The two screen shots show the Gantt in PowerApps and the email that is currently sent.**Note - in order for the Gantt to line up correctly, multiple tables are required.

image.pngThe HTML text is: 

" <table border='0' cellpadding='0' cellspacing = '0' style='border:0px solid white; border-collapse:collapse'width = '100%' " & 
        "<tr>" &
            "<td 
                style = 'background-color: #ffffff'
                width = ' 10%' 
            > 
                Slow Order: "&Start1_1.Text&"
            </td>" & 
            
            "<td style = height:'25px' width =' "& w_t2c2_3 & " %'>" &
                Concat(colGanttPrimaryLine, " <img src=" & Thumbnail.Large& " width = ' " & imgSrcWidth_2 & "' height = '20'; "">" ) & 
            "</td>"  &  

            "<td style = 'background-color: #ffffff' width = ' ' >" & 
                End1_1.Text & " 
            </td>" &
        "</tr>" & 
"</Table>" &

"<table border='0' cellpadding='0'cellspacing = '0' style='border:0px solid white; border-collapse:collapse width = '100%' " & 
        "<tr>" &
            "<td style = 'background-color: #ffffff'width = ' "& wt2c1_1 &"  %'>
                Input 1: "&Start2_1.Text&"
            </td>" & 
            "<td style = height: '25px'width =' "& w_t2c2_3 & " %'>" &
                Concat(colGanttLine1, " <img src=" & Thumbnail.Large& " width = ' " & imgSrcWidth & "' height = '20'; "">" ) & 
            "</td>"  &  
            "<td style = 'background-color: #ffffff'width = ' ' >" & 
                 End2_1.Text & " 
            </td>" &
        "</tr>" & 
"</Table>" &

"<table border='0' cellpadding='0'cellspacing = '0' style='border:0px solid white; border-collapse:collapse'width = '100%' " & 
        "<tr>" &
            "<td style = 'background-color: #ffffff'width = ' "& w_t3c1_1 &"  %' >
                Input 2: "&Start3_1.Text&"
            </td>" & 
            "<td width =' "& w_t3c2_1 & " %'>" &
                Concat(colGanttLine2, " <img src=" & Thumbnail.Large& " width = ' " & imgSrcWidth_1 & "' height = '20'; "">" ) & 
            "</td>"  &  
            "<td style = 'background-color: #ffffff'width = ' ' >" & 
                 End3_1.Text & " 
            </td>" &
        "</tr>" & 
"</Table>" 

 

 

6 REPLIES 6
Highlighted
tianaranjo
Level 8

Re: Html text to email - multiple tables

 
Mickyw
Level 8

Re: Html text to email - multiple tables

Are you sure your Concat syntax is ok. I see the double quote is not closed before last semicollon:

Concat(colGanttLine2, " <img src=" & Thumbnail.Large& " width = ' " & imgSrcWidth_1 & "' height = '20'; "">" )

I'ld open received mail message source and look if it contains what you generated. Maybe it is just HTML syntax issue which causes tables are not rendered by email client.

 

Mick

 

 

tianaranjo
Level 8

Re: Html text to email - multiple tables

Raising this to the top hoping to catch the attention of the likes of @CarlosFigueira Smiley Happy 
Or @v-xida-msft since you answered one along these lines elsewhere  

 Or anybody else who might know.  

@Mickyw - thanks for the reply but that doesn't seem to be the issue.  

tianaranjo
Level 8

Re: Html text to email - multiple tables

Please disregard - I figured it out.  The results shown here.  First image is from the PowerApp, second is the email result.image.pngimage.png

Mickyw
Level 8

Re: Html text to email - multiple tables

Hi @tianaranjo

 

I think important value of such community forums like this is to provide solution if it exists. Even if you were able sort it out on your own or it was you mistake or something else - others looking for simillar issues might benefit from your experience. 

 

Regards,

Mick

tianaranjo
Level 8

Re: Html text to email - multiple tables

@Mickyw I totally agree; I have learned so much from this community.  I will share the solution soon; currently we are trying to fine tune and release this app on a tight timeline. So we are feverishly working to get it out the door.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 46 members 4,904 guests
Please welcome our newest community members: