Convert MHTML to HTML or send formatted MHTML in email body

[lukasz2]

Hi,

Is it possible to convert the MHTML  to HTML in power automate ?

My point is to display the formatted content of the mhtml file in the body of the email. I don't want to attach the file as an attachment.

example mhtml:

MIME-Version: 1.0
Content-Type: multipart/related;
	boundary="----=_NextPart_01C35DB7.4B204430"
X-MSSQLRS-ProducerVersion: V0.0.0.0

This is a multi-part message in MIME format.

------=_NextPart_01C35DB7.4B204430
Content-Disposition: inline
Content-Type: text/html;
	charset="utf-8"
Content-Transfer-Encoding: base64


aGl0ZTt2ZXJ0aWNhbC1hbGlnbjp0b3A7dGV4dC1hbGlnbjpsZWZ0O2RpcmVjdGlvbjpsdHI7bGF5
b3V0LWZsb3c6aG9yaXpvbnRhbDt3cml0aW5nLW1vZGU6bHItdGI7bWluLXdpZHRoOiAyNS40MG1t
O1dJRFRIOjI1LjQwbW07fQ0KLmEzMXt3b3JkLXdyYXA6YnJlYWstd29yZDt3aGl0ZS1zcGFjZTpw
cmUtd3JhcDtmb250LXN0eWxlOm5vcm1hbDtmb250LWZhbWlseTonU2Vnb2UgVUknO2ZvbnQtc2l6
ZToxMHB0O2ZvbnQtd2VpZ2h0OjQwMDt0ZXh0LWRlY29yYXRpb246bm9uZTt1bmljb2RlLWJpZGk6
bm9ybWFsO2NvbG9yOiMzMzMzMzM7ZGlyZWN0aW9uOmx0cjtsYXlvdXQtZmxvdzpob3Jpem9udGFs
O3dyaXRpbmctbW9kZTpsci10Yjt2ZXJ0aWNhbC1hbGlnbjp0b3A7dGV4dC1hbGlnbjpsZWZ0O30N
Ci5hMzVjcntwYWRkaW5nLWxlZnQ6MnB0O3BhZGRpbmctdG9wOjJwdDtwYWRkaW5nLXJpZ2h0OjJw
dDtwYWRkaW5nLWJvdHRvbToycHQ7Ym9yZGVyLWJvdHRvbToxcHQgc29saWQgQmxhY2s7Ym9yZGVy
LWxlZnQ6MXB0IHNvbGlkIEJsYWNrO2JvcmRlci1yaWdodDoxcHQgc29saWQgQmxhY2s7Ym9yZGVy
LXRvcDoxcHQgc29saWQgQmxhY2s7YmFja2dyb3VuZC1jb2xvcjpXaGl0ZTt2ZXJ0aWNhbC1hbGln
SVY+PC9ib2R5PjwvaHRtbD4=

------=_NextPart_01C35DB7.4B204430--

[UditA]

To get the Company Logo we need to add few steps

For adding company logo above mention steps are same you need to add Step 5 & 6 to your flow
Step 5) Get the Company Logo content form onedrive path 
Step 6) Replace the distorted image with Company logo

replace(outputs('Compose'),first(split(last(split(outputs('Compose'),'src=')),'style=')),concat('"',dataUri(outputs('Get_file_content_using_path')?['body']),'" '))

[mgutman]

Can you show the step send email with HTML in body?  Trying to solve this step.  Thanks.

[mgutman]

If anyone wants to vote on this to be a feature like SSRS please vote.

https://ideas.powerbi.com/ideas/idea/?ideaid=74f8f291-3fad-4e22-b62e-73d5e8248d77

[Anonymous]

Hi @lukasz2 , i have followed this thread and did everything exactly the same. once adding your code in the body email as a function, once saving the flow, it disappears. do you have any idea why? (the purpose is to delete all the top automatic rows). Many Thanks,  

[c118733]

I am facing the same issue. Not able to get the company logo. Is there any update? Thanks in advance.

[c118733]

replace(replace(replace(replace(replace(replace(body('Convert_file_using_path'), 'Monday, January 1, 0001 12:00:00 AM', ''), 'Subject:', ''), 'To:', ''), 'Sent on:', ''), 'From:', ''), ' table style="font-family:Times New Roman; font-size:12pt', '')

i had the same problem. so i wrote this code. it will give you a partial fix

[lukasz2]

@Anonymous  @c118733  

The power automate flow editor recently had a major update. Most likely, the new editor does not allow you to insert such a long replace function. I don't know if you have this option, but I can still switch between the new and the old environment. (upper right corner when you are in flow edit mode) See if you have this switch and try to create and save the flow using the old environment