Apr 08 2019 12:30 AM
Apr 08 2019 12:30 AM
We have a Outlook Inbox that has a subfolder in this that contains lots of emails with attachments on them.
We want to be able to extract the attachment from these emails and save them into a folder.
We believe we can do this for new emails coming into the inbox using flow but anyone know if its possible to run flow or something else to extract the attachments that are already sitting in the email folder?
Apr 08 2019 12:55 AM
Apr 12 2019 12:19 AM
Thanks @Rob Ellis
I have been setting up your ideas, however it doesn't seam work.
What seams to happen is that if I manually copy 1 email into the subfolder and then MANUALLY run the flow it will copy the attachment to a sharepoint or onedrive site
However if I copy 2 or 3 email it and then manually run it will only copy the attachment from the "newest" email, it will ignore the other emails.
It NEVER run automatically.
Attached are screen shots of what I have done - any ideas on how to get this working would be appreciated.
Apr 12 2019 01:05 AM
@Pn1995 It is likely that the trigger does not occur when you move an existing email into the folder - try configuring an Outlook rule to move messages into that folder when received, then send a test email.
For dealing with existing emails in the folder, my 2nd option would be the one to go for, I think.
That would need to be triggered manually or on a schedule, and use the action 'get emails' (not 'get email' - because you want more than 1)
Apr 12 2019 04:22 AM
Thanks again Rob
I tried to get emails but it still seams to do the same thing. When I manually trigger (I guess you mean just press Test) it only ever seams to look at 1 email in the folder not all of the,
This is my setup...any other suggestions would be appreciated
Apr 12 2019 05:08 AM
I'm not using a shared mailbox, I'm testing with my user mailbox, so the trigger I have is 'when an email is received' - but using the action as per below, if I move an unread email or a read email from another folder into the 'Processed' folder - the flow triggers and saves out the attachment every time:
so in theory that would work if you created a new folder and had that flow trigger on the new folder, then moved emails from another folder into the new folder.
I'll give it a go using a shared mailbox - BRB.
Apr 12 2019 05:36 AM
Thanks @Rob Ellis, I guess the main issue we are having is that it doesn't seam to trigger if more than 1 email is moved - ie if we move or copy 3, 4 or 5 emails it only every processes the "newest" one of those mails.
and we can't seam to get it to look at a existing mailbox that has the 2000 attachments in there and process more than 1 of those
Apr 12 2019 05:39 AM
Thanks @Rob Ellis
I guess the main issue is that it needs to trigger if we copy or move more than 1 email at a time in there and it doesn't seam to do that. It only every saves the attachment of the latest email, So if you copy day 5 mails into the folder only mail 1 will have its attachment saved
The folder we want to process the attachment in has 2000 emails, and we can't seam to get it to analyse this folder and extract from there
Apr 12 2019 06:13 AM
@Pn1995 I can see that issue, agreed - it only triggers on the most recent email - including if using an Outlook rule to move the emails into the folder.
Using a manually triggered flow like this will do what you need
(Note I have mine set to only get unread emails, and limit to 10 - so you will need to increase that):
Apr 12 2019 06:39 AM
Thanks again @Rob Ellis
So just to confirm in order for it to "process" more than 1 email you are suggesting that I need to created a "Apply to each" action - so if I want to process 10 emails create 10 "Apply to each"
Also in the "Get Email" "Top" field were you have 10, isn't there a limit of 25 to that?
Apr 12 2019 06:47 AMSolution
Feb 07 2020 07:26 AM - edited Feb 07 2020 07:32 AM
We can use Instant Flow --> When an email is flagged --> Save attachment to One Drive folder.
After creating flow select all mails and add flag then the flow will run
I Did this one for 1500 mails