Skip to main content
Power Automate
    • Connectors
    • Templates
    • Take a guided tour
    • Digital process automation
    • Robotic process automation
    • Business process automation
    • Process advisor
    • AI Builder
  • Pricing
  • Partners
    • Blog
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinar
    • Business process and workflow automation topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power Automate Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Automate
    • General Power Automate Discussion
    • Using Connectors
    • Building Flows
    • Using Flows
    • Power Automate Desktop
    • Process Advisor
    • AI Builder
    • Power Automate Mobile App
    • Translation Quality Feedback
    • Connector Development
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Galleries
    • Community Connections & How-To Videos
    • Webinars and Video Gallery
    • Power Automate Cookbook
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community AMA
    • Community Blog
    • Power Automate Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power Automate Community
    • Galleries
    • Power Automate Cookbook
    • Re: Extract and parse data from an email

    Re: Extract and parse data from an email

    06-09-2022 11:34 AM

    Django
    MVP
    2900 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Django
    Django
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Extract and parse data from an email

    ‎05-19-2020 11:27 PM

    Title: Data extraction and parsing from an email

     

    Description: This Flow triggers on an email received to check its body on a dynamic number of keys to find its corresponding value. The trick is in an Apply to each loop based on an array you can manage from within the flow. The flow will find the keys and values you want to extract and parse.

     

    Detailed Instructions: It’s as easy as importing the zipped flow attached, add your connection for Outlook Office 365 and it will trigger on your own inbox emails. I recommend additional filters (like a specific unique phrase in the subject or only a specific mailbox folder) so the flow will only trigger on emails that it should trigger on. Keep in mind that the flow expects a specific key to find and you can change the key in the array step of the flow. You can even change the key-value separator as explained in the video.

     

    Questions: Please feel free to ask anything right here as a reply in this post.

     

     

     

    watch?v=e_8hQibvbYQ

    Preview file
    61 KB
    FlowTest-EmailgetData_20200520061714.zip
    Labels:
    • Labels:
    • Automated Flows
    Message 1 of 48
    65,949 Views
    18 Kudos
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    • « Previous
      • 1
      • 2
      • 3
      • 4
      • 5
    • Next »
    Django
    Django
    MVP
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-25-2021 12:10 PM

    Hi @Anonymous ,

    The .zip file is a Power Automate Flow and not a complete Power Platform Solution.

    You should be able to import from your Power Automate Portal using the Import button:

    Django_0-1635188937793.png

    and then import the stand-alone-flow:

    Django_1-1635188969530.png

     

    See: Export and import your flows across environments with packaging | Power Automate Blog (microsoft.com)

    Message 41 of 48
    3,653 Views
    0 Kudos
    Reply
    baessa
    baessa Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-17-2021 03:43 AM

    Hello everyone,

    I am new in Power Automated and I would like to know how can I setup a flow that collects information from some emails and then send those information to a specific email address.

    The information that needs to be collected is just if the email comes with a successful job, warning job or critical job.

    I need to get the info that is highlighted in yellow for multiple emails notifications

    baessa_0-1637149298739.png

     

    What I need is to get the info from those emails backup job name and if success or warning or error to send an email with its status.

    I am looking to have 2 emails daily with the jobs done instead of having to check all 30 emails one by one.
    I am not sure how to have a flow that gets the backup name and status (Success/warning/failure). then filter and send a notification with the jobs according to its status.

    Could you help me please?

    Message 42 of 48
    3,595 Views
    0 Kudos
    Reply
    Django
    Django
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-19-2021 03:56 AM

    Hi @baessa, 

    There are definitely possibilities but as you can see in all the posts above:

    1 - this is Power Automate on a higher level so a steep learning curve is needed

    2 - every use case (and every email setup) is different so there is no "one size fits all"-approach when extracting / parsing data

     

    The best way to involve as much interested people as possible for your specific case would be to reach out for help by raising your own question in the Power Automate community: Building Flows - Power Platform Community (microsoft.com).
    Reply to us here with a link to your question: this will help other community members of this post to find your post 👍

    Message 43 of 48
    3,565 Views
    0 Kudos
    Reply
    baessa
    baessa Helper I
    Helper I
    In response to Django
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-19-2021 07:18 AM

    Hi @Django 

    I had raised already but still not gettting any support.


    Here is the link
    https://powerusers.microsoft.com/t5/General-Power-Automate/Processing-emails/td-p/1350193

    Message 44 of 48
    3,561 Views
    1 Kudo
    Reply
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-28-2021 06:25 AM

    Hi,

    I am having a hard time setting up my array flow to receive emails.

    This is what I have:

       
      "> Name: Brian young\n>",                                        
      "> Email: brian2722@icloud.com\n>",                                       
      "> Phone: 9549946511 [tel:9549946511]\n>",                                      
      "> Zipcode: 32907\n>",                                        
      "> State: Florida\n>",                                        
      "> City: Palm Bay\n>",                                        
    I am just now learning this, so any help would be greatly appreciated     
                                               
    Message 45 of 48
    3,528 Views
    0 Kudos
    Reply
    Django
    Django
    MVP
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-03-2021 04:47 AM

    Hi @Anonymous,

    Please use the Building Flows - Power Platform Community (microsoft.com) to post your specific question.

    Posting as much details as possible (what do you want to achieve, what have you already built, examples etc) will get you helped faster.

    Feel free to mention me 👍

    Message 46 of 48
    3,472 Views
    0 Kudos
    Reply
    RishiD
    RishiD
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-07-2022 02:57 AM

    Hello Django,

     

    I used this to extract from address of an email which was forwarded but is there a way to find the original form email address when an email has been forwarded multiple time?
    https://willpage.dev/2020/08/21/extract-from-address-from-forwarded-email-in-power-automate-logic-ap...

     

    Thanks

    Message 47 of 48
    2,918 Views
    0 Kudos
    Reply
    Django
    Django
    MVP
    In response to RishiD
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-09-2022 11:34 AM

    Hi @RishiD, if you have found consistency in the way the forwarding is saved to the body or subject of the email (maybe the FW abbreviation is found an x number of times),

    then it can be done using a combination of split / lastindexof / last / substring functions: Reference guide for expression functions - Azure Logic Apps | Microsoft Docs.

    Very specific though so let us know if you have found a pattern 💪👍

    Message 48 of 48
    2,900 Views
    0 Kudos
    Reply
    • « Previous
      • 1
      • 2
      • 3
      • 4
      • 5
    • Next »

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign up free
    • Sign in

    Browse

    • Templates
    • Connectors
    • Partners

    Downloads

    • Mobile
    • Gateway

    Learn

    • Documentation
    • Learn
    • Support
    • Community
    • Give feedback
    • Blog
    • Pricing

    • © 2023 Microsoft
    • Contact us
    • Trademarks
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Terms & conditions
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices