Hi PowerApps Gurus 😉 ,
maybe you can help me with this, I'm quire new to PowerApps and a little desperate here.
Can I store multiple items in one collection value seperated by a line break?
Currently all values are seperated by comma, also when I try to store them with a line break, it is still all in one row (delimited by space).
How my data is stored in the collection:
Collect(
colSubmittedTrucks,
{Truck: varTruckName,
Maschinist: Concat(cmb_Maschinist.SelectedItems,displayName, ", "),
Gruppenführer: Concat(cmb_GF.SelectedItems,displayName, ", "),
Squad: Concat(colPresenceNamesTruck,displayName,", "),
Notes: txtIn_NotesPresence.Text,
Material: Concat(cmb_Material.SelectedItems,Title,", ")}
);
Based on this collection I'm creating a html table. But in this table I want to show the squad members with a line break insted of comma seperated. So I thought the easiest way is to store the values already the correct way in the collection. But maybe I can transform the collection values in the html table if it's not possible to store the names with a linebreak in the collection?
"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'>
<th>Fahrzeug</th> <th> Maschinist </th> <th> Gruppenführer </th><th> Mannschaft </th> <th>Material</th> <th> Bemerkungen </th>
</tr>
<tr>" & Concat(
colSubmittedTrucks,
"<td>" & Truck & " </td>
<td>" & Maschinist & " </td>
<td>" & Gruppenführer & " </td>
<td>" & Squad & " </td>
<td>" & Material & "</td>
<td>" & Notes & "",
"</tr><tr>"
) & "</table>"
Thank you in advance!
Sarah
