I'm using an HTML Text control to preview a form that will be emailed by user upon clicking button control. Since PowerApps can't format forms when sending email, I'm HTML-ing the email body to look like a plain-format table with headers, shading & cells oh-my! My trouble is my Concat code... the table is a Collection table that captures [said]DataCardValues (and their values), but keep getting the red squigglies! UGH! Hate those! That field is a multi-selection dropdown list... with multi-selections selected. Just not sure what I'm doing wrong. Please help! 😢
Here's part of my code:
"<strong> Title: </strong>" & "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th> header </th> <th> header </th> </tr> <tr>" & Concat(col_ShiftReport, "<td>" & DataCardValues.SelectedItems.Value, Concatenate(Text(Value),","))
I've also tried... but still gives me the squigglies of death!
Is DataCardValues the name of a combo box control? If so, please tell what is the Items property formula of this combo box. Please notice that the syntax of concat function is Concat( Table, Formula ). While DataCardValues.SelectedItems.Value would return a table of records. I think this is the reason why Concat won't work. Please try with dropdown control to have a test.
Hi Mona. Thank you for the follow-up. I ended up putting a hidden Label control to aggregate the multiple items... like this:
Then call the text label in my HTML markup like this:
<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & " <tr style='background-color:#efefef'> <th> header01 </th> <th> header02 </th></tr> <tr>" & " <td>" & text_control01 & "</td>" & "<td>" & text_control02 & "</td>"
Not sure if that's the best way... but it worked!
Thanks again for following up!