Extract specific text from email subject

(0) Share

Report

Posted on by Scott0044

137

Any help would be appreciated on this! A quick overview of the Flow that I built:

When a New Email Arrives (V3)
Condition
Export Email (V2)
Create File (SP Library)
Update File Properties
1. The SP library has a text field that I want to update with the employer name

Everything is working great except the last bit of metadata.

The emails coming in always a subject that reads: "Report From Employer:" followed by a space. And finally containing the employer name. The employer name varies greatly in character size. I need a proper function to successfully extract this bit (employer name) but my code is failing.

(The employer name is also in the body of the text between a set of apostrophes if that is easier to work with.)

My current subject code:

substring(triggerBody()?['Subject'],add(lastIndexOf(triggerBody()?['Subject'],'Employer'),10),30)

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report
If the subject always reads the way you say it does then what you want is to get the substring starting just after the ':'. So try this. Put the following in two Compose statements

Split(trigerBody()?['Subject'], ':') trim(outputs('Compose')[1])

That should give you the employer name The only time this wouldn't work is when the Employer name has a ':' in it. But that should probably be a rare occurrence.

Was this reply helpful? Yes No
Scott0044 137 on at

Like (0)

Report

Thank you for the response. I just learned that indeed there can be : within the employer name. Any other recommendations?

Can I just grab the entire subject minus the first 22 characters?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

If there can be ':' within the subject name you will know because the array will have more than two items in it. So its a little tougher, but just requires 1 additional step. Loop through the array with an Apply to Each loop. If its the first iteration, which you can check with the current iteration counter, do nothing. Otherwise append all the rest of the entries to a string variable with a ':' after each. That will rebuild the company name portion.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (3)

Report
Hi @Scott0044 ,

Please take a try with expression below:

last(split(triggerBody()?['subject'],'Report From Employer:'))

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Scott0044 137 on at

Like (0)

Report

Thank you! The last bit of code provided by @v-alzhan-msft seems to be working during my tests! Many thanks also to @Pstork1

Cheers!

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Please note: If the name of the business contains a ':' this will not give you the full name of the business. It will only work if the only ':' in the subject line is the one in the prompt. See the discussion below. This is not a complete solution.

Was this reply helpful? Yes No
Scott0044 137 on at

Like (0)

Report

Hello @PS, @v-alzhan-msft's code seems to be ok in my environment. I ran a couple of successful tests which captured my requirements (see screen capture). Apologies if I did not explain the requirement correctly in my initial request. Is there something else that I'm missing?

Was this reply helpful? Yes No
maries1986 162 on at

Like (0)

Report

Thank you for this solution! i had been hunting for a solution all day! works great

Was this reply helpful? Yes No