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
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:
Image reference:The flow works successfully as below:
More details about Excel connector, please check the following article:
Best regards,
Kris
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!
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
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
45 | |
43 | |
43 | |
42 | |
35 |
User | Count |
---|---|
85 | |
78 | |
62 | |
51 | |
47 |