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 (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 (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 (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