cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nightfall
Level: Powered On

Most efficient way to dynamically filter new emails on shared mailbox

Hello everybody!

I send monthly an automated documentation request to my clients through flow, which populates an excel file with an unique reference number for each client. Another flow is then triggered by “when an email is received on shared mailbox”: the email, if it has attachment, is checked in the body for the presence of one of the reference numbers included in a table of the excel file.
If this is the case, the file is saved in a dynamic folder on OneDrive.

I was wondering if there’s a more efficient way to achieve that, because the opening of the excel for each incoming email with attachment is quite time and resource-consuming (e.g. ~40 seconds with a test email, with only one “client” in the list in the excel file).

E.g. a sharepoint list would be faster than excel??

Thank you and best regards,

Vittorio
2 REPLIES 2
Super User
Super User

Re: Most efficient way to dynamically filter new emails on shared mailbox

@nightfall 

Hi there.  Are you using any kind of CRM?  It sounds like you want to track emails specific to a customer and/or project in a single place, and this is out-of-the-box functionality for most of them.

 

If you want to continue this path, though, maybe consider putting the unique identifier in the email Subject (at the end in parens or something).  This should speed up your read times.

 

Either way, keep us posted.

 

-Ed-

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Community Support Team
Community Support Team

Re: Most efficient way to dynamically filter new emails on shared mailbox

Hi @nightfall,

 

Has your problem been solved by @edgonzales 's advice?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 136 members 4,568 guests
Please welcome our newest community members: