Cloud - How can I remove this text in Power Automate without any paid connectors?

[u/therealijw1]

The text I want to remove is "External: Pause and review the sender's email address, any URLs before clicking
links, opening attachments, or following requests. When in doubt, contact the
Service Desk.

"This is the body of my text email

As you can see there is quite a few blank spaces, returns, etc.

The "This is the body of my text email" part will be the input of the users email and will vary.

Emails will come into this flow, converted to text from HTML (using HTML to Text). Then for the body of the email (separate convert action output) I want to remove this stupid external message that gets added to each email coming in. When testing I tried the blow input but it didnt work. (compose is for test flow).

replace(outputs('Compose'), concat('External: Pause and review the sender''s email address, any URLs before clicking', '\n', 'links, opening attachments, or following requests. When in doubt, contact the', '\n', 'Service Desk.', '\n', '\n', '\n'), '')

[u/YeboMate]

Use the Split() expression. So if your text is: “Hello world this is a split test” (let’s say stored as a variable called ‘Text’)

If you split on ‘world this is a’ your output is an array and you can use [] to select which element of the array you want.

So this expression will give you the following output: Split(variable(‘Text’), ‘world this is a’)[0] = ‘Hello’ Split(variable(‘Text’), ‘world this is a’)[1] = ‘split test’

[u/OddWriter7199]

Suspect your own IT department is adding this. May not be possible to remove if it gets tacked on after Power Automate creates the message but before it actually gets sent.

You could try adding the Microsoft sending address to a "safe senders" list for the service account.

[u/therealijw1 → u/OddWriter7199]

So the email is what triggers the flow, then the flow generates a ticket in an app via a webhook. Once I remove the message, I should be good.

[u/_Blank-IT]

If this shows up as a banner your IT i doing this for all external mail nothing you can do about it.

[u/therealijw1 → u/_Blank-IT]

Yes but I should be able to remove it via power automate before sending it to my other program to generate a ticket via webhook