AUTOMATICALLY Save Email Attachments 📎 Using Power Automate (create different folders by topic)

[@LeilaGharani]

Stay ahead with our weekly newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@toughslaut]

Leila!! Finally i got what i need. Previously i always try to search if there is any macro VBA can be used to automate this kind of task. And now finally I got it!! I need to learn more on this Power Automate!! Will save a lot of my time!! Thanks again for your sharing!!

[@boitumelospringbok]

Wow! This video came just in time. I have about 20 attachments that contain data in my inbox. I can't thank you enough Ms. Leila.

[@steventezcan689]

Leila, thank you so much for the videos! This Power Automate is amazing , please make more videos showing how we can utilize it with Office 365.

[@LeilaGharani]

Will do!

[@dcpowered]

Leila! I really appreciate these Power Automate videos the most!! These are the cutting edge tools and most requested in the office. Please make more!!

[@colgreg90]

hi Leila, great video. How can I add in a condition if the attachment name is the same everyday. Is there a way to overwrite the older file? Thank you

Leila, we have this done too, but your Flow has one fatal flaw, If someone sends file with the same name it overwrites the previous one. We solve it by creating Document Library with new unique file name from Date+Time+AttachmentNumber+RandomNumber and Orignal name is saved in custom text attribute. Also You can create Directory with Sender Name (Sharepoint Flow Action) and save file there - You won't need the Switch to do that.

[@DiptaGhossan]

i was actually gonna ask: will it replaces the first file with same name, or will the flow stop working? if its the 1st one, i am happy with it. can you confirm if thata the case?

@@DiptaGhossan it replaces first file.

[@DiptaGhossan]

do you know if the tutorial works as well for shared mailbox?

@@DiptaGhossan Yes, there is special trigger block for shared mailbox.

[@davidandres0571984]

Thanks!

[@christopherregalado3029]

Hi perhaps you've covered this in another video, but I cannot seem to figure this one out. The email received is also downloading the images within the email, but I only want to save the excel file. I understand this would be corrected in conditions, but just don't know how. If you have a video on this, I'd appreciate the link to it! Thank you.

[@YTBurner]

Hi. Have you figured this one out?

[@MoonPie44]

Add a condition on the attachment name to end with the file type you want to save

[@GO-7777]

THANK YOU!!!!!!!!!! I tried for hours before unsuccessfully, and you helped me with this tutorial to make it work!

[@freddyc1217]

Love your content, appreciate it. Is there a way you can save the attachments to a network share drive instead of SharePoint?

[@leecadman8000]

Hi Leila, Firstly thank you - you are my No 1 go to for all things excel, power Query and more!! Thank you. Can you help? Love this power Automate video, but how would you ensure you do not extract the email signature from the email. :)

[@saiskanda]

One important tip to add is - always rename your blocks. When your flow gets bigger, it gets quite confusing to select the right blocks metadata. Automate will just suffix a number so it gets confusing.

[@GenericAccountVLR]

Totally agree; I do this as well, and it’s very helpful.

[@LeilaGharani]

Thanks for the tip!

[@sculler43]

great content on this channel!! Clearly spoken , stays on topic and easy to follow. Nice Work !!!!

[@chh8860]

I have yet to graduate to Power Automate ... I am 'old-school' and am still wrestling with Power Manual. Maybe for the right scenario I will graduate ... someday. However, I have a client that does employ Power Automate. But on several occasions, he has called looking for a 'deliverable', assuming that it was late. It was not late. His 'automation' worked as intended, but he forgot that he created the 'process' and never checked his own folders. He was outsmarted by his own creation ... 😏... 😣 PS - but still marvel at Prof Leila's comprehension of the subject matter ... 👍👍

[@LeilaGharani]

Haha, that could be me. Creating "process improvements" and then spending more time looking for stuff and fixing mistakes 😂

[@ebenasare8661]

Hi Leila, Can i use similar to save on a desktop folder? many thanks

[@Lahmeinthehouse]

Place it on a drive and sync it to the desktop

[@SarahCrosby-h1g]

This was so easy to follow and I was able to accomplish what I needed before finishing the video! Thanks!!

[@phunguyengia9068]

Hi Leila, thank you so much for videos about Power Automate so far! They are all amazing! Pls make video tutorial of Vacation Tracker by which I may learn how to manage leaves of my staffs via Microsoft Teams (annual leave, sick leave, maternal leave, marriage leave, bereavement leave,... then how many days left). Thank you very much! Have a happy day!

[@Rizwan1875]

Kindly create more videos on power automate! Thanks!

[@willac4261]

Thanks a lot! I could finally configure my outlook inbox to download files automatically!

[@Grafii2198]

Ngl, I am not in business or any of these stuff but your videos are so entertaining anyway!

[@mattschoular8844]

Very interesting however there may be some significant security risks by auto downloading attachments that may have malicious content embedded. Nonetheless, this certainly presents another "out of the box" approach to redundant tasks. Thanks for sharing Lelia..

[@rfwells1]

That was my immediate concern. Would a save to a folder trigger anything? I’d love to try this.

[@Sancarn]

Downloading files isn't dangerous. It's only a risk if you run the file (or if another application runs the file). If these are custom business folders, that's not going to be a risk. If downloading those files kicks off other flows, that could be a risk though. Really it depends on the circumstance.

[@jaredwaterman5868]

though, its doubtful a malicious attacker trying to send an attachment would know the subject line needed in the trigger.. without XelPlus Project included, it shouldn't run the flow, creating a barrier for "auto downloading" which is more like saving a file rather than downloading...

[@bobbirowlett6728]

I really enjoyed this training video. Thank you so much for putting it together. This is my first exposure to Switch. Very cool.

[@LeilaGharani]

Glad you enjoyed it!

[@rwfrench66GenX]

Happy New Year’s Leila! May 2024 be filled with good health, appropriate respect and the satisfaction your desires motivated you to achieve! Thanks for all you do and all you are!

[@LeilaGharani]

Thank you for your kind wishes! I hope 2024 is wonderful for you too. Your support is greatly appreciated.

[@fidgetshouse]

Can you do a video for existing email attachments? PS: I love your videos. The PowerPoint tricks I have learned from you make my college lectures more dynamic!

[@GodWillIncreaseNitzborn]

Yes, please, We I need to have existing emails also actioned...

[@zzota]

I like to add the date and time the email was received as a prefix to the attachment name. If you get 2 attachments with the same name, they don't overwrite the previous.

[@csabaoszkar]

I think this is possible by adding the "received time" dynamic content to the file name during the file creation, e.g. RECEIVED TIME - ATTACHMENT CONTENT. I think the "attachment content" dynamic content needs to be the last one in the row, as that determines the final file extension - still testing this.

[@waqaryounis9861]

@LeilaGharani I have been following your guide on how to use Excel and now I start my new Job tomorrow and will put it all in use. #MAHARANILEILAGHARANI #MAHARANI.

[@wayneedmondson1065]

Great one Leila! Thanks for demonstrating. Thumbs up!!

[@LeilaGharani]

Thank you! Cheers!

[@tomdoe1234]

I've been doing this for a few years. I save all attachments to OneDrive. I only do this because I can use bing to search those files. If you are logged into Office 365 then you will see an option at the top of the search result page called "Work" or "School". It's right in the same row of filters All/Web/Images/News etc. It filters the search to your files, notes, teams conversations in your office 365 account. It's fantastic, I don't know why Microsoft doesn't promote this more.

[@MoonPie44]

Love this! My manager. Thank you for sharing 😃

[@valkyr989]

Thank you for this Leila. I have been using this since 2 years now and have found this very useful. I did not know about the Switch/Case. How do you filter out images found in signatures though? I have found the flow saves all images and small useless files as well?

[@SttConsultores]

Hi there, I have the same problem, did you find out how to disregard images in the signatures?

[@valkyr989]

@@SttConsultores No I have not. I did a filter to get rid of jpgs and pngs or any image starting with the name logo. It works but there are files which get through. I am sure there is a more elegant solution built in. It seems office365 users have more options compared to home users.

[@chrism9037]

So cool! Thanks Leila, this is awesome.

[@LeilaGharani]

Glad you like it!

[@matthewlogan3374]

Thanks for the video. Really appreciate the detailed video. Can you please provide some more information on how to add more steps to only include attachments that are .pdf? The flow is pulling in all attachments for me including in the body of the email (i.e. .jpg etc)

[@MrBenedict.]

have you found a solution yet?

[@qvidaify]

@@MrBenedict. Hello, you have to add before Condition and in condition write Attachmant.name contains PDF. I try the same with .xml and it work. :)

[@premgandhi5135]

Thank you, exactly what I was looking for ​@@qvidaify

[@RosanneSchoech]

hello thanks for the info really helpful. Just wondering how i filter out "Images" as i only want to save PDF and XLS attachments?

[@Migatwin]

Merci Leila ! Très intéressant !

[@toml7682]

Awesome this is exactly i would like to setup. thank you for sharing.

[@SiriyakornChaimueangmun]

Such a good video! How do you move the emails to sub folders once the flow is complete?

[@urbaneplanner]

This could be useful for shared projects - wonder if there’s a way to have the download occur to one’s desktop?

[@Odonnels]

Hi Leila, thank you so much for your videos, they are precious. Regarding this video i have a "problem" that you might can help to solve. The power automate is saving images from the body of the email on sharepoint but i just want the excel that comes as attachment. Is there any way to specify the type of the file to be save (xlsx)?

[@vida1719]

It's great when the system can work for us while we are on holidays. Great explanation as always.

[@LeilaGharani]

Glad you enjoyed it!

[@republikadugave420]

in a perfect world this would be awsome

[@diegofigueroa3831]

Leila! Thanks for the tips. There're very helpfull. I'm wondering if you would know how to just import to onedrive or sharepoint (whatever) some type of attachments as xlsx, xls or csv files. Normally in mailing there´re many other stuffs like signature of the mail, and it imports too, but I dont want this in my folder ¿How can I fix it? Thanks again!

[@jaredwaterman5868]

Hi Leila, I have no issue setting this up, the the "apply to each" is creating an issue, noting I don't want all the jpg, png, and thumbnail images that are converted to attachments because they are associated with a sender's signature line. My flow as you demonstrate is saving 4 unnecessary files, and 1 needed document. Is there a way to parse out the unneeded file attachments from sig line or to and identify and save the attachment of interest? Thanks

[@tr3der]

I’m having same issue

[@rickystables1798]

I have used power automate for my Gmail attachments and this works great! however can I stop it downloading the pictures within emails ??

[@ramvellanki1157]

Hi Ricky My question is also same have you got any solution?

[@tylerhorton3515]

Great video!! Once this flow runs, how do I get the flow to delete the email?

[@Riskninjaz]

Super awesome. Thank you. Need to be able to add prefix to the file to indicate the sender?!

[@AuthorJoshwaMoksh]

I'm glad I found you ☺️

[@AnupamGupta-wq8ov]

Great Video ! Can you save the attachments to shared drive (having confidential information) and not the onedrive or sharepoint

[@tommalschaert8482]

Wedding photos emailed as attachements get saved to a shared folder which gets shown on projector screen. Live photo sharing! At least thats what i'm trying to accomplish! sendtodropbox is not working properly anymore, only emails from hotmail arrive to it.

[@hhbadarin]

Fantastic tutorial as always! my questions is what if I want Power Automate to create the subfolder and rename it with the sender's name, then save all the files from this sender in their related folder!?

[@samirsamite]

Super usefull video. Please do more videos about Power Automate

[@adrienleflem2476]

Thanks! Very useful! Is there any way not to save the signatures?

[@naquin316]

Thank you for this! Love your content. What if the attachments have the same file name? Could you modify the flow to save the new file but with a new name?

[@SttConsultores]

Hey, under *file name, you can type the name you wish and as dynamic content I added the received time instead of attachment name and the extension of the file ReportX_receivedtime.xlsx, hope it works

[@omidkamrad9463]

I tried to give the file a static name (e.g. BAU.xlsx) for Power BI use, but it does not work. The file size is always 1KB and it says that the file format or file extension is not valid. Any idea how to solve this?

[@SttConsultores]

@@omidkamrad9463 that happened to me when the mail has images in the signature or in the body of the mail, you gotta add a filter for those files.

[@omidkamrad9463]

@@SttConsultores Thank you, yes definitly that was the main reason. as you suggested, I applied contains xlsx condition on my attachments name but it still does not work. :(

[@gabrielbarkin9806]

This was just what I needed! I augmented by adding a Compose Step with date to use in file name: formatDateTime(utcNow(),'yyyy-MM-dd') Then I used date in file name, but I had to put it AFTER file name and BEFORE extension. For me this was easy because my emails are automated with the name of the file as the subject line (these are automated backup files sent from Dynamics CRM using Click2Export plugin), so I named file = Subject Outputs.xlsx Other paople may need to use a COMPOSE to replace .xlsx or other file suffix with date and .xlsx in file name, that should work too.

[@krimbos1]

I receive order files in Excel format 2x per day. Can this flow be used to save the updated sheet to file as Current Order File, ie, overwrite with current sheet?

[@samaruti9446]

Leila, Great video and it has really helped me start to understand Power Automate. The one condition that I find I need but not able to do is when there is no attachment and I want to save just the message. Any thoughts on how to make this work? Thanks

[@ReactionSquad158]

I salute you for your hard-working.

[@Dany-ns6hg]

Thanks Leila for sharing this video, This one is useful but can we create folder, if not created already basis Month (when email arrived) and text in subject line and then save attachments. I don't know whether this would be feasible in Power automate.

[@soemoeaung6847]

Really amazing, Simple and easy to follow how to do. Thank very much. But I would like to know it can be restricted file type to save in SharePoint.

[@itworldofnaki9547]

Great video, Thank you Leila! Now I understand how to use Flow functionnality 🙂

[@sheikdhawood2377]

Leila such a wonderful video

[@aman_mashetty5185]

You're darling, by this video you saved my lot of time all thanks to you I learned lot from you.. one of the best thing I made is following you..😍😍

[@LeilaGharani]

Glad I could help!

[@amittk288]

Perfect! Just what I wanted!

[@SamsungA-wv5bh]

Thanks a lot for the video. Can we automate the same for Gmail as well?

[@GodWillIncreaseNitzborn]

Hi Leila, this is so helpful thanks! I setup an email to save attachment from outside vendor. How can I test if that was correct? Next run is only tomorrow morning, but I hope to test if the automate worked to save the attachment...

[@laurastacy987]

@leilagharani This video is excellent. I am getting an error when a duplicate is received. Is there anyway to add something to the file name to keep the flow from failing on duplicates?

[@lixie463]

Hi Leila, how can you change the name of the attachment file as I'm getting multiple emails with the same file name? Thanks

[@anuriak]

Thank you so much❤❤❤❤ this was amazing.

[@muhammadshahrukhjan4494]

Leila you are great 👍

[@RK-of9on]

Hi Leila, Great content, i have a use case, is there a way to automate download? of an excel file from a hyperlink, in the body of an email, which I receive from my provider daily and save it to SharePoint folder.?

[@rwilson101]

Thanks for this awesome and very useful video.

[@ricardomajor4189]

Hi, thanks for your awesome videos! I scheduled some reports to be sent as email attachment, would it be possible to automate not only the download but also rename it and replace existing file in specific folder?

[@mehappym]

Hello Leila, Really appreciate your videos , I have learnt a lot of things from your videos. I have a question. Is it possible to download attachment to local or shared hard drive using power automate ? Thank you Anand.

[@nbrt164]

I'm not a Power Automate expert, but it seems like you could create a similar flow but instead of an Automated Cloud Flow, you could do an Instant Cloud Flow, and then just trigger it once.

[@sanjeevibokkisam6644]

@@nbrt164 , if you have any vedios or SOP related to these can you please share the content, I need these very badly, I am saving more than 100 documents in a day in our local group folder or in desktop.

[@sizomale1605]

This is great, clearly put and easy to follow.

[@brolly414]

Thank you, Leila!

[@mita4055]

Hi best instructor, please a course about power apps, we need it! Thanks a lot

[@addemkoozie]

thanks Leila - I've been wanting to do this forever!. but I get emails which have the sender's logo as an attachement and I only want to the pdf to be saved. Is there away to filter for pdf only?

[@carlycarlyle]

Awesome video. My Power Automate looks a bit different. Is it possible if the attachment is a hyperlink?

[@wethepeoplesm]

@Leila Is there any way to have power automate post the attachment into a chat channel? Or can you only have it save the attachment into a sharepoint folder?

[@alimir2561]

Thanks for this video Leila ☺

[@jm77_josemanuel]

Love your videos. So much to learn. Always interesting stuff.

[@blackmarket7021]

Hi leila, could you create the folder. if you want to save folder base on subject or body email, could be it? Please respond my question... 🙏

[@square242]

It works ! Great ! Thank you !

[@LeilaGharani]

You're welcome! :)

[@mush543]

can we create dynamic folders? like the date the attachment received should be the name of the folder and the attachment should be saved in that

[@gabrielzabala87]

Dis you solve it? I'm struggling trying to solve this. Like it would be ideal if I could save an attachment of march in the march folder and an attachment from April on the april folder

[@mush543]

@@gabrielzabala87 No I didn't find a way

[@azferahseng3411]

I did this by using the subject of the email as the folder name. Also a row in excel in the sharepoint folder is added to register the new folder. In the excel, column called Email subject will register the folder name in addition a column with date/time stamp and a column to identify there is any attachment or not. Power Automate is a powerful stuff.

[@hemvaidya]

very very useful ...thanks so much

[@shxttynails]

Instead of rebuilding that Sharepoint action for each switch, you can copy and paste the earlier instance. In the first instance, click the three dot menu and copy to clipboard, then, in the switch, click My Clipboard when creating the new action. Edit as needed.

[@laubena1454]

Is it possible to, following your example, download only one of the attachments received? And to download the attachments in a desktop folder instead of SharePoint? Great video btw helped a lot!

[@rofreemail3921]

@Leila Gharani great video question will you have a training class on your website.

[@TheMohitosh007]

They thanks a lot! Can this be done on previous Emails as well or this is only for new incoming emails?

[@SttConsultores]

Thanks for this great video, it will be really helpful to my, just a question, is it possible to rename the file before saving? Thanks again!

[@tr3der]

Thanks and great video Leila. The automation, though, is creating attachments which do not have a preview and keep getting message "attachment cannot be opened" (these are pdfs). Any thoughts of what I am doing wrong?

[@Pesetas7400]

Thank you for the video, I have an issue where the flow downloads images that are in the mail as well, say the company logo from the signature. Is this seen by someone else, and has a way to solved this?

[@silversurfertraveller]

Is it possible to use the cloud Power Automate to download attachments that are from an IMAP email server?

[@VineshParekh]

Hi, is there an option to create a folder in Google Drive based on the email subject and keep the attachments received in the email in the same folder?

[@samuellecris]

Hi Leila, how to do this if I wanted to include the sub-folders too? Thanks!

[@iandavies2868]

This is great and really helped get me started, but it saves every attachment in the email including any images. I;d like ot to ONLY save the CSV file with the data I need, is here a way to do that? Ive tried to use the Filter Array, but its made no difference, I suspect the follow up steps are using the wrong dynamic content, but don't know enough to work out what i need to use.

[@zainshah8644]

Very informative video

[@Suresh-xh2yh]

This is cool and working like magic...Can we improve here... I'm using a keyword from the email subject. let's say " welcome" and by using your methods it saves my attachments under the " welcome " folder. how I can create a flow to create a folder automatically again when the email comes with " welcome 2 " and save the it's attachment?

[@jaggyjut]

Superb. Would you be able to create a tutorial on multi step invoice approval. Once all the parties have approved save the invoice with attachment to a sharepoint list. Thank you again. 😀

[@dalibelsantiago2116]

Wow! Thank you!