Power Automate / Flow - Save Automatically an attachment Tutorial

In this video, you will learn how to save attachments automatically using Power Automate.
The video demonstrates the process of creating a flow from scratch and connecting Power Automate to Office Outlook.
The flow is triggered every time a new email arrives, and Power Automate checks for attachments and filters emails with the word "certification" in the subject.
The attachments are then saved in a designated folder in OneDrive for Business, with the file name being the same as the attachment.
This tutorial will help you automate the process of saving attachments, saving you time and effort.

  • 4:32
  • 3860 views

Objectifs :

This tutorial aims to guide users through the process of creating an automated flow in Power Automate from scratch, specifically focusing on how to manage email attachments efficiently.


Chapitres :

  1. Introduction to Power Automate
    In this tutorial, we will explore how to create a flow from scratch using Power Automate. The goal is to automate the process of collecting email attachments, specifically certifications related to a webinar, without manual intervention.
  2. Creating Your First Flow
    To begin, navigate to the home page of Power Automate and click on 'Create' to start building your first flow. For this example, we will set up a flow that checks for incoming emails containing attachments.
  3. Setting Up the Trigger
    We will create an automated cloud flow that is triggered by a specific event. Click on 'Skip' to access a blank canvas. The first step is to connect Power Automate to Office Outlook. The trigger for our flow will be 'When a new mail arrives'.
  4. Filtering Emails
    To refine the flow, we can use advanced options to instruct Power Automate to only look for emails with attachments. Additionally, we will filter emails that contain the word 'certification' in the subject line. This ensures that only relevant emails are processed.
  5. Connecting to OneDrive
    Next, we want Power Automate to save the attachments to OneDrive. Be cautious to select 'OneDrive for Business' rather than your personal OneDrive. We will set the flow to create a file in a designated folder, specifically in the 'email attachments from Power Automate' folder.
  6. Naming the Files
    Instead of manually naming each file, we will utilize dynamic content to name the files based on the attachment names. This is crucial since we expect to receive around 100 certifications.
  7. Copying Attachment Content
    We will also use dynamic content to instruct Power Automate to copy and paste the content of the email attachments into the corresponding files in OneDrive.
  8. Saving and Testing the Flow
    After setting up the flow, click on 'Save'. It is important to use the flow checker to identify any errors or warnings. You can test the flow manually or automatically to ensure it functions as intended.
  9. Managing Your Flow
    If you no longer need the flow, you can access it through the 'My Flows' button. Use the 'Edit' button to modify the flow, change the destination folder, or adjust the subject filter. To deactivate the flow, simply use the ellipsis and select 'Turn off'. Once turned off, the flow will cease to run.

FAQ :

What is Power Automate used for?

Power Automate is used to create automated workflows that connect different applications and services, allowing users to automate repetitive tasks and improve efficiency.

How do I create a flow in Power Automate?

To create a flow in Power Automate, go to the home page, click on 'Create', choose the type of flow you want, and follow the prompts to set up triggers and actions.

What types of triggers can I use in Power Automate?

You can use various triggers in Power Automate, such as receiving a new email, a scheduled time, or an event in another application. Each trigger initiates the flow based on specific conditions.

Can I customize the name of files created in OneDrive using Power Automate?

Yes, you can customize the name of files created in OneDrive by using dynamic content to name the file based on the attachment name or any other relevant information.

What should I do if I encounter errors in my flow?

If you encounter errors in your flow, use the Flow Checker tool in Power Automate to identify and resolve any issues before saving or running the flow.

How can I stop a flow from running in Power Automate?

To stop a flow from running, go to the 'My Flows' section, select the flow you want to turn off, and use the ellipsis menu to turn off the flow.


Quelques cas d'usages :

Automating Certification Collection

A marketing team can use Power Automate to automatically collect and store certifications from colleagues after a webinar. By setting up a flow that triggers on new emails with attachments containing the word 'certification', the team can save time and ensure all certifications are stored in a designated OneDrive folder.

Streamlining Document Management

An HR department can implement a flow in Power Automate to manage employee documents. Whenever a new document is received via email, the flow can automatically save it to the appropriate OneDrive for Business folder, ensuring that all documents are organized and easily accessible.

Automated Reporting

A sales team can create a flow that compiles weekly sales reports from various emails. By setting triggers for emails with specific subject lines, the flow can gather attachments and save them in a shared OneDrive folder, making it easier for the team to access and review reports.

Monitoring Project Updates

A project manager can set up a flow to monitor project updates sent via email. By filtering for emails with attachments and specific keywords, the flow can automatically save relevant documents to a project folder in OneDrive, keeping all project materials organized.


Glossaire :

Power Automate

A cloud-based service that allows users to create automated workflows between applications and services to synchronize files, get notifications, collect data, and more.

Flow

An automated workflow created in Power Automate that performs a series of actions based on specified triggers.

Trigger

An event that starts a flow in Power Automate, such as receiving a new email.

Dynamic Content

Content that can change based on the context of the flow, allowing for more flexible and personalized automation, such as naming files based on the attachment name.

OneDrive

A cloud storage service from Microsoft that allows users to store files and access them from any device.

OneDrive for Business

A version of OneDrive that is designed for business use, providing additional features and storage options compared to the personal version.

Email Attachments

Files that are sent along with an email message, which can include documents, images, and other types of files.

Flow Checker

A tool in Power Automate that checks for errors or warnings in a flow before it is saved or run.

00:00:04
In this tutorial, we will focus
00:00:07
on the option of creating a flow
00:00:10
from scratch so you can see the
00:00:12
process in its entirety from
00:00:14
the home page of Power Automate.
00:00:16
Let's click on create in order
00:00:18
to build our first flow.
00:00:20
Let's say I'm going to receive
00:00:23
100 certifications from my
00:00:25
colleagues regarding a webinar
00:00:27
I will therefore need Power Automate
00:00:30
to check every email I received.
00:00:33
See if there are any attachments
00:00:35
and when my colleagues send me the
00:00:37
certification as the attachment.
00:00:39
Take it and create a file
00:00:41
in my OneDrive that way,
00:00:43
but Power Automate will find and
00:00:45
gather everyone of these without
00:00:47
me having to do so manually.
00:00:49
Let's build an automated cloud
00:00:52
flow that will be triggered by a
00:00:55
designated event by clicking on skip,
00:00:57
I can already access what I
00:01:00
should see as a blank canvas.
00:01:03
From here I simply have to realize what
00:01:06
application am I going to need to connect to
00:01:09
In order to write this flow well, first.
00:01:13
I will need Power Automate
00:01:15
to connect to office
00:01:17
outlook and what is the trigger?
00:01:19
That will trigger the action well.
00:01:22
Every time a new mail arrives,
00:01:24
Power Automate will check it.
00:01:28
Thanks to the advanced options,
00:01:30
I can give a hand to Power Automate
00:01:32
by telling it to only
00:01:35
look out for emails containing attachments.
00:01:40
Make sure not to forget them
00:01:42
by including every attachment
00:01:44
files and also by looking out for
00:01:48
emails that will contain the word
00:01:51
certification in the subject.
00:01:53
By using the subject filter option,
00:01:56
Power Automate will look for
00:01:57
the word in this subject.
00:01:59
If the subject of my email contains
00:02:02
other word and the word certifications,
00:02:05
it will work.
00:02:07
Now what do I want the machine to do for me?
00:02:09
Let's click on new tab.
00:02:10
I want Power Automate to access my OneDrive.
00:02:13
Let's look out for OneDrive and
00:02:15
be careful here between OneDrive
00:02:17
for business and OneDrive,
00:02:18
which is your personal one.
00:02:21
Let's choose OneDrive for business
00:02:23
and ask it to create a file
00:02:25
in my OneDrive for business.
00:02:28
Folder path marking on the button
00:02:30
on the right I can navigate my
00:02:33
OneDrive and decide where this
00:02:36
certification will be put.
00:02:38
In this example,
00:02:38
let's put them in the folder
00:02:40
that I called email attachments
00:02:42
from Power Automate.
00:02:45
What will be the name of said files?
00:02:49
I could simply force a name and call it
00:02:51
For example, Julien certification,
00:02:53
but this will not be useful in
00:02:56
my situation as I will receive
00:02:58
about 100 of them.
00:03:00
Therefore, I'm going to use
00:03:01
what is called dynamic content.
00:03:05
And ask Power Automate to simply name the
00:03:08
file the same name as the attachment.
00:03:14
What will be the content
00:03:16
of that file in OneDrive?
00:03:17
Well, by using dynamic content again,
00:03:20
I can tell the machine to simply copy
00:03:23
and paste the content of the attachment
00:03:26
In the file of my OneDrive.
00:03:29
Let's click on save.
00:03:33
And make sure that I use the flow
00:03:36
checker in order to see if there are
00:03:38
any errors or warnings for them
00:03:40
from the application.
00:03:43
And test it whether it is manually
00:03:45
or automatically in some cases.
00:03:52
After a while, should I not need
00:03:54
this flow any more, I simply
00:03:56
have to use the my flows button.
00:04:04
I can use the edit button in
00:04:06
order to change it, change to the
00:04:08
destination file or the word.
00:04:09
Power Automate will be looking
00:04:11
at for or use the ellipsis,
00:04:14
and turn off the flow.
00:04:17
As soon as I turn it off,
00:04:18
it will no longer run.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: WHAT YOU SHOULD KNOW

Reminder

Show