Extract and parse data from an email 05-19-2020 23:27 PM - last edited 05-20-2020 08:26 AM

[Django]

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

[Django]

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:

and then import the stand-alone-flow:

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

[baessa]

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

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?

[Django]

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 👍

[baessa]

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

[Anonymous]

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

[Django]

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 👍

[RishiD]

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

[Django]

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 💪👍

[mopyd]

Can not get this to run successfully. Errors out at "Apply to each KeyToFind". Ive uploaded screenshots. 

I am trying to pull service ticket information (Date, Ticket number, Company, Contact, and Technician) from an email. Then put it into an excel file. 

Any help would be greatly appreciated. Thank you!

[Django]

Hi @mopyd , 

Your screenshot is telling you how the substring expression is nog getting the right parameters.

If your text is 9366 characters long, you cannot get characters beyond this number because there are not any 😁
Have you watched the full video because the description states that you can "change the key-value separator" so you can apply your own text to look for.

Also note the examples because the text has to follow a format which is logical (key-value separator).