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 )
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.
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]
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.
Thanks, I just followed your suggestion but I'm not able to see any output - how can I see the variable output?
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.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2