Answered

search for specific string within email - string can contain line break

(0) Share

Report

Posted on by Community Power Pla...

I want to create a condition in Microsoft Flow that searches for a certain string in an e-mail body.

I have tried it with "body contains string" and it worked, if the string was only in one line.

Unfortunately, the mail is not structured in a user-friendly way. It can happen that blanks are missing before or after the string or that the string is even spread over two lines. I simply lack the experience with this kind of queries.

Does anyone here have an idea how I can best approach this?

Here are two examples of the string I am looking for and how it could be in the mail:

The string I am looking for: "Business Function in Department: Technical Team"

The Mail can look like this:

Ticket: 12345678Location: [Ohio]Account: ABC Business Function in Department:

Technical TeamReason: New Hire

or like this:

Ticket: 12345678Location: [Ohio]Account: ABC Business Function

in Department: Technical TeamReason: New Hire

or like this:

Ticket: 12345678Location: [Ohio]Account: ABCBusiness Function in

Department: Technical TeamReason: New Hire

Any ideas and help welcome!

All responses (3)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: search for specific string within email - string can contain line break

Many thanks for the provided solution! That really helped me!
Verified answer

grantjenkins 11,059 Super User 2025 Season 1 on at

Like (1)

Report
Re: search for specific string within email - string can contain line break

Hopefully this is what you're looking for.

See full flow below. I'll go into each of the actions.

When a new email arrives is what you already have.

Html to text removes the HTML from the Body of the email.

Condition uses the following expression. It removes line breaks and spaces.
//Removes line breaks and spaces replace(replace(outputs('Html_to_text')?['body'], decodeUriComponent('%0A'), ''), ' ', '') //Test to see if it contains the following BusinessFunctioninDepartment:TechnicalTeam

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
VictorIvanidze 12,505 on at

Like (0)

Report

Re: search for specific string within email - string can contain line break

Just replace all line brakes with nothing before search.