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

[RandyHayes]

@Hetkey 
Okay, but it was really about...what is Label12, 13 and 14?  Columns in your data or a control in a gallery?

[Hetkey]

OK So I have a form using my List as a Data Source. I could not pull directly from the Form as it refused to accept .Value as valid. (Applications. Value  etc.) so I sent the contents of the selection to 3 labels, set them as invisible and put them in the HTMLText. I set the submit button to submit the form and then in the Form 'On Success" property I format the email with the contents being the HTMLText1.HTMLText.

I'm so awfully close but it seems to just keep adding rows.

[RandyHayes]

@Hetkey 

Okay, but a form is one record at a time!

In your OnSuccess property, you can get any value of the record you submitted with Self.LastSubmit.columnName

What do you mean by "I sent the contents of the selection to 3 labels"??

[Hetkey]

if it helps, here is the whole Submit process:

"

Set(varStatus, "Submitted"); SubmitForm(frm_Request);

Set(varRequest, frm_Request.LastSubmit);
If(varRequest.Status.Value="Submitted", Office365Outlook_1.SendEmailV2("MyEmail", (Title), ("Equipment/Access Request: An Request has been submitted by " & varRequest.Manager.DisplayName & " for: " & varRequest.Employee.DisplayName & ". " & " Items requested are listed here: " & (HtmlText1.HtmlText & Comments )), {IsHtml:true, Importance:"High"})); ResetForm(frm_Request); Navigate(Screen2)

"

[RandyHayes · Accepted solution]

@Hetkey 
Your Submit on the button/control that submits the form should only be:

    SubmitForm(frm_Request)  (not sure what the varStatus is for)

Your OnSuccess should be:

With(Self.LastSubmit,

    If(Status.Value="Submitted", 
        Office365Outlook_1.SendEmailV2(
           "MyEmail", 
           "(Title)", 
           "Equipment/Access Request: An Request has been submitted by " & Manager.DisplayName & 
           " for: " & Employee.DisplayName & ".<br>
             Items requested are listed here: <br>
             <table>
                 <tr>
                   <th>Equipment</th><th>Applications</th><th>Licenses</th>
                </tr>
             " & 
             // this part I am not getting a clear understanding from you on
             Concat('I/T Equipment Orders',
                 "<tr>
                   <td>" & Label2.Text & "</td>
                   <td>" & Label4.Text & "</td>
                   <td>" & Label3.Text & "</td>
                 </tr>"
             )
             // 
            & "</table>" &
            // You don't really need htmltext controls for the above of the below
            // but since we've not talked about the comments, I am just leaving them here.
            (HtmlText1.HtmlText & Comments,
            {Importance:"High"}
        )
    )
);

ResetForm(frm_Request); 
Navigate(Screen2)

So, as commented above, I am still not sure what you are trying to Concat.  Concat works on a table of records...where is that table (what is 'I/T Equipment Orders') and how does Label 2, 3 and 4 relate to it?

[Hetkey]

'I/T Equipment Orders' is my SharePoint List. I was trying to pull the selections from a form into a single formatted table in an email. The HTML text wouldn't let me use the Columns from the List as Values so I sent the selections to labels so I could use them as .Text. , it seemed to work pretty well except for the extra columns, extra rows thing and I didn't know what to search for to get a better way.

I took out the Concat thus:

/ this part I am not getting a clear understanding from you on
"
"<tr>
<td>" & Label2.Text & "</td>
<td>" & Label4.Text & "</td>
<td>" & Label3.Text & "</td>
</tr>"

"

but it still did the multiple rows thing. 

As for the HTML question, I use it to get a nice table. Please see attached screenshot. underlined is the output without the html and the html table (extra rows included) is below in the same email.

Anyway, my girl is going to kill me as I am 2.5 hours into vacation. I will try to follow up with this thread next week.

Thanks so much for everything and if I ever meet the person who disallowed 'right-click/copy' in PowerApps I will kick him/her/they in the shin.

[RandyHayes]

@Hetkey 

You don't really need the overhead of the html controls in order to get the html that you want in your email.  As long as you are providing the properly formatted html codes to the send email, it will all be correct.

I am still not sure I am understanding what you mean by: "so I sent the selections to labels"

Also not entirely sure what you mean on the ability not to copy.  Although it is not available with a right-click, you can still use the keyboard - ctrl-c  and ctrl-v to paste.

I would need to know what you mean by "selections from a form".  If this is in your form, then it is available for use in your formulas.

Anyway...yes...take a vacation and enjoy your time.  Just post back when you get back into it again.

[Hetkey]

I created 3 labels, set them to invisible, set their text to the selections in the Form listboxes, then in the html set:

<td>" & Label2.Text & "</td>
<td>" & Label4.Text & "</td>
<td>" & Label3.Text & "</td>

This worked in that I got a table and the columns were correct but I got all the extra columns as well.

In the html when I tried "<td>" & ListBox1.Value & "</td> it kept saying "Value" was invalid. Yet, "Value" was the only thing it would let me choose there.

[Hetkey]

OK, clear head and more coffee. I cleaned it up a lot and I now get the right amount of information (correct columns and the right number of rows(see attached screenshot)). Still not getting my table though. I will look at that myself, thanks.

[RandyHayes]

@Hetkey 

Your formula at this point must be different than what I sent as it should have worked fine.  You're now mentioning Listboxes and hidden labels (no hidden label needed).

Are you stating that choices are made in the Form into a ListBox?  

I am not understanding your full app, so perhaps if you could enhance my understanding with a picture or two.

If the I/T Equipment Orders is your full datasource, then you definitely don't want to use that by itself in the Concat.