Unanswered

HTML table concat

(0) Share

Report

Posted on by Broly123

209

Hello! I used tabular data for the HTML code and On the Concat I inserted my own values. However, The table is still showing the previous information from the original table, probably because I didn't do something right.

This is what I have in my formula.

Concat(Gallery3.AllItems,
 "<td>" & ID & " </td>
 <td>" & Description & " </td>
 <td>" & Qty & " </td>","</tr><tr>") &
"</table>"

Do the values have to be exactly what's named in my collection?

Or do they have to be what's named in the gallery? (ex. Text=ThisItem.ID)

thank you to whomever can help!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

madlad 2,637 Moderator on at

Like (2)

Report
Copy link

Link copied!

The code looks correct here to display a table with all items of your gallery; what exactly do you mean by showing information from the original table?
What's the extra info that you have that you want to not show up, and what's the rest of your html look like?

Was this reply helpful? Yes No
timl 37,154 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Broly123

Did you add text input controls to your gallery to allow the user to modify the collection values and is this what you want to show in your HTML? Is this what you you mean when you refer to the HTML showing 'origianl' data?

If that's the case, you can reference the content of the gallery controls like so:

Concat(Gallery3.AllItems, "<td>" & ID & " </td> <td>" & txtDescription.Text & " </td> <td>" & txtQty.Text & " </td>","</tr><tr>") & "</table>"

Was this reply helpful? Yes No
Broly123 209 on at

Like (1)

Report
Copy link

Link copied!
@madlad @timl Thanks for coming in again to help! This is the original code I used and the original concat is at the bottom. Even though I changed it to my values, its still reading the original concat information

This is what I have in my formula.

"<h3>Invenory Order</h3>" & "<table width='100%'> " & "<tr> <td> Order ID: </td> <td>" & varRecordOrderID.'Order ID' & "</td>" & "</tr>" & "<tr> <td> User: </td> <td>" & TitleTxt.Text & "</td>" & "</tr>" & "<tr> <td> Date: </td> <td>" & Today() & "</td> </tr>" & "<tr> <td> Date Needed: </td> <td>" & DatePicker1 & "</td> </tr>" & "</table> <br>" & "<strong> Items: </strong>" & "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th>Id</th> <th> Name </th> <th> Description </th><th> Accessories </th> </tr> <tr>" & Concat(Gallery3.AllItems, "<td>" & ID & " </td> <td>" & Description & " </td> <td>" & Qty & " </td>","</tr><tr>") & "</table>"

And the this is what I get back in email. The original concat info

Was this reply helpful? Yes No
Broly123 209 on at

Like (1)

Report
Copy link

Link copied!

@timl @madlad I figured it out the table. I have to change the table names in the html code smh Thank you!

Was this reply helpful? Yes No