Below is how I would build the flow, so you have easy access to all the properties from the email.
See full flow below. I'll go into each of the actions. Note that the actions highlighted in yellow are just for testing purposes.
Body is a Compose that takes the Body from When a new email arrives. The expression used replaces any occurrences of with a standard space character.
replace(triggerOutputs()?['body/body'], ' ', ' ')
Html to text then takes the output from the Body (Compose action above).
Select splits the data into an array of strings and, trims each one. The expressions used are:
//From
split(outputs('Html_to_text')?['body'], decodeUriComponent('%0A'))
//Map
trim(item())
Filter array takes the output from Select and removes any empty rows. The expression used is:
item()
XML (Compose) converts the output from Filter array into XML so we can use XPath to extract out the property values. The expression used is:
xml(json(concat('{"root": { value:', body('Filter_array'), '}}')))
Compose is used to extract out each of the property values from the XML output into a single object. Below is the expressions used. You can just copy/paste this directly into a Compose action.
{
"Company": @{xpath(outputs('XML'), 'string( //value[.="Company:"]/following-sibling::*[1]/text())')},
"Business Unit": @{xpath(outputs('XML'), 'string( //value[.="Business Unit:"]/following-sibling::*[1]/text())')},
"Department": @{xpath(outputs('XML'), 'string( //value[.="Department:"]/following-sibling::*[1]/text())')},
"Work Location": @{xpath(outputs('XML'), 'string( //value[.="Work Location:"]/following-sibling::*[1]/text())')},
"Discipline": @{xpath(outputs('XML'), 'string( //value[.="Discipline:"]/following-sibling::*[1]/text())')},
"Sales Location": @{xpath(outputs('XML'), 'string( //value[.="Sales Location:"]/following-sibling::*[1]/text())')},
"FO Unit": @{xpath(outputs('XML'), 'string( //value[.="FO Unit:"]/following-sibling::*[1]/text())')},
"Service": @{xpath(outputs('XML'), 'string( //value[.="Service:"]/following-sibling::*[1]/text())')},
"Start Date": @{xpath(outputs('XML'), 'string( //value[.="Start Date:"]/following-sibling::*[1]/text())')},
"Job Code": @{xpath(outputs('XML'), 'string( //value[.="Job Code:"]/following-sibling::*[1]/text())')},
"Job Title": @{xpath(outputs('XML'), 'string( //value[.="Job Title:"]/following-sibling::*[1]/text())')},
"Standard Hours": @{xpath(outputs('XML'), 'string( //value[.="Standard Hours:"]/following-sibling::*[1]/text())')},
"New Hire Type": @{xpath(outputs('XML'), 'string( //value[.="New Hire Type:"]/following-sibling::*[1]/text())')},
"Recruiter": @{xpath(outputs('XML'), 'string( //value[.="Recruiter:"]/following-sibling::*[1]/text())')},
"Supervisor": @{xpath(outputs('XML'), 'string( //value[.="Supervisor:"]/following-sibling::*[1]/text())')},
"Dept. Head Approval": @{xpath(outputs('XML'), 'string( //value[.="Dept. Head Approval:"]/following-sibling::*[1]/text())')},
"Finance Dept. Approval": @{xpath(outputs('XML'), 'string( //value[.="Finance Dept. Approval:"]/following-sibling::*[1]/text())')},
"Name": @{xpath(outputs('XML'), 'string( //value[.="Name:"]/following-sibling::*[1]/text())')},
"Preferred First Name": @{xpath(outputs('XML'), 'string( //value[.="Preferred First Name:"]/following-sibling::*[1]/text())')},
"Home Email": @{xpath(outputs('XML'), 'string( //value[.="Home Email:"]/following-sibling::*[1]/text())')},
"Contact No.": @{xpath(outputs('XML'), 'string( //value[.="Contact No.:"]/following-sibling::*[1]/text())')}
}
I've then added a Parse JSON that will provide us with easy access to the data via Dynamic content. The schema used is:
{
"type": "object",
"properties": {
"Company": {
"type": "string"
},
"Business Unit": {
"type": "string"
},
"Department": {
"type": "string"
},
"Work Location": {
"type": "string"
},
"Discipline": {
"type": "string"
},
"Sales Location": {
"type": "string"
},
"FO Unit": {
"type": "string"
},
"Service": {
"type": "string"
},
"Start Date": {
"type": "string"
},
"Job Code": {
"type": "string"
},
"Job Title": {
"type": "string"
},
"Standard Hours": {
"type": "string"
},
"New Hire Type": {
"type": "string"
},
"Recruiter": {
"type": "string"
},
"Supervisor": {
"type": "string"
},
"Dept. Head Approval": {
"type": "string"
},
"Finance Dept. Approval": {
"type": "string"
},
"Name": {
"type": "string"
},
"Preferred First Name": {
"type": "string"
},
"Home Email": {
"type": "string"
},
"Contact No.": {
"type": "string"
}
}
}
Below is what we would get when running the flow.
If we try to access the data, we can just select the Property Name we want in the Dynamic content.
To extract just the First Name of the person, we can either choose to use the Preferred First Name property or extract it from the Full Name. See expression below:
first(split(body('Parse_JSON')?['Name'], ' '))
And to get the Last Name (everything from the Full Name after the First Name).
trim(slice(body('Parse_JSON')?['Name'], indexOf(body('Parse_JSON')?['Name'], ' ')))
After running the flow as it is, we would get the following output.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
