HTML Tags issues

[Anonymous]

Hi everyone, newbie here.

I'm trying to develop an automatic mail app. The user select the model of mail he wants and choose the parameters. 

The body of the mail is then load from a Sharepoint List (Column Body of 'Hermes - DB' list) into a RichTextEditor for preview and modifications if its needed. The body already includes the variables (e.g. "&DatePicker1.SelectedDate").

The issue is when loading the body into the Editor, the HTML tags are still present (right side of the Picture), its not convert into a html text. But if I copy paste the text into another Editor (left side) it's working. 

The code of the right side Editor : 

Switch(
    Concat(ComboBox1.SelectedItems; Title&""); 
    LookUp('Hermes - DB'; ID = 1).Title; 
    LookUp('Hermes - DB'; ID = 1).Body)

The code of the left side :

"<p>Bonjour,</p>
<p>Pourriez-vous préparer les clés suivantes au nom de <strong>"
& With({str:Concat(ComboBox2.SelectedItems;'Nom/Prénom1'&", ")};Left(str;Len(str)-2))
&"</strong> pour le <strong>"
& DatePicker1.SelectedDate
&":</strong></p>
<p style=""line-height: 0.5; margin-left: 20px;""><strong>-&nbsp;</strong>1 PASS TECHNIQUE PHS</p>
<p style=""line-height: 0.5; margin-left: 20px;"">- 1 PASS BUREAU PHS</p>
<p style=""line-height: 0.5; margin-left: 20px;"">- 1 PASS TELECOM AVEC BADGE</p>
<p>Cordialement, lol</p>
<p><br></p>"

How may i convert it while loading the text from the sharepoint list ?

Thank you for your help

[Anonymous]

If i use the PlainText() function, it will not keep my variable logic.

[v-bofeng-msft]

Hi @Anonymous :

I've made a test but did not encountered the problem you mentioned(HTML tags are correctly recognized):

Could you please show me your SP list?

Here is my tests
1\My SP list:

2\My APP

Best Regards,

Bof

[Anonymous]

Hi @v-bofeng-msft 

Thank you for your answer.

Here is the record of my SP list : 

Thank you !

[v-bofeng-msft · Accepted solution]

Hi @Anonymous :

Please turn of this feature(Please save the data first to prevent data loss😞

Best Regards,

Bof

[Anonymous]

Hi @v-bofeng-msft ,

It resolves a bit of the problem, thank you !!

But the problem with my functions inside the HTML text remains. It prints &With ... instead of doing it.

Sincerely, 

Vigo

[v-bofeng-msft]

Hi @Anonymous :

This is to be expected. PowerApp formulas need to be manually entered in the code bar to take effect,the text format formula is not recognized.

Best Regards,

Bof