Unanswered

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!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

VictorIvanidze 13,073 on at

Like (0)

Report

Just replace all line brakes with nothing before search.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No