Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

All responses (3)

Answers (1)

Sort by

VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Just replace all line brakes with nothing before search.
Verified answer

grantjenkins 11,063 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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