Answered

Flow template for parsing email

Like (0) Share

Report

Posted on 8 Feb 2021 05:56:46 by hpkv1

Hi there, I'm new to flows. Can someone please guide me or provide a template that I can use to parse an email body and send a new email alert if a particular condition is met.

For example. below is the sample template I'm working with. Ideally I want to extract each of the field and store the text associated with the field in a MySQL database or some other DB where it can be queries later.

But for now, I want to parse the email and look for keyboard 'hours', if that is found then trigger a new email to specific recipients.

Is this possible? Thank you!

Sample Template:
Notification Number: 7433
Date: 01/Mar/2018 07:00:00 - 03/Mar/2018 19:00:00
Activity: Following maintenance is Planned

Service Affected
4845 Circuit Rd, Caledonia (1 x 3 hours)
4745 Acadia Cr, Calendonia (1 x 10 minutes )

All responses (5)

Answers (1)

v-litu-msft on 11 Feb 2021 at 08:05:42

Like (0)

Report

Re: Flow template for parsing email

Hi @hpkv1,

I upload my Flow to this post, you could download it and import it into your Flows to test.

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

Flowtemplateforpa...
hpkv1 4 on 09 Feb 2021 at 22:29:35

Like (0)

Report

Re: Flow template for parsing email

Ok thanks. I must be doing something wrong. When I go to view the output, the value has the script instead of the output variable. For ex, Notification Number value has this - split(split(outputs('Compose'),'Notification Number: ')[1],variables('BlankRow'))[0]
v-litu-msft on 09 Feb 2021 at 09:36:57

Like (0)

Report

Re: Flow template for parsing email

Hi @hpkv1,

Click run history, and expand the action you will find the variable output.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hpkv1 4 on 08 Feb 2021 at 22:34:30

Like (0)

Report

Re: Flow template for parsing email

Thanks, I just followed your suggestion but I'm not able to see any output - how can I see the variable output?
Verified answer

v-litu-msft on 08 Feb 2021 at 09:45:42

Like (0)

Report
Re: Flow template for parsing email

Hi @hpkv1,

You could initialize several variables to store these field values. Firstly, we should initialize a BlankRow variable to store an empty row by clicking once "Enter" on the keyboard.

Then initialize these variables as below:

Notification Number

split(split(outputs('Compose'),'Notification Number: ')[1],variables('BlankRow'))[0]

StartDate

split(split(outputs('Compose'),'Date: ')[1],' - ')[0]

EndDate

split(split(outputs('Compose'),' - ')[1],variables('BlankRow'))[0]

Activity

split(split(outputs('Compose'),'Activity: ')[1],variables('BlankRow'))[0]

If you want to check if the Email body contains the keyword, you could add a Condition action to do that:

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