Re: Remove caution message from email

Anonymous · ‎03-26-2023

Hi,

I need remove a caution message from an email when an user replies to the sent mail. This is not the case with all the user, only limited to few customers. Kindly help me to remove the message I don't want it to be captured.

And the thing is the caution message has an hyper link in it as encircled in the below image.

Nived_Nambiar · ‎03-26-2023

Hi @Anonymous

Could you share how the same message looks like when viewed in html format when flow is ran from power automate ?

Anonymous · ‎03-28-2023

Hi @Nived_Nambiar

I'm not able post it. It's getting removed I guess for some reason.

Is there any way you can help

Thanks

Nived_Nambiar · ‎03-28-2023

Hi @Anonymous

Could you paste it in the paragraph form

While posting, click on HTML Source > enter <pre></pre> , between enter the html text

Anonymous · ‎03-28-2023

Hi @Nived_Nambiar

<pre>"*** CAUTION ***: This Email failed a authentication security check (SPF or\nDMARC) which indicates it may not have come from a legitimate sender. Please use\ncaution when opening any message content such as an attachment or clicking a\nURL. More information on the SPF (Sender Policy Framework) and DMARC\n(Domain-based Authentication, Reporting and Conformance) security checks is\navailable on the Uptime\n[https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2...nsite."</pre>

Nived_Nambiar · ‎03-28-2023

@Anonymous

I need html content of the message, because my current idea to remove it based on color +caution word 🙂

Anonymous · ‎03-28-2023

Hi @Nived_Nambiar

Hope this helps

<pre>{

"host": {

"connectionReferenceName": "shared_conversionservice",

"operationId": "HtmlToText"

},

"parameters": {

"Content": "<html><head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><meta name=\"Generator\" content=\"Microsoft Word 15 (filtered medium)\"><style>\r\n\r\n</style></head><body lang=\"EN-US\" link=\"#0563C1\" vlink=\"#954F72\" style=\"word-wrap:break-word\"><div class=\"WordSection1\">*** CAUTION ***: This Email failed a authentication security check (SPF or DMARC) which indicates it may not have come from a legitimate sender. Please use caution when opening any message content such as an attachment or clicking a URL. More information on the SPF (Sender Policy Framework) and DMARC (Domain-based Authentication, Reporting and Conformance) security checks is available on the <a href=\"https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2..." originalsrc=\"https://urldefense.com/v3/__https:/nam12.safelinks.protection.outlook.com/?url=https*3A*2F*2Fuptime...." shash=\"V/e1kByNkpuHJ2/SG6ws+8IAPQboI5LviXIYpZbZi++fZAxCj28P323BzeDE8ahUtKxLpvegiAJdMZTMYN110jjEEFrNUjI2gzh6MbLyxht7m6kb8opGrKvnNYULJ2iyoIlxio+MZWWKKQKJRRxOCqHkgQgqsWk//c3jkfDlZOs=\">Uptime</a> site. </div> This message is transmitted to you by or on behalf of Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. </body></html>"

}

}</pre>

Anonymous · ‎03-28-2023

Hi @Nived_Nambiar

I Unable to upload the content, I'm attaching the screenshot hope it helps.

Nived_Nambiar · ‎03-28-2023

Hi @Anonymous

forget to ask one thing, does this caution text is fixed always ?

Anonymous · ‎03-28-2023

Hi @Nived_Nambiar

It's not fixed always, it's configured differently for different users. But the color is red for all of the message.

Nived_Nambiar · ‎03-29-2023

Hi @Anonymous

Just give a try this with this

Step 1: trigger to receieve email

Step2: Compose action to retrive caution message to end from email body

expression used:

slice(triggerOutputs()?['body/body'],indexOf(triggerOutputs()?['body/body'],'span style="font-family:Calibri,sans-serif; margin:0px; background:yellow; color:red">'))

Step 3: use compose action to slice the result from 2nd compose step to retrive only caution message

expression: slice(outputs('Compose'),0,add(indexOf(outputs('Compose'),' '),1))

Step 4: Use replace action to replace the text obtained from step 3 compose action in email body using compose action

expression: replace(triggerOutputs()?['body/body'],outputs('Compose_2'),'')

Step 5: use html to text action to convert html to plain text (using output from step 4 )

Result was like below

Input email body

Output email body

Hi ,


This is a test mail for the purpose of testing a flow. Kindly ignore it.










Thanks,
NN

Hope it helps !

Mark it as solution if it resolves your query !

Anonymous · ‎03-29-2023

Hi @Nived_Nambiar

I tried to test it, but getting the following

This is what I did from my end.

Expression in compose 2 -

slice(outputs('Html_to_text')?['body'],indexOf(outputs('Html_to_text')?['body'],'span style="font-family:Calibri,sans-serif; margin:0px; background:yellow; color:red">'))

compose 3 -

slice(outputs('Compose_2'),0,add(indexOf(outputs('Compose_2'),' '),1))

Compose 4 -

replace(outputs('Html_to_text')?['body'],outputs('Compose_3'),'')

Nived_Nambiar · ‎03-29-2023

Hi @Anonymous

I would suggest two things

1. First try to do caution part seperate, and see if it works

2. The caution part should be placed before signature removal part as caution text should be removed with help of html only, once caution is removed, then we can send the updated html (with no caution text) to signature removing part, where operation is done via first converting html to plain text if i am right 🙂

Remove caution message from email

Helpful resources

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

Updates to Transitions in the Power Platform Communities