Situation: I have a collection that has two columns: a question and an answer field.
Desire: To generate an HTML PowerApp insert that grabs the questions and answers into a table. I've been able to do that successfully, but I want to add some conditional formatting. For example, if my answer is "1," I want the text to be red, if the answer is 2, I want the text to be green.
See below for my start: The issue with my coding below is that it's a table - so I don't know if I need to use First...or ThisItem...any help would be much appreciated!
"<!DOCTYPE html>
<html>
<body>
<Table width='100%' border='1' cellpadding='5' style='border:0px solid black; border-collapse:collapse'>" &
"<tr style='background-color:#efefef'>
<td align='left'><b>Question</b></td>
<td align='left'><b>Answer<b></td>
</tr>"
& Concat(colanswers, "<tr><td>" & Question & "</td><td><font color="""&If(colanswers.Answer="1","Blue","Red")&""">" & Answers & "</font></td></tr>")
&
"
</table>"&"
</body>
</HTML>
"
