Hoping to get some direction. I am developing an app to track issues in our shop. I am storing the data in a SP List. One of the fields (columns) in my SP List is the Status of the issue, i.e. In Review, In Progress, Complete, etc. We use Symbols to display these values and I am storing the corresponding Unicode in a separate column in the same SP List. I want to send an email from this app and display these symbols in the email so that the status is quick to ascertain. I have been utilizing this tutorial (https://www.matthewdevaney.com/send-formatted-emails-from-power-apps-without-writing-any-html-code/) to help me, but can't figure out how to show the symbols.
Below is the a snipped of the code for the field I am trying to populate:
<td width=62 style='width:46.75pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal><span style='font-size:18.0pt;font-family:""Cambria Math"",serif'>"&StatusCode&"</span><o:p></o:p></p>
</td>
Where StatusCode is the field name in my SP List. The field displays the symbol if I hardcode it:
<p class=MsoNormal><span style='font-size:18.0pt;font-family:""Cambria Math"",serif'>◑</span><o:p></o:p></p>
I am storing the code in the SP List as #9681. Does anyone have an suggestions as to how I can achieve this in my email? Thank you.