HTMLtext1.HTMLText generates more columns than I specify

[Hetkey]

I'm at my wit's end. My HTMLText looks like this:

<th>Equipment</th><th>Applications</th><th>Licenses</th>
</tr>
"& Concat(
'I/T Equipment Orders',
"<td>" & Label2 & "</td>
<td>" & Label4 & "</td>
<td>" & Label3 & "</td>")
&"


</table>"

but when I look at HTMLText1.HTMLText it looks like this:

<th>Equipment</th><th>Applications</th><th>Licenses</th> </tr>

<td></td>

<td></td>

<td></td>

<td></td>

<td></td>

<td></td>

<td></td>

<td></td>

<td></td>

<td></td>

<td></td>

<td></td>

</table>

The output has 3 correct columns with the headers and nearly a dozen extra (headerless) columns with the same data in each.

My vacation starts in 20 minutes and I'm not going to be able to "Not Work" on this if I can't fix it.

Thanks

[WarrenBelz]

Hi @Hetkey ,

I free-typed this - will test it if wrong

<th>Equipment</th>
<th>Applications</th>
<th>Licenses</th>
<table>"
    & 
   Concat(
      'I/T Equipment Orders',
      "<tr><td>" & Label2 & "</td><td>" & Label4 & "</td><td>" & Label3 & "</td></tr>"
   )
& "</table>"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[RandyHayes]

@Hetkey 

Your table is not formatted properly and you are also specifying controls for your data...not the text.

Please consider changing your Formula to the following:

"<table>
    <tr>
       <th>Equipment</th><th>Applications</th><th>Licenses</th>
    </tr>
"& Concat(
'I/T Equipment Orders',
    "<tr>
        <td>" & Label2.Text & "</td>
        <td>" & Label4.Text & "</td>
        <td>" & Label3.Text & "</td>
     </tr>")
& "
</table>"

I hope this is helpful for you.

[Hetkey]

Close but no banana I'm afraid. Please see screenshot.

Thanks so much

[Hetkey]

Slightly closer but still the same lack of Banana. Got the columns sorted out and spawned a bunch of extra rows. Please see screenshot.

[Hetkey]

I really, really appreciate the help.

[RandyHayes]

@Hetkey 

Where is your data coming from?  It seems it is a gallery of information. And in that Gallery is Label12, 13 and 14.

If that is the case, then you are going to only see the first row results.

So, if that is true, then you need to reference your gallery properly.

The formula would be something like this:

"<table>
    <tr>
       <th>Equipment</th><th>Applications</th><th>Licenses</th>
    </tr>
"& Concat(yourGallery.AllItems,
    "<tr>
        <td>" & Label2.Text & "</td>
        <td>" & Label4.Text & "</td>
        <td>" & Label3.Text & "</td>
     </tr>")
& "
</table>"

[Hetkey]

I figured something out. It multiplies the current submission by the number of rows in the SharePoint list, so the more times the app runs the more rows show up in the email. Go figure, The table itself looks great though, Thanks.

[RandyHayes]

@Hetkey 

Yes, but where are the labels you have in the formula?  Are those columns in your 'I/T Equipment Orders' datasource and is that even an actual datasource/list?

[Hetkey]

it's a SharePoint list with Choices Columns I populated with the items. Hang on I'll try the .all items thing.