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

[@MoonPie44]

Love this! My manager. Thank you for sharing 😃

[@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!

[@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.

[@SarahCrosby-h1g]

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

[@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!!

[@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!!

[@GO-7777]

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

[@Rizwan1875]

Kindly create more videos on power automate! Thanks!

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.

[@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.

[@willac4261]

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

[@freddyc1217]

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

[@republikadugave420]

in a perfect world this would be awsome

[@sculler43]

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

[@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. :)

[@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!

[@chrism9037]

So cool! Thanks Leila, this is awesome.

[@LeilaGharani]

Glad you like it!

[@ReactionSquad158]

I salute you for your hard-working.

[@wayneedmondson1065]

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

[@LeilaGharani]

Thank you! Cheers!

[@Grafii2198]

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

[@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!

[@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...

[@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!

[@square242]

It works ! Great ! Thank you !

[@LeilaGharani]

You're welcome! :)

[@itworldofnaki9547]

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

[@sizomale1605]

This is great, clearly put and easy to follow.

[@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!

[@brolly414]

Thank you, Leila!

[@Migatwin]

Merci Leila ! Très intéressant !

[@samirsamite]

Super usefull video. Please do more videos about Power Automate

[@Bookish_Haven]

I'm glad I found you ☺️

[@amittk288]

Perfect! Just what I wanted!

[@jm77_josemanuel]

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

[@anuriak]

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

[@alimir2561]

Thanks for this video Leila ☺

[@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.

[@rwilson101]

Thanks for this awesome and very useful video.

[@davidandres0571984]

Thanks!

[@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.

[@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!

[@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 😂

[@a55town]

Great video. Simple and to the point!

[@sheikdhawood2377]

Leila such a wonderful video

[@SiriyakornChaimueangmun]

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

[@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.

[@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...

[@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.

[@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

[@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

[@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

[@hemvaidya]

very very useful ...thanks so much

[@ridamID]

thanks Leila

[@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. :)

[@mita4055]

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

[@muhammadshahrukhjan4494]

Leila you are great 👍

[@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

[@dalibelsantiago2116]

Wow! Thank you!

[@pedromartins36]

Very well done!

[@urbaneplanner]

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

[@zainshah8644]

Very informative video

[@arijitsaha7791]

I can feel future automation

[@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.

[@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?

[@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.

[@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!

[@ebenasare8661]

How I have been waiting for this

[@MrShadyabs]

Nice thank you

[@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!

[@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!?

[@Riskninjaz]

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

[@tylerhorton3515]

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

[@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?

[@alvarorodriguezlasso]

Awesome, ¡you are the best!

[@jackmarrian7928]

This is fantastic thank you. Would love to know how to add Unzip attachments to the flow aswell

[@zchesiq]

Thank you!!!!!! ❤

[@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)?

[@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. :(

[@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...

[@SamsungA-wv5bh]

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

[@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.

[@carlycarlyle]

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

[@rajeshkharat206]

Could you make a video on how to attach an excel file to a recurring email in Power Automate?

[@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.

[@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?

[@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. 😀

[@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.

[@leandrolubochinerdg]

Everyone talks about email attachments but not the whole email, is there a way to do that? Thank you for all of your amazing work!

[@jayaramb2343]

Can you do a video for existing email attachments?

[@manishagrawal417]

Finally..you started something on power automate. Eagerly waiting for a full fledged course to master it...but for now i am struggling with one thing, may be you can help. In one of my flows the from field does not take an external shared mail box id that is from another company but it takes inividual ids from that company. How can i fix this?

[@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.

[@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

[@jajis]

Good and thanks, can you please let me know how to add senders name or email

[@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.?

[@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... 🙏

[@andrewashdown3541]

Pls remind me how you can access your screensaves - many thanks

[@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?

[@gosiawalkow6752]

Hello. Totally useful video, But I have one question, if I receive a file with the same name from several people it doesn't save as another item but overwrites itself. How i can solve this problem :)

[@johnbutler2750]

Been using vba to achieve something like this (save invoices in folder of supplier, for each month). Still this looks interesting and potentially easier.