AUTOMATICALLY Save Email Attachments 📎 Using Power Automate (create different folders by topic)
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
How about saving specific email attachments the moment they enter your Outlook inbox? You can save it on SharePoint so your team gets immediate access to the attachments. They don't have to wait for you to save the attachments. All it takes is 5 minutes to set up a flow in Microsoft Power Automate. You can specify to save only attachments from specific senders or add a filter for certain subjects. You can save the files to a folder, OneDrive or SharePoint. We'll even add a condition to save attachments from a specific sender to a separate folder.
🌍 My Online Excel Courses ► www.xelplus.com/courses/
🌟 Key Learning Points:
- Setting Up Power Automate: Learn the basics of setting up an automated cloud flow in Power Automate, accessible via office.com.
- Email Trigger for Flow: Discover how to create a flow triggered by incoming emails, scanning for specific criteria like subject lines or sender.
- Saving Attachments Automatically: Understand the process of automatically saving email attachments to a SharePoint drive or other specified locations.
- Customizing Flow Conditions: Explore options to customize your flow, such as saving attachments only from emails marked with high importance or with specific subjects.
- Creating Subfolders Based on Sender: Learn how to further organize your saved attachments by creating subfolders in SharePoint based on the email sender.
- Testing Your Flow: Get insights into testing your flow to ensure it runs correctly and saves files as intended.
🚀 Practical Applications:
- Keep your email attachments organized without manual intervention.
- Ensure important project files are saved instantly and securely.
- Customize your email attachment saving process to suit your specific project needs.
00:00 How to Automatically Save Email Attachments to a Folder
00:44 How to Create an Automated Cloud Flow
05:16 How to Test the Flow
06:22 Add Check to Create Subfolders Depending on Sender
11:00 Wrap Up
🎬 LINKS to related videos:
- Power Automate for Beginners: • Learn to Use Power Aut...
- Power Automate in Excel: • Streamline Excel: Powe...
- Power Automate Desktop: • Web Scraping Made EASY...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#powerautomate
Пікірлер: 291
Stay ahead with our weekly newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
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!!
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.
great content on this channel!! Clearly spoken , stays on topic and easy to follow. Nice Work !!!!
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!!
This is great, clearly put and easy to follow.
THANK YOU!!!!!!!!!! I tried for hours before unsuccessfully, and you helped me with this tutorial to make it work!
Love your videos. So much to learn. Always interesting stuff.
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
2 жыл бұрын
Will do!
Great video. Simple and to the point!
Great video, Thank you Leila! Now I understand how to use Flow functionnality 🙂
Great one Leila! Thanks for demonstrating. Thumbs up!!
@LeilaGharani
2 жыл бұрын
Thank you! Cheers!
It's great when the system can work for us while we are on holidays. Great explanation as always.
@LeilaGharani
2 жыл бұрын
Glad you enjoyed it!
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!
Merci Leila ! Très intéressant !
Perfect! Just what I wanted!
I salute you for your hard-working.
I really enjoyed this training video. Thank you so much for putting it together. This is my first exposure to Switch. Very cool.
@LeilaGharani
8 ай бұрын
Glad you enjoyed it!
So cool! Thanks Leila, this is awesome.
@LeilaGharani
2 жыл бұрын
Glad you like it!
Thanks a lot! I could finally configure my outlook inbox to download files automatically!
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
6 ай бұрын
Thank you for your kind wishes! I hope 2024 is wonderful for you too. Your support is greatly appreciated.
Kindly create more videos on power automate! Thanks!
Very well done!
Thanks for this awesome and very useful video.
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
6 ай бұрын
Yes, please, We I need to have existing emails also actioned...
in a perfect world this would be awsome
Thank you so much❤❤❤❤ this was amazing.
Love your content, appreciate it. Is there a way you can save the attachments to a network share drive instead of SharePoint?
Ngl, I am not in business or any of these stuff but your videos are so entertaining anyway!
Thank you, Leila!
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
2 жыл бұрын
Totally agree; I do this as well, and it’s very helpful.
@LeilaGharani
2 жыл бұрын
Thanks for the tip!
very very useful ...thanks so much
I'm glad I found you ☺️
Wow! Thank you!
Thanks for this video Leila ☺
Leila such a wonderful video
Super usefull video. Please do more videos about Power Automate
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. :)
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.
Very informative video
Awesome, ¡you are the best!
Leila you are great 👍
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
2 ай бұрын
Hi. Have you figured this one out?
Thank you!!!!!! ❤
Thanks!
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
2 жыл бұрын
Glad I could help!
It works ! Great ! Thank you !
@LeilaGharani
16 күн бұрын
You're welcome! :)
Nice thank you
This is fantastic thank you. Would love to know how to add Unzip attachments to the flow aswell
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
2 жыл бұрын
Haha, that could be me. Creating "process improvements" and then spending more time looking for stuff and fixing mistakes 😂
Super awesome. Thank you. Need to be able to add prefix to the file to indicate the sender?!
How I have been waiting for this
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
11 ай бұрын
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?
11 ай бұрын
@@DiptaGhossan it replaces first file.
@DiptaGhossan
11 ай бұрын
do you know if the tutorial works as well for shared mailbox?
11 ай бұрын
@@DiptaGhossan Yes, there is special trigger block for shared mailbox.
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
2 жыл бұрын
That was my immediate concern. Would a save to a folder trigger anything? I’d love to try this.
@Sancarn
2 жыл бұрын
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
6 ай бұрын
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...
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.
Hi Leila, This is great! Do you have a video to save a file from a hyperlink (location in network drive instead of attachment) in an email? Thanks!
Hi best instructor, please a course about power apps, we need it! Thanks a lot
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. 😀
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
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.
thanks Leila
This could be useful for shared projects - wonder if there’s a way to have the download occur to one’s desktop?
Thanks! Very useful! Is there any way not to save the signatures?
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.
hello thanks for the info really helpful. Just wondering how i filter out "Images" as i only want to save PDF and XLS attachments?
Thanks a lot for the video. Can we automate the same for Gmail as well?
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)?
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
2 жыл бұрын
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.
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?
Been using vba to achieve something like this (save invoices in folder of supplier, for each month). Still this looks interesting and potentially easier.
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!
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. :)
Nice! Can you use this method to save attachments to a Microsoft List (create a new entry with the attachment) and than create a flow to confirm it using Approvals?
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!?
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!
Thanks for the Informative video. Can we automate extraction of password from mail and open the attachment
They thanks a lot! Can this be done on previous Emails as well or this is only for new incoming emails?
I can feel future automation
Lelia, thanks for your video, can teach me how to save email attachments with specific name? Thank you.
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.
That's powerfull! What are the licensing requirements to use this feature? Thanks!
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.
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?
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
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...
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. :(
@Leila Gharani great video question will you have a training class on your website.
🔥🔥🔥💯
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
@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.
Hi Leila. Do you have a video on how to reply to all with original attachments? Better still, with a keyboard shortcut! :)
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
2 жыл бұрын
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.
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!
I have used power automate for my Gmail attachments and this works great! however can I stop it downloading the pictures within emails ??
@ramvellanki1157
9 ай бұрын
Hi Ricky My question is also same have you got any solution?
Do you have to set up a new flow per project? For example, whenever an email with an attachment is received, relating to Project X, it is saved in a designated SharePoint folder... and so on. Or can you specify multiple project names in the Subject Filter (separated by a comma, maybe)?
*Hello there, Leila Arjun.* *I hope everything is going well with you. Your films are usually useful and entertaining. MVP Leila Gharani (It's You Definitely)* *taught me more about Microsoft Office Excel.* *I'd want you to make a video on Microsoft Power Automate and how to automate a work that involves special type of searching* *from Google and filling that information in a website database type of form.* *How do you solve the problem when the destination of certain information from a website changes? Using Power Automate*
Leila thank you so much, I have a question, any idea how we can display in outlook office 365 entreprises the old items without clicking on link below screen ?? And even in the search it's the problem
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.?
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?
Thanks, this si a great way to save the atachement files un orden to don't lose information and keep them into folder. Very Intersting. just I have a question... This solución works only with Outlook or there is a way yo apply it with Google suite? Best regards from México
@MrBradleykeith
2 жыл бұрын
@ 0:56 of the video the very first steps of PA gives you the option to use gmail, outlook etc