Hi all,
I am writing a power app to convert HTML to PDF then send an email by using Power Apps and Power Automate.
It is run successfully if the content is all english characters.
However, if the content has Chinese characters, the pdf will show garbled character or square symbol.
I tried to set the meta charset of the html to utf-8,
<head>
<meta charset=""utf-8"">
</head>"
It still not work.
May i know how to fix it.
Could anyone help me?
Power automate flow:
Below is my code
Set(varImage,"");
Set(varImage2,"");
Set(varImage3,"");
Set(varImage4,"");
Set(varImage5,"");
If(IsBlank(Image2.Image),varImage,Set(varImage,JSON(Image2.Image,JSONFormat.IncludeBinaryData)));
If(IsBlank(Image7.Image),varImage2,Set(varImage2,JSON(Image7.Image,JSONFormat.IncludeBinaryData)));
If(IsBlank(Image11.Image),varImage3,Set(varImage3,JSON(Image11.Image,JSONFormat.IncludeBinaryData)));
If(IsBlank(Image12.Image),varImage4,Set(varImage4,JSON(Image12.Image,JSONFormat.IncludeBinaryData)));
If(IsBlank(Image13.Image),varImage5,Set(varImage5,JSON(Image13.Image,JSONFormat.IncludeBinaryData)));
PowerAppV2inspectiontoemail.Run(
"<!DOCTYPE html>
<html>
<head>
<meta charset=""utf-8"">
</head>" &
"<style>
table, th, td {
border: 1px solid gray;
border-collapse: collapse;
}
body {
font-family: 'Noto Sans SC', sans-serif;
}
</style>" &
"<body>
<p style=""font-family:PMingLiU""> "
&
"<table><tr><th>" &"Inspection Date" &"</th><th>" &DateValue1.SelectedDate & Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0) &"</th></tr>" &
"<tr><td>"&"Zone"&"</td><td>"&DataCardValue11.Selected.Value &"</td></tr>" &
"<tr><td>"&"Contractor"&"</td><td>"&DataCardValue12.Selected.Value &"</td></tr>" &
"<tr><td>"&"Work Location"&"</td><td>"&DataCardValue13.Text &"</td></tr>" &
"<tr><td>"&"PO number"&"</td><td>"&DataCardValue14.Text &"</td></tr>" &
"<tr><td>"&"Inspector"&"</td><td>"&DataCardValue15.Selected.Value &"</td></tr>" &
"<tr><td>"&"Inspector record"&"</td><td>"&"<img src=" &varImage & " >" &"</td></tr>" &
"<tr><td>"&"Active Site or Non-active Site"&"</td><td>"&DataCardValue39.Selected.Value &"</td></tr>" &
"<tr><td>"&"Job Type"&"</td><td>"&DataCardValue40.Selected.Value &"</td></tr>" &
"<tr><td>"&"CLPP RE"&"</td><td>"&DataCardValue41.Selected.Value &"</td></tr>" &
"<tr><td>"&"CLPeS PE"&"</td><td>"&DataCardValue42.Selected.Value &"</td></tr>" &
"<tr><td>"&"Form 4"&"</td><td>"&"<img src=" &varImage2 & " >" &"</td></tr>" &
"<tr><td>"&"Good point 1"&"</td><td>"&DataCardValue28.Text &"</td></tr>" &
"<tr><td>"&"Good point 2"&"</td><td>"&DataCardValue29.Text &"</td></tr>" &
"<tr><td>"&"Good point 3"&"</td><td>"&DataCardValue30.Text &"</td></tr>" &
"<tr><td>"&"Improvement 1"&"</td><td>"&DataCardValue46.Text &"</td></tr>" &
"<tr><td>"&"Improvement 1 photo"&"</td><td>"&"<img src=" &varImage3 & " >" &"</td></tr>" &
"<tr><td>"&"Improvement 2"&"</td><td>"&DataCardValue47.Text &"</td></tr>" &
"<tr><td>"&"Improvement 2 photo"&"</td><td>"&"<img src=" &varImage4 & " >" &"</td></tr>" &
"<tr><td>"&"Improvement 3"&"</td><td>"&DataCardValue48.Text &"</td></tr>" &
"<tr><td>"&"Improvement 3 photo"&"</td><td>"&"<img src=" &varImage5 & " >" &"</td></tr>" &
"</table>
</body>
</html>"
);
SubmitForm(EditForm1);
