split string to new line - HTML

(0) Share

Report

Posted on by SukhRehal

Hi all,

I have the below HTML code.

"<table border='1' width='100%'>" &
"<thead><tr><th>Location</th><th>Items</th></thead>" &
"<tbody>" &
Concat(gal_InstallationItems.AllItems, "<tr><td>" & Location & "</td><td>" & Item & "</td></tr>") &
"</tbody></table>"

within my gallery, the "Item" field is made up of a long string of items separated by a semi colon. Is there a way I can show the values after a semi colon to a new line?

so something like this.

Item1; Item2; Item3

Item1

Item2

Item3

Thank you for any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
You can split the 'Item' property in its ';' characters, and concatenate them using "<br/>" (HTML new line), like in the example below:

"<table border='1' width='100%'>" & "<thead><tr><th>Location</th><th>Items</th></thead>" & "<tbody>" & Concat( gal_InstallationItems.AllItems, "<tr><td>" & Location & "</td><td>" & Concat(Split(Item, ";"), Result, "<br/>") & "</td></tr>") & "</tbody></table>"

Hope this helps!

Was this reply helpful? Yes No
Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
In addition to @CarlosFigueira's answer, you could also try substituting the semi colon with a <br/> like so:

"<table border='1' width='100%'>" & "<thead><tr><th>Location</th><th>Items</th></thead>" & "<tbody>" & Concat(gal_InstallationItems.AllItems, "<tr><td>" & Location & "</td><td>" & Substitute(Item,";", "<br/>") & "</td></tr>") & "</tbody></table>"

Was this reply helpful? Yes No
SukhRehal 26 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks Guys,
as a follow on question I am trying to group by the first column, is this possible?

"<table border='1' width='100%'>" & "<thead><tr><th>Location</th><th>Items</th></thead>" & "<tbody>" & Concat( gal_InstallationItems.AllItems, "<tr><td>" & GroupBy(Location) & "</td><td>" & Concat(Split(Item, ";"), Result, "<br/>") & "</td></tr>") & "</tbody></table>"

Was this reply helpful? Yes No