Save Email Attachments to SharePoint with Microsoft Power Automate
HTML-код
- Опубликовано: 11 сен 2024
- Stop wasting your time manually downloading attachments from Outlook and uploading them to SharePoint. Automate that shit!
Power Automate doesn’t have a download attachment from outlook action. In this Power Automate Video tutorial, I’ll show you how to use the Get Attachment (V2) action in combination with the Create File action to get your email attachments onto SharePoint. The Create File action will overwrite any files that already exist with the same name. In this tutorial, I’ll show you how you can append a timestamp to the end of a file name to prevent your file from being overwritten.
I’ll also show you how to set up your flow so that you can trigger it manually while building it so you don’t need to wait for an email to arrive. At the end of the video I’ll show you how adding trigger conditions to your flow can prevent it from triggering if certain conditions aren’t met.
Although the final flow uses the When a new email arrives in a shared mailbox (V2) trigger, you can use any of the When a new email arrives triggers for your flow. Adjust this flow to suit your needs!
IN THIS VIDEO:
✅ How to Automate Downloading and Uploading Email Attachments to SharePoint
✅ How to Use a the Get Email (V2) action
✅ How to Use the Get Attachment (V2) action
✅ How to Create Attachment Files using the Create File Action
✅ How to Prevent the Create File Action from Overwriting a File
✅ How to use Split the Filename from its Extension
✅ How to Append a Timestamp to a File Name
✅ How to use the When a New Email Arrives in a Shared Mailbox (V2) trigger.
✅ How to use the Convert Time Zone action
✅ How to add Trigger Conditions to your Flow
---
SKIP AHEAD:
00:18 | Upcoming Video Preview
00:30 | Build the Flow
01:28 | Replace the Automated Trigger
2:40 | Get the Attachments
03:23 | Create the Attachment Files
05:11 | Check if the File Exists
10:09 | Replace the Trigger
12:00 | Helpful Insights
12:11 | Convert Time Zone
13:20 | Trigger Conditions
#microsoft365 #powerautomate #powerplatform #productivityhacks #productivitytips #sharepoint #microsoftoutlook #outlook #emailmanagement
SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH
👉 bit.ly/SubACre... 👈
---
Teaching you how to make your workflows SUCK LESS.
Subscribe if you want to learn how to streamline your workflow, boost your productivity, and build innovative processes for yourself and your business! I wanna help you get more time in back your day.
Join me on my journey on learning new tools, levelling up my skills and creating more time to do the things that matter. I hope that I can inspire you to do the same and share all the things you learn from me with others.
Get curious. Be creative. Do better.
---
FOLLOW ME:
/ acreativeopinion
/ acreativeopinion
/ acreativeop
How much time would you save in your day if you could automatically upload certain email attachments directly to SharePoint? Let me know down below!👇👇👇
thanks a lot.. this is easy to learn and you quick with the steps i totally love it..
Thank you! This was IMMENSELY helpful. Did you ever create that follow up video to show how to use a SP List to dynamically change the folder the attachments are created in?
Very simple, thank you!
Great video! Would be possible to show how to save the email too?
i've followed the steps but when the file is created in the shrepoint it does not have the excell format and i can't open the file any ideas?
Can I use this automation and create this flow in my user, but run in an email box from another user?
Hello, I have made a similar flow to save .xlsx files into SharePoint. But after saving I see the files have been corrupted.
As of 8/2024, something has changed. My flow will run, but the steps within apply to each for getting attachment and creating file are backlit and do not initiate during the flow, so attachment is not saved as a file.
thank you so much
Did you ever create the video you described at the beginning for automating emails into Sharepoint folders? Thats exactly what I'm looking for.
same tried following along but got totally lost
Thanks for watching! I haven't gotten to that video yet. Will let you know when I do!
Great Video. Is it possible to only save attachments from emails with a specific date, for example to save attachments on Monday from an email from Friday by addressing the receiving date of an email?
Thanks for watching. Because the Get Emails (V3) action doesn't include a way to filter the emails by date you will need to use a Filter Array action to filter emails by a specific date. However, I believe there is a limit of 25 emails that are returned from the Get Emails action. Not sure if you can adjust this or not.
For more information on how to use the Filter Array action check out this tutorial: ruclips.net/video/HVAf1aTEQNg/видео.html
I would like to do this same process but for Lists instead of a Library. The challenge I'm facing now is how to create the list item to include the attachment. The Create Item doesn't include a property to add the attachment contents (only Create File does)
Thanks for watching!
Check out this YT Tutorial - How to Add Microsoft Form File Uploads to a SharePoint List Item: ruclips.net/video/l9cK1HhbN3o/видео.html
Although I cover how to get Form File Uploads to a SP List item, the concepts covered in this tutorial can be applied to your flow.
Hi, why does my attachments are blank?
Not working with emails auto forwarded to the shared mail box