How to extract the second line from an email body?

(0) Share

Report

Posted on by magicwas

Hi, I'm hoping someone can help.

I'm trying to extract the first and second lines of an email body and insert them into two separate columns in excel.

I followed the answer from the following post to extract the first line (https://powerusers.microsoft.com/t5/Building-Flows/Extract-first-line-of-email-body/td-p/545440# ) which works but, i've not been able to find anything to help me extract the second line.

The contents of the first line could be any length (but currently a maximum of 11 characters) and the second line could be any number of characters with no limit.

FYI - i'm a complete newbie to this and coding in general so any really basic step by step help (similar to that of the guidance in the link above) would be incredibly appreciated.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @magicwas please try to paste your body content here

Was this reply helpful? Yes No
magicwas 10 on at

Like (0)

Report

hi @ChristianAbata , thank you for your response.

The body content would simply be a forwarded email of some sort but in the body of the new email that will be forwarded will just be two lines. The first line will have a word to describe the email being forwarded and the second line will have a name.

The idea is to log work coming in and to allocate it someone while keeping track of that allocation within a spreadsheet.

the body preview would simple be:

Marketing
John Smith

From: [NAME]
Sent: [DATE]
To: [EMAIL ADDRESS]
Subject: xxxx

[whatever is forwarded]

I hope that makes sense. Let me know if you need anything else.
Really appreciate your help.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

Shure @magicwas you said that you need to optain the second line of the body email but in your example you add me fields like

From: [NAME]

Sent: [DATE]

So, you are trying to get the second line from a message forwarded?

Was this reply helpful? Yes No
magicwas 10 on at

Like (0)

Report

Hi @ChristianAbata,
Sorry if i'm not articulating this clearly - its all new terminology for me!
The 'From' and 'Name' were just to demonstrate that this would be the forwarded emails that would follow after the two lines i wish to extract. In my example, I would only want to extract the first two lines of the email, 'Marketing' and 'John Smith', everything that appears after that would be the previous emails in the email chain and can all be ignored.

I hope that makes more sense.

Thank you again for your persistence!

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

ok, just another question @magicwas in your emails, you are going to receive allways 'Marketing' and 'John Smith or this is just and example and your content allways is going to be different?

Was this reply helpful? Yes No
magicwas 10 on at

Like (0)

Report

Hi @ChristianAbata,
Thank you again for your reply.
No, 'Marketing' and 'John Smith' are just examples. What will actually be written could be anything but one will always be on the first line and the other will always appear on the second line.

Was this reply helpful? Yes No
Verified answer

yashkamdar 1,044 on at

Like (0)

Report
Hello Team,

Here is how you get the first and the second line of your email body.

Step 1 - Initialize a variable, enter the Type as STRING.
Do not forget to hit an ENTER in the Value of the Intialize a variable action.
Basically just go the Value field of the action "Initialize Variable" and hit an enter once in the body area.

Step 2 - Compose

As shown in the image below, create a COMPOSE action and add Body preview as Inputs.

Step 3 - Compose action with expression

Enter the following expression in COMPOSE action to get the first line of the email.

split(outputs('Compose'),variables('ParseEmail'))[0]

Step 4 - Compose action with expression

Similarly you need to add another compose action to get the second line

split(outputs('Compose'),variables('ParseEmail'))[1]

If there is a space between your first line of the email and the second line then the above expression changes to -
split(outputs('Compose'),variables('ParseEmail'))[2]

Input email-

Outputs-

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

1 people found this reply helpful.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@magicwas please try this...

Was this reply helpful? Yes No
magicwas 10 on at

Like (0)

Report

Thank you @ChristianAbata and @yashkamdar for all your help!
They both worked perfectly. I ended up going with @yashkamdar's solution as it was already so close to the solution that i used to extract the first line as was a matter of changing one digit to get the second line (not sure why i didnt think of that myself!)

thank you both again for all your help 🙂

Was this reply helpful? Yes No