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

Extract email address from email attachment to use in a Flow

Here is my scenario:

I am receiving emails with resumes as attachments.

I would like to check if the email address that appears on a resume already exists on my database (in order to distinguish between senders that already have a record on my system from those who do not).

 

To do this I need to somehow extract the email address from the attachment (PDF / DOC / DOCX).

Currently, Parserr do not support DOC & DOCX files.

 

I was thinking of somehow using the 'Regular Expression': [a-zA-Z0-9-_.]+@[a-zA-Z0-9-_.]+ Or using an Excel method like this one: https://goo.gl/t47Cl (however I believe that Flow currently does not support .xlsm files (Excel files with macros).

My challenge is to incorporate an email address extraction method into a Microsoft Flow.

 

Does anyone have an idea how to achieve this?

7 REPLIES 7
efialttes
Super User III
Super User III

@OmSh

If your flow is the only way to upload resumes to your database, why don't you store both the sender and the attachments? This way, anytime you receive a new email, you can check easily if the sender has been already stored.

This is very easy to implement if you use Sharepoint Library and add Sender as a custom property.

You can get From, CC very easily from the Trigger When a new Email Arrives (I am attaching a link to the doc for Office 365 Outlook, other email connectors would probably provide such info also)

https://docs.microsoft.com/en-us/connectors/office365/#When_a_new_email_arrives

 

But if your database only allows file storage, another approach is to edit filename before storing it; by adding the sender (probably you will need to tralslate special characters in order to force the final name be a valid filename).

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



OmSh
Frequent Visitor

@efialttes

Thank you for your kind reply.

The thing is these emails arrive from job boards whereas the sender is a generic website address (i.e. applicant@indeed.com) & not the person who is applying.

efialttes
Super User III
Super User III

Sorry for the misunderstanding, @OmSh.
Very interested to know if Flow allows to parse doc/docx/pdf files. From my little experience no regular expressions are supported yet; current supporred expressions can be found here:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



v-xida-msft
Community Support
Community Support

Hi @OmSh,

 

The “Regular expression” is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please vote the following idea:

https://powerusers.microsoft.com/t5/Flow-Ideas/Support-for-regex-either-in-conditions-or-as-an-actio...

 

I afraid that there is no way to extract email address of attachment files of incoming emails in Microsoft Flow currently.

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
OmSh
Frequent Visitor

Thank you @v-xida-msft,

 

Would you happen to know of a third party solution that can Parse a document?
Any solution that can take an email and reply with an email would do.

Strangely enogh, the only Parsing solution that is currently associated with MS Flow - Parserr, does not support doc & docx files.

Perhaps there is a way to convert Doc fils into PDF inside a flow?

This way Parserr could work. @efialttes

 

Thanks again

v-xida-msft
Community Support
Community Support

Hi @OmSh,

 

You could consider take a try to convert Doc files into PDF files with "Convert file" action of OneDrive Connector or "Convert document" action of Muhimbi PDF Connector inMicrosoft Flow.

 

More details about OneDrive connector, please check the following document:

OneDrive connector

 

More details about "Convert document" action of Muhimbi PDF Connector, please check the following document:

Convert document

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
OmSh
Frequent Visitor

Thank you Kris @v-xida-msft

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,160)