Extracting Individual Values of an Email Body Via HTML to Text

[MDE94]

Before I begin, I'll start off by saying if I was wanting to extract email data with a body similar to this I'd have no problem:

Name: XXXXX

Age: XX

Location: XXXX

This is because the email body is plain text, aligned left as default with no formatting other than a simple row separation. Many tutorials exist which have a similar set up by which they have restricted the received input of the email being received from an end-user, often in the form of a customer satisfaction survey or contact form.

This allows for a simple first(skip(split(first(split(body('Html_to_text'),'Name')),': '),1)) input to generate a flow from the first line of the body capturing the Name field, this will then update in an Excel file I have stored within OneDrive tied with the flow. 

The issue I have is that I am not capturing data of an email I have generated a back-end form for, I would like to capture data of an email which has centralised text and a number of irrelevant text items in the body that should be ignored prior to the necessary fields.

The email I wish to create a flow and automate data for is Microsoft Endpoint Vulnerability notifications, the difficulty is the email has text aligned centred and the only relevant information is halfway down the page. I wish to learn an expression which could be inserted to pull this specific information into an Excel document I have created that will store these values in a table. 

Here are two images showing the email example I receive: 

Email Example 1/2Example Example 2/2 showing centred formatting

I only wish to extract the information below 'Vulnerability Details'. Any guidance is appreciated, one plausible solution I thought was potentially just converting this received email to plain text (stripping formatting) then creating a flow to extract the data of a basic email body. Though this would be creating an additional step of email received, convert to plain text, then implementing html to text flow.

Finally, here is an example of the 'Add Rows to Excel Table' flow entries for complete illustration: 

[SudeepGhatakNZ]

Why would you want to parse the email?

Can you not just use the Microsoft Security APIs to read the vulnerabilities in real-time?

Use the Microsoft Graph security API - Microsoft Graph v1.0 | Microsoft Learn

[MDE94]

Thankyou for highlighting this, I'm trying to develop something which goes beyond this initial parsing for my workplace. The intention is to have this as an archive but also to further analyse and automate a process for prioritising vulnerabilities for our needs, this includes automatically assigning to specific employees to resolve the issue. Extracting the data into Excel or Sharepoint lists is the first step, I just wish to know if there is a way of grabbing only the information below 'Vulnerability Details' ignoring the prior information. 

[SudeepGhatakNZ]

Watch this video:

https://youtube.com/watch?v=7tZ6bRtco3Y&feature=share&si=EMSIkaIECMiOmarE6JChQQ

[MDE94 · Accepted solution]

I have solved this already but thank you for the video anyway, it was close to what I needed. The key was to input variables which essentially ignore the body other than the key bits of information I require, I likely worded my original post badly but thank you again for your fast support.

Another key note to mention is inspecting the email's raw HTML code to see if there is anything hidden that is required for accurate separation.