Unanswered

Exract data from email body and add to another email

(0) Share

Report

Posted on by jestit7993

Hello, I'm trying to build a PA flow that will extract data from emails and deliver this data via email. My current solution looks something like this and uses index numbers to split data from specific lines.

This works fine with a single recipient, but the problem I run into is that if there are multiple recipients, additional lines are created which throws everything out of wack. The incoming mail uses a standard format (see attachment) which only deviates when additional recipients are added.

Does anyone know how I can create a flow that will specifically pull the data for Sender: , Subject: , and Recipients: so that they can be referenced in a compose email action?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Unknown geen idee 1,757 on at

Like (0)

Report
Copy link

Link copied!
Dear J,

Reading your issue I have several questions/comments:
What is exactly the difference in data when you have multiple recipients? Please show in example.
Can you manipulate the syntax of the email/input data?
If so, could you get rid of the email and just pull details directly from a form/table/database. This may solve your whole issue as you would be able to pull the data in a structured way.
If so, you could choose to create a message which is more easily 'read/split' by the flow. For example you could create a XML data ... or a complete JSON array ... or just add in some special characters to help with the split.
Why would you split based on index? Why not split based on the default data labels you have in the email text message? You can split the email body for example on 'Sender:', 'Recipient:', etc. You can build an array with this for further processing. This would also seem to resolve your multiple recipient issue (depending on the what the output email is when you have multiple recipients.

Hope the suggestions help,
Happy flowing,
Koen

Was this reply helpful? Yes No
jestit7993 18 on at

Like (0)

Report
Copy link

Link copied!

Hi Koen,

I'm newer to PA so I'm sure there are better ways to accomplish this, I'm open to any suggestions. I did some work on this last night and have a flow that more so accomplishes what I'm looking for.

This flow puts the HTML to text output into a string variable and uses a series of compose steps to find the needed data. An example of one of the expressions is below which grabs the subject line.

first(split(last(split(variables('varOutput'),'Subject:')),decodeUriComponent('%0A')))

So far the flow has been able to extract the needed fields, regardless of how many recipients there are.

Was this reply helpful? Yes No
Unknown geen idee 1,757 on at

Like (1)

Report
Copy link

Link copied!

Great, there are only but a few flows in which finetuning of steps really makes sense performance wise ... otherwise 'If it works, it works'. And leave it at that.

Was this reply helpful? Yes No