Answered

Export filtered Gallery to html text control

(0) Share

Report

Posted on by jcesquivel950

Hi Community,

I have an employee list in a gallery, which I'm filtering by the manager's name. I would like to show that filtered list in an HTML text control to be emailed.

The problem I'm having is that only the selected row on the gallery is showing in the HTML text control.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @jcesquivel950 ,

Hope this Blog helps
jcesquivel950 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ethan,

Now, I am able to show the list following the example in your link, It's pulling all the data. How I will be able to filter the list?

here is my code:

With(
{
BGColor: "#2196F3",
TextColor: "white"
},
"<table style='border-collapse: collapse; width: 100%;'>" &
"<thead style='border-bottom: 1px solid black;'>" &
"<tr><th style='border: 1px solid black; padding: 5px; text-align: left; background-color: "&BGColor&"; color: "&TextColor&";'>Employee Name</th>" &
"<th style='border: 1px solid black; padding: 5px; text-align: left; background-color: "&BGColor&"; color: "&TextColor&";'>Role</th>" &
"<th style='border: 1px solid black; padding: 5px; text-align: left; background-color: "&BGColor&"; color: "&TextColor&";'>Manager</th></tr></thead>" &
"<tbody>" &
Concat(HJ1users, "<tr><td style='border: 1px solid black; padding: 5px;'>" & 'User Name' & "</td>" &
"<td style='border: 1px solid black; padding: 5px;'>" & Role & "</td>" &
"<td style='border: 1px solid black; padding: 5px;'>" & Manager & "</td></tr>") &
"</tbody></table>"
)
Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jcesquivel950

If you want to show only the items that appear in the gallery, you can Concat the AllItems property of the gallery like so:

With( { BGColor: "#2196F3", TextColor: "white" }, "<table style='border-collapse: collapse; width: 100%;'>" & "<thead style='border-bottom: 1px solid black;'>" & "<tr><th style='border: 1px solid black; padding: 5px; text-align: left; background-color: "&BGColor&"; color: "&TextColor&";'>Employee Name</th>" & "<th style='border: 1px solid black; padding: 5px; text-align: left; background-color: "&BGColor&"; color: "&TextColor&";'>Role</th>" & "<th style='border: 1px solid black; padding: 5px; text-align: left; background-color: "&BGColor&"; color: "&TextColor&";'>Manager</th></tr></thead>" & "<tbody>" & Concat(YourGallery.AllItems, "<tr><td style='border: 1px solid black; padding: 5px;'>" & 'User Name' & "</td>" & "<td style='border: 1px solid black; padding: 5px;'>" & Role & "</td>" & "<td style='border: 1px solid black; padding: 5px;'>" & Manager & "</td></tr>") & "</tbody></table>" )

If you want to filter the output by some other condition, you can call the Filter function.

With( { BGColor: "#2196F3", TextColor: "white" }, "<table style='border-collapse: collapse; width: 100%;'>" & "<thead style='border-bottom: 1px solid black;'>" & "<tr><th style='border: 1px solid black; padding: 5px; text-align: left; background-color: "&BGColor&"; color: "&TextColor&";'>Employee Name</th>" & "<th style='border: 1px solid black; padding: 5px; text-align: left; background-color: "&BGColor&"; color: "&TextColor&";'>Role</th>" & "<th style='border: 1px solid black; padding: 5px; text-align: left; background-color: "&BGColor&"; color: "&TextColor&";'>Manager</th></tr></thead>" & "<tbody>" & Concat(Filter(Hj1Users, ManagerName="Alex"), "<tr><td style='border: 1px solid black; padding: 5px;'>" & 'User Name' & "</td>" & "<td style='border: 1px solid black; padding: 5px;'>" & Role & "</td>" & "<td style='border: 1px solid black; padding: 5px;'>" & Manager & "</td></tr>") & "</tbody></table>" )
jcesquivel950 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much guys. It's working now.

The blog to work with the HTML control helped me a lot. Also, the second reply fixed my code.