Outputting the contents of a collection to a HTML Text Field

[NigelP]

Hi

I am trying to output the contents of a collection to an HTML text field as a table.but the HTMLText field does not like the "ForAll" statement in the middle of it.

texttexttexttexttexttexttexttext

ForAll(theCollection, Item1,Row1,Item2,Row2 etc etc

texttexttexttexttexttexttexttext

I can put values of a variable into the HTMLTExt field eaily.

THanks

Nigel

[CarlosFigueira · Accepted solution]

You can use the Concat function to convert the rows in the collection to the rows in the HTML table. For example, if you have a collection with properties Name and Age, you can have this expression to create a HTML table that can be displayed in the HTML Text control:

"<table border='1' width='100%'>" &
"<thead><tr><th>Name</th><th>Age</th></thead>" &
"<tbody>" &
Concat(CollectionName, "<tr><td>" & Name & "</td><td>" & Age & "</td></tr>") &
"</tbody></table>"

The attached app shows this expression for a sample collection.

[seadude]

Thanks for the reference file @CarlosFigueira . Timeless contribution!