Unanswered

HTML and MicrosoftTranslatorV2

(0) Share

Report

Posted on by paguirre

MicrosoftTranslatorV2 translates from English to another language such as Spanish. I have the app working right now. I don't need help with the feature. However, the following text is translated in a problematic way. "On 9/13/2023 9:05 PM during Period 1 John demonstrated the following behaviors • all assignments turned in as of this email • answered questions when asked • arrived on time to class." The translation is as follows: "El 13/09/2023 a las 9:05 PM durante el Período 1, John demostró los siguientes comportamientos • Todas las tareas entregadas a partir de este correo electrónico • Respondió preguntas cuando se le hicieron • Llegó a tiempo a clase." The translation into Spanish is fine. However, notice that the bullet point in the English is preceded by the HTML code HTML <hard return>. But in Spanish the HTML code follows the bullet. This text will be sent do OutLook as an email. The HTML code places hard returns in the appropriate location. However, after the translation the bullets appear at the end of the sentence. I know what's wrong. I just want to know how can I prevent this?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @paguirre ,

You could add a replace action to replace the '• ' with ' • ' .

Replace(MicrosoftTranslatorV2Result,'• ' , ' • ')

Best Regards,

Bof
paguirre 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Replace() requires me to give an exact position. However, it seems that Substitute() does not. The variable I'm using: varEmailTranslation does not work either. My situation is I have a list of student behaviors in a dropdown box. Using a UpdateContext() and a With(), I create a variable with the selected items in the dropdown, that all start with bullets, into varEmail. This looks fine in the email. Then for Spanish speaking parents I use MicrosoftTranslatorV2() and place it at the end of the same TextInputBox.Text. Unfortunately, after the translation the bullets move to the left of the HTML code "<• br>". Nothing I've done has resolved this. The text is in a variable. It will sometimes have one bullet and sometimes 5 or more. I have read the Replace() and Substitute() instructions. I have used a button, OnSelect to search the TextInputBox.Text only to fail. I'm at a roadblock. Thank you for your suggestion. I really appreciate it and could use a bit more. Thanks again.