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?
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)
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
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. firstname.lastname@example.org) & not the person who is applying.
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:
I afraid that there is no way to extract email address of attachment files of incoming emails in Microsoft Flow currently.
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
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:
More details about "Convert document" action of Muhimbi PDF Connector, please check the following document:
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.