cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DesmondDekker
Frequent Visitor

Adding up client names from a table in an outlook email

Hello guys,

I'm a new person here and I'm not sure if somebody has already tried to create something like that, but I couldn't find the answer in the forum. 


I'm currently working on a flow which extracts specific data from an email and puts information under appropriate columns in the Excel table:

 

DesmondDekker_1-1608738090261.png

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 

Here is my flow - (the variable "vDateTime" is not so important here and it works fine, so you can skip it):

DesmondDekker_1-1608733923533.png


The main goal of this tracker is to store all emails which come on our shared mailbox. However, some emails have a table where there are names of the clients and other specifications regarding these entities. We would like to filter this kind of emails (I'm trying to do it by using a condition action) and calculate how many clients are mentioned in a specific table:

DesmondDekker_2-1608734525198.png


DesmondDekker_6-1608735303083.png

(the example of a table which can be found in an outlook email)

 

So here the goal would be only to calculate the number of client names.

 

The result of the aforementioned calculation would be 3 (since there are 3 client names in the table). Finally, this total sum would be put under one of the columns in the excel file which I have mentioned at the beginning of my post:

 

DesmondDekker_4-1608735073416.png

 

 
 
 
 

Do you think it is possible to create something like that?

 



4 REPLIES 4
Paulie78
Super User
Super User

It is certainly possible, likely to be quite tricky and unless the incoming emails are very consistent it could be quite prone to errors. 

Totally agree, that's why I'm trying to use a condition action and the function "or". There are 2 types of emails with this sort of table and they always have the same keywords in their subjects. My idea is to look for these keywords in a subject, then check if the subject doesn't start with RE: - since it will mean that this has already been calculated in another row - and then start adding up client names (values only under the first column every time).

Unfortunately, I have no idea how to start doing it, I can only extract some words from email by using an array. Could you help me? And what do you think about this idea?

Paulie78
Super User
Super User

I would personally use mailparser.io for this, but it could also be possible just in Power Automate. You're going to have to post a sample of the HTML source code for any good guidance on how to do it.

Thanks for the answer. Do you mean a source code which I can extract from an email in Outlook or a source code which can be found under a specific "run" in Power Automate? (I mean the record which can be found under "Run History")

DesmondDekker_0-1609695655620.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (3,069)