This makes understanding of how flow works so simple. Keep up the good work and thank you so much this saved me hours of testing. It worked first time with no issues.
Great pace to your videos, not lingering on anything for too long. Clear instructions and informative. I have a question, Can you scan through your inbox for specific attachments, say a certain file you get sent each morning to move them to one drive, emails already in your inbox. Thanks in advance
Thank you for your compliments! If you know the name that the file will be when you receive it, you can scan for if the file name matches the one you want to receive, then move on to the next steps of delivering it automatically to your one drive.
@@henryouang Hi Henry, well done. To expand on the above follow-up question, the case may be one needs to only isolate the attachment by file type. This applies when, lets say the email has multiple file types, pdfs, word and one is only interested in the CSV for example. 2. It would be ideal to have a naming convention for the attachments such as time and date stamp. I can imagine depending on velocity; after 100's of attachments it would be a nightmare really. Any thoughts? Thanks
Thank you, Henry, for this wonderful guide. I just tested it, and it worked very well for me. Can you give a guide on how to save attachment from specific email addresses to specific folders. Thank you
Hi. I have a question...In my case the banner and logo of our company are auto-saved in the same folder I created for flows since it is also considered as an attachment. Is there a way that we can set the company logo not to be saved when an email is from a colleague? Is there anyway we can set that?
You can use a "Condition" step where you can say "If the filename is equal to [your logo name], then do not save this file. Otherwise, continue on with saving the file to the onedrive." Let me know if you need additional clarification!
@@henryouang i'll check. also is it possible for a flow to be created if a new video or file is uploaded on a shared drive (maybe synched from computer ) for a notification to be sent to a different email address?
I have question @HenryOuang Its it possible to add link of that particular attachment in excel too. so that link can direct me to that one drive document.
That's great Thanks! this already helps alot, just wanted to check if you can do a video of how to update excel sheet from automated Email with attachment. I get this daily report from System, and i just need to copy paste it into another sheet on my Local PC or Sharepoint doesn't really matter.
Hi Henry, I wonder how to remove such a flow (stop outlook attachment from being saved in OneDrive). I have tried under Connections to remove my email address. But it doesn't seem to stop those attachments from taking up OneDrive space though. Could you please guide me? Thank you
Hey Henry, thank you for the video. It would be great if you create another video on Sharepoint folders/files (move/copy) onedrive folder and delete from the sharepoint. It will benefit some of us New Users here. Thumbs up!
Hey Henry, is there a way to convert a large .xlsx file to a smaller .xlsb format prior to downloading? my files that come in daily are 50mb or greater and it doesn't appear that it will work on those sizes
Is there a way to download all attachments from previous emails, not just "When new email arrives" to save them to OneDrive or sharpoint document library?
This worked for me: I created the flow and my rule was for emails in a specific folder (new folder without emails), then when the flow was working correctly I created a rule in outlook to move all the emails with those charateristics I want to the new folder, and executed the rule for all the emails, outlook moves the emails to the new folder and that's a trigger for the flow to run.
Thank you so so much, BUT i have a question: Can i override the attachment? like i want it to be deleted whenever theres a new attachment with the same title?
Hi SheSpecial 20, I’m just going to copy my comment to Jim beneath here. You can set a different step up to delete the file with the name you want to "overwrite" and then recreate it with the date you received in the email. This is the same function as overwriting!
@@henryouang Thank you for correcting me "overwrite" :) Though i followed your steps, but i didn't receive the file yet. does the file type (xlsx)could be the reason?
@@beingme1607 Very late reply ( 8 months ago, I know) but you can use a dynamic naming convention by adding a , and the flow will save the new attachment with the same name but it will be with the updated data. I used a concatenation string can called my file "Dynamic Data Source.csv". My Apply to Each step contains two subtask 1) compose dynamic name and 2) Create Dynamic Named File path
Hi Henry, is it possible for flow to save automatically an attachment that always has a standard name ... Example of an attachment "Sales_12345" in this case the attachment has "Sales" name then in that case save the attachment in the sales folder?
Hi Henry. This is exactly what I was looking for. Thanks! Can you also tell me how we can apply this flow to an existing folder with existing email with attachments in the same outlook location?
Thanks, Henry, what happens to the email attachment after it has been worked flowed to OnDrive. Does it still available in outlook inbox or it gets removed and only available in OneDrive. Thanks, Sassan
Hi Henry, question Can I track attachment/files into Excel as well, since excel & my Onedrive folders are Shared folder to production team? 1: Serial no 2: attachment Name 3: Attachment (PDF) contents 4: file Created time (email received time)
Anyone have a resource link to where I can save the attachment to multiple folders? Do the folders have to be created already? I have tried Copy File action, but my flow fails... help please and thanks!
Thank you for the video… The process works but it only copied one attachment in my folder… And it only works for the current date. Is there a way to have the flow grab all emails regardless of date? Can I grab dates going back a week or any time frame? Also the attachments all have the same file name… Will it save the file but just give it an incremental file name? Sorry for the many questions! Hope someone can point me in the right direction.
Hi, I do not believe with Microsoft Automate's current functionality you can go back and grab already delivered emails. To have the file name changed every time, be sure to use the "Dynamic Content" marker when indicating the "File Name" in the new file you are creating.
Hi Henry, I often scan hundreds of invoices as PDF files into Outlook at my work, and then I save the attachment onto a hard drive one by one. Some invoices come from the same vendor and differentiate them using the vendor name and invoice number. e.g., Apple 123 and Apple 245. How do I automatically extract attachments from an email and save them onto the hard drive (H:) without using any code? Please help me!!! Thanks,
Hi, you can use a conditional statement and select the "Ends With" option. There you can set it equal to if it ends with .xlsx, continue with the action!
Hi Henry , I tried applying the conditional statements and selecting the "ends with" option to save only CSV files from among multiple attachment's in email, unfortunately it's not working . Please advise.
Hi Henry! Thanks for the video, it really helped me. However, while i was able to open up excel attachments from gmail email accts, I wasn't able to open them from outlook accts. Instead, the error of excel being unable to open up the file due to invalid file extension/format was prompted. Would you know how to get by this?
When I try using a non dynamic name, the name, the resulting file has no file type - how can I rename and make sure it still sets file as an excel file
Hi, as of right now to my knowledge, I do not believe shared one drives can be accessed by Microsoft Flow. This is a problem that Microsoft is hopefully working on and will be available soon.
With Microsoft Flow specifically, from my knowledge I do not believe there is a way to do that right now because there needs to be some sort of triggered event for that to happen.
Hi Jim, you can set a different step up to delete the file with the name you want to "overwrite" and then recreate it with the date you received in the email. This is the same function as overwriting!
Very late reply ( 1 year ago, I know) but you can use a dynamic naming convention by adding a Compose File Name step, and the flow will save the new attachment with the same name each time but it will be with the updated data. I used a concatenation string called "Dynamic Data Source.csv". The "Apply to Each" step contains two subtask 1) compose dynamic name and 2) Create Dynamic Named File path
Try using the "Create File" function that is supplied by Sharepoint instead of OneDrive. Go in there and change the destination file to the one that you would like.
Hi Henry, i want to ask you, for example, right now u only make this 1 flow to one specific folder right? how about i want to make another 2 folder, means i have 3 folder for each attachment email? can i ask your personal email for i to ask you about this if you okay about it.
Hi Henry, i get the below error for Apply each(The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')' is of type 'Object'. The result must be a valid array)
Hey, Thanks for video! I have question here, I have email attachments with same subject line and its overwritten not creating new file, is there solution
I added the date in the filename in the flow before the file name (the date before the name because the name specify the extension at the end, xls, jpg, png, ...)
Hi, very usefull video and i have a question, is it possible with power automate to create a folder at the same time that it is creating a forder. I mean when i receive an e-mail with two attachments today, i would like to create a folder in my OneDrive with the name on the date and into that i would find my attachments files. Thank you in advance
Hi, Henry, thank you for such outstanding tutorial. I have one question. How to pick up a certain e-mail, attachement from which will drop to onedrive? I tried to specify one certain e-mail during the customisation of the flow, but it seems that files from different e-mails drop into my One drive "email attachement" folder.
If you create a rule in Outlook to find the exact type of e-mail that you want, you can then have the rule put those e-mails in a different folder and then specify the folder you created at 3:08 instead of just the Inbox
You can specify that in the rules of the flow, you can add rules like elements of the flow. I created a rule in outlook to move all the emails from a sender to a specific folder, and the rule in the flow was to save the attachements from that folder in outlook. That worked perfectly for me and I can modify the rules from outlook without making any change in the flow.
Hi Ethan, late reply, however you can write .csv or .xls if you concatenate the File Name. Also in the "File Content" box add Attachments Content. Attachments Content-Type (include the Dot) Hope this helps!
I do not believe you can currently do this with a template through Microsoft Automate. You can do it with specific people that you receive emails FROM but not you sending it to them. With some manual configuration, you could possibly create a "Manual Flow Trigger" button to do this with some inputs.
Hola Henry. quisiera saber si es posible aplicar un filtro en tu flujo ya que cuando me descarga los adjuntos me descarga tambien imagenes contenidas en la firma del contenido del correo. en mi caso solo requiero que me descargue los .zip que contiene cada correo
This is cool, but when would you ever want this? I prefer to search in Outlook because it comes with the context of the conversation, the date, the person who sent it, the words in the e-mail, the people who were cc'd... this just takes the attachment completely out of its context and makes it harder to find. We need a video of a flow where you can automatically save an attachment to its correct folder, like where it's actually supposed to end up.
![Use Power Automate to Protect Outlook Attachments 📧🔒 + [Organize Folder by Topic 📂]](http://i.ytimg.com/vi/YR9Ug_8FZGM/mqdefault.jpg)
I am not good at doing "new things" but I really LOVE they way this guy explain and shows things!
Amazing video! Super concise and easy to understand. Great balance of explaining what each steps mean. Thank you!
This makes understanding of how flow works so simple. Keep up the good work and thank you so much this saved me hours of testing. It worked first time with no issues.
Thank you! I was looking for a quick guide and would taylor it to my needs - but your video was exactly what I was trying to do.
Great pace to your videos, not lingering on anything for too long. Clear instructions and informative.
I have a question, Can you scan through your inbox for specific attachments, say a certain file you get sent each morning to move them to one drive, emails already in your inbox. Thanks in advance
Thank you for your compliments! If you know the name that the file will be when you receive it, you can scan for if the file name matches the one you want to receive, then move on to the next steps of delivering it automatically to your one drive.
@@henryouang Hi Henry, well done. To expand on the above follow-up question, the case may be one needs to only isolate the attachment by file type. This applies when, lets say the email has multiple file types, pdfs, word and one is only interested in the CSV for example. 2. It would be ideal to have a naming convention for the attachments such as time and date stamp. I can imagine depending on velocity; after 100's of attachments it would be a nightmare really. Any thoughts? Thanks
Very helpful, I have an Question does this save the mailbox size? since it is only 50GB an if yes, then I might not need to upgrade the License to E3
Thanks very much Henry, got asked this question at work this week. 🎉
Thank you, Henry, for this wonderful guide. I just tested it, and it worked very well for me. Can you give a guide on how to save attachment from specific email addresses to specific folders. Thank you
Keep doing this kind of videos Henry! you're amazing in automation
Thank you Nelson!
Mate, this is super helpful, and you explain everything so well. Huge thank you!
Hi. I have a question...In my case the banner and logo of our company are auto-saved in the same folder I created for flows since it is also considered as an attachment. Is there a way that we can set the company logo not to be saved when an email is from a colleague? Is there anyway we can set that?
You can use a "Condition" step where you can say "If the filename is equal to [your logo name], then do not save this file. Otherwise, continue on with saving the file to the onedrive." Let me know if you need additional clarification!
@@henryouang i'll check. also is it possible for a flow to be created if a new video or file is uploaded on a shared drive (maybe synched from computer ) for a notification to be sent to a different email address?
Hi Ubie could you do this? I have the same problem and the logo file is with diferent letters and a strange content...
@@henryouang i need more clarification
thanks Henry, after to many hours, i did can find the right explanation.
That's great to hear! Thank you!
Hi Henry, How can i do to receive only excel attachments ? not signs, emoticons, pictures into the email
thanks for the help, hugs straight from brazil
I have question @HenryOuang Its it possible to add link of that particular attachment in excel too. so that link can direct me to that one drive document.
That's great Thanks! this already helps alot, just wanted to check if you can do a video of how to update excel sheet from automated Email with attachment.
I get this daily report from System, and i just need to copy paste it into another sheet on my Local PC or Sharepoint doesn't really matter.
Hi Henry, I wonder how to remove such a flow (stop outlook attachment from being saved in OneDrive). I have tried under Connections to remove my email address. But it doesn't seem to stop those attachments from taking up OneDrive space though. Could you please guide me? Thank you
Thanks Henry. You aade it super simple to follow.
This video's is very helpfull me.. I appreciate nd glad for watching your video... make more video for example powerautomate
Hey Henry, thank you for the video. It would be great if you create another video on Sharepoint folders/files (move/copy) onedrive folder and delete from the sharepoint. It will benefit some of us New Users here. Thumbs up!
I will need to consider this for the future. Thank you!
This is great, i have one issue that the attachemts are unreadable onse saved to my onedrice. any ideas?
This worked perfectly. Thank-you!
No problem, thank you!
Hey Henry, is there a way to convert a large .xlsx file to a smaller .xlsb format prior to downloading? my files that come in daily are 50mb or greater and it doesn't appear that it will work on those sizes
Is there a way to download all attachments from previous emails, not just "When new email arrives" to save them to OneDrive or sharpoint document library?
This worked for me:
I created the flow and my rule was for emails in a specific folder (new folder without emails), then when the flow was working correctly I created a rule in outlook to move all the emails with those charateristics I want to the new folder, and executed the rule for all the emails, outlook moves the emails to the new folder and that's a trigger for the flow to run.
Thank you so so much, BUT i have a question: Can i override the attachment? like i want it to be deleted whenever theres a new attachment with the same title?
Hi SheSpecial 20, I’m just going to copy my comment to Jim beneath here. You can set a different step up to delete the file with the name you want to "overwrite" and then recreate it with the date you received in the email. This is the same function as overwriting!
@@henryouang Thank you for correcting me "overwrite" :)
Though i followed your steps, but i didn't receive the file yet. does the file type (xlsx)could be the reason?
@@beingme1607 Very late reply ( 8 months ago, I know) but you can use a dynamic naming convention by adding a , and the flow will save the new attachment with the same name but it will be with the updated data. I used a concatenation string can called my file "Dynamic Data Source.csv". My Apply to Each step contains two subtask 1) compose dynamic name and 2) Create Dynamic Named File path
Hi Henry, is it possible for flow to save automatically an attachment that always has a standard name ... Example of an attachment "Sales_12345" in this case the attachment has "Sales" name then in that case save the attachment in the sales folder?
Awesome Video! I wanted to find out how do you create a flow that extracts the attachment from email and sends it to a Network Drive?
Hey great video thank you! Can you please let me know how to get outlook emails with image to Devops as a work item ?
Hi Henry. This is exactly what I was looking for. Thanks! Can you also tell me how we can apply this flow to an existing folder with existing email with attachments in the same outlook location?
Good day,
How would you place all the attachments from each email into a sub-folder?
Thanks, Henry, what happens to the email attachment after it has been worked flowed to OnDrive. Does it still available in outlook inbox or it gets removed and only available in OneDrive.
Thanks,
Sassan
The attachment will be available in your outlook inbox nevertheless it was copied to onedrive by automated flow
Hi Henry, question
Can I track attachment/files into Excel as well, since excel & my Onedrive folders are Shared folder to production team?
1: Serial no
2: attachment Name
3: Attachment (PDF) contents
4: file Created time (email received time)
This works but it saves email signatures and rubbish pictures as well. Do you have a way to efficiently save the right attachments? I filtered out jpg
Anyone have a resource link to where I can save the attachment to multiple folders? Do the folders have to be created already? I have tried Copy File action, but my flow fails... help please and thanks!
How could I add the file date of the attachment to this flow?
Thank you for the video… The process works but it only copied one attachment in my folder… And it only works for the current date. Is there a way to have the flow grab all emails regardless of date? Can I grab dates going back a week or any time frame? Also the attachments all have the same file name… Will it save the file but just give it an incremental file name? Sorry for the many questions! Hope someone can point me in the right direction.
Hi, I do not believe with Microsoft Automate's current functionality you can go back and grab already delivered emails. To have the file name changed every time, be sure to use the "Dynamic Content" marker when indicating the "File Name" in the new file you are creating.
Can you sort the attachments into folders based on their name or the email address they are coming from?
Hi Henry,
I often scan hundreds of invoices as PDF files into Outlook at my work, and then I save the attachment onto a hard drive one by one. Some invoices come from the same vendor and differentiate them using the vendor name and invoice number. e.g., Apple 123 and Apple 245. How do I automatically extract attachments from an email and save them onto the hard drive (H:) without using any code?
Please help me!!!
Thanks,
Why do I have this "Email Attachment" folder in my One Drive if I have never done this? Is it something that is automatically done now?
Hi sir can i use microsoft flow to import excel files in sql data base?
Please make a video tutorial
Hi, you can do this but I will need to know a little more about the context you want before making an entire video tutorial. Thanks!
What if I only need certain type of attachments, like .XLSX or .DOCX?
Hi, you can use a conditional statement and select the "Ends With" option. There you can set it equal to if it ends with .xlsx, continue with the action!
Hi Henry ,
I tried applying the conditional statements and selecting the "ends with" option to save only CSV files from among multiple attachment's in email, unfortunately it's not working .
Please advise.
Hi Henry! Thanks for the video, it really helped me. However, while i was able to open up excel attachments from gmail email accts, I wasn't able to open them from outlook accts. Instead, the error of excel being unable to open up the file due to invalid file extension/format was prompted. Would you know how to get by this?
How do I find this app to download? MY IT guys don't even know about it. Thanks!
After creating the powerapp in make.powerapps.com, you can find PowerApps on the App Store or Google Play store!
Hi Henry. Nice video. Do you know how to rename a folder in onedrive using MS Flow? Could you help me?
Hi Mario, thank you! I do not believe I know of any functionality that will allow MS Flow to rename a folder's name at the moment. I apologize.
When I try using a non dynamic name, the name, the resulting file has no file type - how can I rename and make sure it still sets file as an excel file
Hi, Can I upload an attachment , that I received in my outlook to some other's onedive folder?
I do not believe you can upload files to shared one drives at the moment. Microsoft needs to implement this! I apologize.
Maybe if create the OneDrive conecction with the other's OneDrive
You are the man!
I would like to copy the attachment to a shared onedrive where I only have the link from my customer. Can this be done?
Hi, as of right now to my knowledge, I do not believe shared one drives can be accessed by Microsoft Flow. This is a problem that Microsoft is hopefully working on and will be available soon.
Clear tutorial! subbed!
Is there a way to include existing emails? not just new emails
With Microsoft Flow specifically, from my knowledge I do not believe there is a way to do that right now because there needs to be some sort of triggered event for that to happen.
how to add an extra step so per email with attachment goes creates a specific folder?
How do I copy a file and owerwrite it every time? I need to have the file name the same each time
Hi Jim, you can set a different step up to delete the file with the name you want to "overwrite" and then recreate it with the date you received in the email. This is the same function as overwriting!
Very late reply ( 1 year ago, I know) but you can use a dynamic naming convention by adding a Compose File Name step, and the flow will save the new attachment with the same name each time but it will be with the updated data. I used a concatenation string called "Dynamic Data Source.csv". The "Apply to Each" step contains two subtask 1) compose dynamic name and 2) Create Dynamic Named File path
Can Outlook email attachments from past years be automatically saved to OneDrive?
If I just want it to save XML files, there is any configuration that could help me?
What happens if you get attachments with the same name from different senders?
Hi I need your help with this.
for some reason, mine replaces the pictures rather than adding them, any reason why?
Could you please show how to save email attachment to a specific sharepoint folder name?
Try using the "Create File" function that is supplied by Sharepoint instead of OneDrive. Go in there and change the destination file to the one that you would like.
Hi Henry, i want to ask you, for example, right now u only make this 1 flow to one specific folder right? how about i want to make another 2 folder, means i have 3 folder for each attachment email?
can i ask your personal email for i to ask you about this if you okay about it.
Hi Henry, i get the below error for Apply each(The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')' is of type 'Object'. The result must be a valid array)
Hey, Thanks for video! I have question here, I have email attachments with same subject line and its overwritten not creating new file, is there solution
I added the date in the filename in the flow before the file name (the date before the name because the name specify the extension at the end, xls, jpg, png, ...)
I applied switch for different subject line. It only took default one
PDF Files uploaded to OneDrive are not working. Size of auto saved PDF files are less than 5KB, corrupted. How to fix this?
Thank you. Amazing tutorial.
Thank you so much for this video, it helped me a lot.
after downloading into onedrive will this disappear from email attachment ?
Thank you! Really helped!
Thank you!
does anybody know if this will work if I manually move the email to the folder?
i get 300 emails with attachments at a time, i need to save them to onedrive but only save 60, what's the problem?
And can you please make another vid for how to get a file from OneDrive to Power Bi?
Hi, very usefull video and i have a question, is it possible with power automate to create a folder at the same time that it is creating a forder.
I mean when i receive an e-mail with two attachments today, i would like to create a folder in my OneDrive with the name on the date and into that i would find my attachments files.
Thank you in advance
any luck?
Hi, Henry, thank you for such outstanding tutorial. I have one question. How to pick up a certain e-mail, attachement from which will drop to onedrive? I tried to specify one certain e-mail during the customisation of the flow, but it seems that files from different e-mails drop into my One drive "email attachement" folder.
If you create a rule in Outlook to find the exact type of e-mail that you want, you can then have the rule put those e-mails in a different folder and then specify the folder you created at 3:08 instead of just the Inbox
What about only saving from a specific sender???
You can specify that in the rules of the flow, you can add rules like elements of the flow. I created a rule in outlook to move all the emails from a sender to a specific folder, and the rule in the flow was to save the attachements from that folder in outlook. That worked perfectly for me and I can modify the rules from outlook without making any change in the flow.
Hi. What about if i receive an Excel file and want it to be saved as an excel file?
Hi Ethan, late reply, however you can write .csv or .xls if you concatenate the File Name. Also in the "File Content" box add Attachments Content. Attachments Content-Type (include the Dot) Hope this helps!
Any way to do this activity with sent items to specified people
I do not believe you can currently do this with a template through Microsoft Automate. You can do it with specific people that you receive emails FROM but not you sending it to them. With some manual configuration, you could possibly create a "Manual Flow Trigger" button to do this with some inputs.
Is there a way to have the emails automatically saved to the one drive
I think there is an option to save the body of the message in the file, in the flow options.
Wonderful content, could you please guide how to save as PDF
please share video for one drive and SharePoint for beginners
THank you so much!!!
No problem!
Hola Henry. quisiera saber si es posible aplicar un filtro en tu flujo ya que cuando me descarga los adjuntos me descarga tambien imagenes contenidas en la firma del contenido del correo. en mi caso solo requiero que me descargue los .zip que contiene cada correo
Thank you so much!!!!!
Thanks. it worked great
Thank you!
Good Work
Thanks you so much.. it is great..
This is cool, but when would you ever want this? I prefer to search in Outlook because it comes with the context of the conversation, the date, the person who sent it, the words in the e-mail, the people who were cc'd... this just takes the attachment completely out of its context and makes it harder to find. We need a video of a flow where you can automatically save an attachment to its correct folder, like where it's actually supposed to end up.
Thanks