Answered

Use Concat on Collection for HTML output only when Collection row is not empty

(0) Share

Report

Posted on by DanAugust

I have a Collection named colShoppingCart. I am sending an HTML email to the customer upon checkout that includes all the items in the shopping cart that they ordered.

I am using Concat in the HTML to populate a table that is sent to the user.

Concat is iterating through the Collection and populating the HTML table just fine and the results in the email are great...except that the last iteration creates an empty row in the HTML table.

<th>Product Name</th> <th> Quantity Ordered</th>
<tr>" & Concat(
 colShoppingCart,
 "
 <td style='text-align:center'>" & Description & "</td>
 <td style='text-align:center'>" & QTY & "</td><tr>
 )
)

I know what the issue is, I just don't know how to fix it. The second <tr> tag does its job and creates a new line in the HTML table after each Description and QTY is printed, but since its putting a new row after each row created, it creates an empty row just before it exits the Concat function.

What I am trying to do is stop creating the empty row in the HTML table.

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,315 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @DanAugust ,

Try </tr> instead of <tr> on the last item

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
jesse_sql 30 on at

Like (0)

Report
Copy link

Link copied!
Hi! Is it possible that the function returns a text-value that ends with a pattern that you could recognize and replace so it removes the last opening tr-tag? For example
Substitute(" <table> <th>Product Name</th> <th> Quantity Ordered</th> <tr> <td style='text-align:center'> description_1</td> <td style='text-align:center'>" qty_1 </td> </tr> <tr> <td style='text-align:center'> description_2</td> <td style='text-align:center'>" qty_2 </td> </tr> <tr> </table> ";"<tr></table>"; "</table>")
I hope it might give some ideas. I would love to see the complete HTML that you're working with

Was this reply helpful? Yes No
DanAugust 5 on at

Like (0)

Report
Copy link

Link copied!

Oh my goodness, it was that easy? I need to brush up on my HTML skills! Thanks, WarrenBelz!

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @DanAugust ,

Yes - easy to miss closing tags - a bit over overkill, but I tend to indent it all when I am developing as below so I can see opening and closing tags at all levels

" <th>Product Name</th> <th> Quantity Ordered</th> " & Concat( colShoppingCart, " <tr> <td style='text-align:center'>" & Description & "</td> <td style='text-align:center'>" & QTY & "</td> </tr> " )

Was this reply helpful? Yes No