web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Filtering an Email to list services

(0) ShareShare
ReportReport
Posted on by 18

Hi all,

 

I don't know if this is possible or not.

I get emails from an upstream provider listing outages for specific services. On the email it lists the services like the below (I have removed account name/number/service ID's).

The number of services listed can be different so it not a static number. below is 2 recent examples of emails. one of them shows 2 services and the other shows 7 services.

To make it even more difficult, the service ID's can be 7 or 9 digits long, but they all start with the number 1.

 

What I would like to do is take these service ID's so that I can search our data base for them and then when it finds a match I get the account name, primary contact details and then add all that information onto a Calander appointment for the customer to be aware of the outage.

1 Calander appointment required per service ID listed. (don't want other customers seeing other customers details)

 

Is this possible? if so, how would I go about programming this on a flow?

 

Affected Service(s):

  • (Account Name)
    • (Account Number)
      • 1xxxxxxxx - (Service ID)
      • 1xxxxxx - (Service ID)

 

Affected Service(s):

  • (Account Name)
    • (Account Number)
      • 1xxxxxxxx - (Service ID)
      • 1xxxxxxxx - (Service ID)
      • 1xxxxxx - (Service ID)
      • 1xxxxxx - (Service ID)
      • 1xxxxxx - (Service ID)
      • 1xxxxxx - (Service ID)
      • 1xxxxxx - (Service ID)
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,029 Super User 2025 Season 2 on at
    Re: Filtering an Email to list services

    Hi @MRasmus 

     

    One question, does the (Account Name) occurs once, i could see in first flow, it is occuring once, while second email, it is occuring twice, one nested under another ?

     

     

  • MRasmus Profile Picture
    18 on at
    Re: Filtering an Email to list services

    Hello Nived,

     

    Account name/number is listed once on the emails. Account name is first and the account number is under it. Then all the service id is listed under account number.

    I hope this made it more clear.

     

    Email 1:

    Affected Service(s):

    • (Account Name)
      • (Account Number)
        • 1xxxxxxxx - (Service ID)
        • 1xxxxxx - (Service ID)

     

    Email 2:

    Affected Service(s):

    • (Account Name)
      • (Account Number)
        • 1xxxxxxxx - (Service ID)
        • 1xxxxxxxx - (Service ID)
        • 1xxxxxx - (Service ID)
        • 1xxxxxx - (Service ID)
        • 1xxxxxx - (Service ID)
        • 1xxxxxx - (Service ID)
        • 1xxxxxx - (Service ID)
  • Nived_Nambiar Profile Picture
    18,029 Super User 2025 Season 2 on at
    Re: Filtering an Email to list services

    Hi @MRasmus 

     

    Logic i would recommend to try is :

     

    1. Trigger flow when email with body Affected Service(s) arrives in mailbox.

    2. Using string functions, remove account name , account number part from the email body, remaning would be service ids

    3. Split the service ids using new line and then loop through each service ids and perform required operation

     

    This is a high level overview, let me know if you need additional details 🙂

  • MRasmus Profile Picture
    18 on at
    Re: Filtering an Email to list services

    Also to mention the affected service i posted above is only 1 part of the email. There is a bunch of text before and after the affected services.

     

    How would i setup a split then loop it? This part is confusing. How does it know when to stop?

  • Nived_Nambiar Profile Picture
    18,029 Super User 2025 Season 2 on at
    Re: Filtering an Email to list services

    Could you show me what kind of content is present after service Ids?

     

  • MRasmus Profile Picture
    18 on at
    Re: Filtering an Email to list services

    Nived, Below is the email i get. i only just notice some formatting changes when copying it across from the email to hear but this is basically what it looks like. the only major difference is the amount of service ID's listed under the account number.

    The account name and number are the same on every email as it is under our account as we then resell the services on so the serives ID's are for my customers.

     

    Due to third party planned network maintenance in the state of (STATE), your listed service(s) may experience a disruption during the outage window advised.

    In the event your service does not restore on completion of the planned event, please reset your interfacing equipment or link.

    If your service does not restore after the aforementioned reset please contact our Service Assurance Team to investigate further.

    We apologise for any inconvenience this may cause.

    Work Start: 18/05/2023 12:30 AM
    Work End: 18/05/2023 06:30 AM
    Timezone: Sydney/NSW
    Outage Duration: 20 mins

    Affected Service(s):
    Site Address: N/A

    (Account Name)

    • (Account Number)
      • 1xxxxxxxx - (Service ID)
      • 1xxxxxxxx - (Service ID)
      • 1xxxxxx - (Service ID)
      • 1xxxxxx - (Service ID)
      • 1xxxxxx - (Service ID)

    If you require further information relating to this Change, please e-mail us on (provider Email) or call (Provider Number). Planned outage team operations hours are business days from 9 AM to 5 PM.

    If the listed service(s) fail to restore after the planned Change completion time, please report a fault to corporate help desk.

    If you would like to change the contact point for these planned outage notifications, please e-mail us on (provider Email)

    Acceptance of this notification is presumed to have occurred unless we are advised otherwise.

    Kind Regards,
    (Provider)

    This communication, including any attachments, is confidential. If you are not the intended recipient, you should not read it - please contact me immediately, destroy it, and do not copy or use any part of this communication or disclose anything about it.

  • VictorIvanidze Profile Picture
    12,875 on at
    Re: Filtering an Email to list services

    Just parse the HTML body of email to retrieve the data you are interested in.

  • MRasmus Profile Picture
    18 on at
    Re: Filtering an Email to list services

    Hello @VictorIvanidze 

    Sorry i don't know what that means. I very new to MS Flow. could you please provide an example of the Parse?

  • MRasmus Profile Picture
    18 on at
    Re: Filtering an Email to list services

    @Nived_Nambiar were you able to have a look at the full email template I posted?

  • Nived_Nambiar Profile Picture
    18,029 Super User 2025 Season 2 on at
    Re: Filtering an Email to list services

    Hi @MRasmus 

     

    May i know two things ?

     

    1. Does account name and account number would be constant ?

     

    2. Also last part of email 

    If you require further information relating to this Change, please e-mail us on (provider Email) or call (Provider Number). Planned outage team operations hours are business days from 9 AM to 5 PM.

    If the listed service(s) fail to restore after the planned Change completion time, please report a fault to corporate help desk.

    If you would like to change the contact point for these planned outage notifications, please e-mail us on (provider Email)

    Acceptance of this notification is presumed to have occurred unless we are advised otherwise.

    Kind Regards,
    (Provider)

    This communication, including any attachments, is confidential. If you are not the intended recipient, you should not read it - please contact me immediately, destroy it, and do not copy or use any part of this communication or disclose anything about it.

     

    would be constant as well ?

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard