3,500 Outlook emails - filter subject line to Excel List & save attachment to OneDrive

[AlyneRankin]

Hello Flow Community,

This is my first time creating a Flow.

I am expecting to recieve 3500 emails, each one with an image attachement and a persons name in the subject line.

I already have the flow template that takes attachments and puts them in a OneDrive folder, this works great for me.

However, I would also like to create an excel list that lists out all the names in the email subject line and cross references that to the file name of the attachment? Can anyone help in pointing me in the right direction if one such template exists?

I should also add - all emails are being sent to a new emaill address/account being set up so in otherwords I only expect the 3500 emails with attachemnets to come in. No other filtering to worry about - i think. 

Thanks in advance,

A newbie to Flow 

[v-xida-msft]

Hi @AlyneRankin,

Do you use the built-in template “Save Office 365 email attachments to OneDrive for Business” of Microsoft Flow?

Does the incoming email have any other attachment files except an image file?

There is no such template existed in built-in templates of Microsoft Flow currently, but you could consider take a try to create such flow from blank.

I create an Excel file whose content is formatted as a table in my OneDrive for Business folder. The data structure of my Excel file as below:

If the incoming email only contains one image attachment file, I have made a test on my side and please take a try with the following workaround:

• Add “When a new email arrives” trigger of Outlook 365. Click “Show advanced options”, set Has Attachment to Yes and Include Attachments to Yes:

• Add a “Apply to each”, Input parameter set to output of above trigger.
• Within “Apply to each”, add “Insert row” action of Excel connector, specify File name and Table name.
• Add a “Create file” action, specify Folder Path, File Name (Dynamic Attachment Name) and File content (Dynamic Attachment content).

Image reference:The flow works successfully as below:

More details about Excel connector, please check the following article:

Excel connector

Best regards,

Kris

[AlyneRankin]

Kris,

This worked fantastic! With the test complete we are almost ready to start accepting the emails. Thank you!

Another question:

1. is it possible to set up flow to send me daily emails on the number of succesful runs it completed. I dont want to recieve an email every time someone sends a file (3500 - yikes) but can it send me what it runs at the end of the day?

Many thanks again!

[v-xida-msft]

Hi @AlyneRankin,

Do you want to send daily emails on the number of successful runs it completed within previous flow that I provided?

I think there is no way to send daily emails on the number of successful runs it completed within previous flow in Microsoft Flow currently.

I suppose that you want to get all received emails in your Inbox folder of your Outlook daily, but there is a limit in the number of emails that we could get in Microsoft Flow currently. We could only get 25 emails of Outlook at most using "Get emails" action of Outlook connector in Microsoft Flow currently. I afraid that there is no way to achieve your needs in Microsoft Flow currently.

Best regards,

Kris