Power Automate / Flow - Dropbox: Create a SAS Exchange Between SharePoint and Another Storage Service Tutorial

Learn how Power Automate can automate exchanges between Dropbox and SharePoint, allowing seamless file transfers. Discover templates to easily set up the process, and even receive notifications via Teams. Transform your workflow and ensure smooth file exchanges between different storage solutions. Explore the possibilities with this intriguing video!

03:34
632 views

Available in Microsoft365

Objectifs :

This document aims to provide a comprehensive overview of how to automate file exchanges between Dropbox and SharePoint using Power Automate, illustrating the process with a practical example.

Chapitres :

Introduction to Power Automate
Power Automate is a powerful tool that enables users to automate actions between various Microsoft services and external solutions. This document will explore how to set up an automated file exchange between Dropbox and SharePoint, enhancing productivity and streamlining workflows.
Scenario Overview
Consider a scenario where a company transitions from using Dropbox for cloud storage to Microsoft 365, specifically utilizing SharePoint for storage. The objective is to automate the exchange of files between a designated Dropbox folder and a specific SharePoint library.
Setting Up the Automation
To achieve this automation, follow these steps: 1. **Identify the Folders**: - In Dropbox, create a folder named 'SP exchange SS' to host the files to be retrieved. - In SharePoint, ensure there is a library available in a site named 'Sass Dropbox'. 2. **Utilize Power Automate Templates**: - Power Automate offers various templates. Search for a template that fits your needs by entering relevant keywords. - A flow template will be suggested based on your input.
Connecting Dropbox to Power Automate
Once you have selected a template, you will need to connect your Dropbox account to the flow using the correct credentials. The flow typically consists of a trigger and actions: - **Trigger**: The process starts when a file is created in the specified Dropbox folder ('SharePoint exchange SS'). - **Action**: The corresponding action on the SharePoint side involves defining the target location in your SharePoint site and the appropriate folder.
Configuring the Flow
When configuring the flow, note the following: - The name of the created file will match the original file's name. - The original file in Dropbox will not be deleted during this process. - You can enhance the flow by adding a notification via Microsoft Teams when a file is deposited. This can include details such as the file's properties and a message containing the file name and access link.
Testing the Automation
After setting up the flow, save it and test it by importing a file into your Dropbox folder. You can also move a file from one Dropbox folder to the 'SASS' folder. Upon execution, you should receive a Teams notification confirming the deposit. However, if the link is not clickable, you can modify the flow: 1. Switch to code view by clicking the small icon at the top right. 2. Integrate the link into an HTML hypertext tag. 3. Test again by depositing two files simultaneously.
Conclusion
Upon successful testing, you will receive functional Teams notifications with clickable links. Additionally, the files should be present in the SharePoint library, confirming that the automated exchange between Dropbox and SharePoint is functioning as expected. This automation not only saves time but also ensures that files are efficiently managed across platforms.

FAQ :

What is Power Automate used for?

Power Automate is used to automate workflows between different applications and services, allowing users to streamline processes and save time.

How can I connect Dropbox to Power Automate?

You can connect Dropbox to Power Automate by using the appropriate credentials when setting up a flow that involves Dropbox actions.

What happens when a file is created in Dropbox while using Power Automate?

When a file is created in a specified Dropbox folder, Power Automate can trigger an action to automatically copy that file to a designated SharePoint library.

Can I receive notifications in Teams when a file is deposited in Dropbox?

Yes, you can configure your Power Automate flow to send notifications in Microsoft Teams when a file is deposited in Dropbox.

What should I do if the link in my Teams notification is not clickable?

If the link is not clickable, you can modify your flow to include the link in an HTML hypertext tag, which will make it clickable in the notification.

Quelques cas d'usages :

Automating File Transfers from Dropbox to SharePoint

A company can use Power Automate to automatically transfer files from a Dropbox folder to a SharePoint library whenever a new file is added. This ensures that all team members have access to the latest documents without manual intervention.

Receiving Notifications for New Files

By setting up a flow in Power Automate, a team can receive instant notifications in Microsoft Teams whenever a new file is deposited in a specific Dropbox folder, improving communication and collaboration.

Creating Clickable Links in Notifications

A user can enhance their Power Automate flow to include clickable links in Teams notifications by using HTML tags, ensuring that team members can easily access shared files directly from the notification.

Glossaire :

Power Automate

A cloud-based service that allows users to create automated workflows between different applications and services.

Microsoft 365

A subscription service that includes access to Office applications and other productive tools provided by Microsoft.

SharePoint

A web-based collaboration platform that integrates with Microsoft Office, used for storing, organizing, sharing, and accessing information.

Dropbox

A cloud storage service that allows users to save files online and sync them to their devices.

Flow Template

Predefined workflows in Power Automate that can be customized to automate specific tasks.

Trigger

An event that starts a workflow in Power Automate, such as the creation of a file in Dropbox.

Dynamic Content

Content that can change based on the context of the workflow, such as file names or links that are generated during the flow.

HTML Hypertext Tag

A markup language used to create links in web pages, allowing users to click and navigate to other resources.

00:00:05

between certain Microsoft services and other external solutions.

00:00:09

Let's take the following example,

00:00:12

your company previously used cloud storage hosted by Dropbox following the

00:00:16

transition to Microsoft 365 and thus to a SharePoint storage solution,

00:00:22

you need to set up an automated exchange ss between these two spaces.

00:00:27

The goal is that when a file is deposited in a specific dropbox folder,

00:00:32

it is automatically retrieved in a specific sharepoint library.

00:00:36

This example relates to a Dropbox solution but

00:00:39

could just as well illustrate a Google drive.

00:00:41

Of course

00:00:44

we have on the dropbox side,

00:00:46

a folder named SP exchange SS which will host the files to be retrieved.

00:00:52

On the sharepoint side.

00:00:53

A library is available in a SharePoint site named Sass Dropbox.

00:00:59

There are many templates offered by power automate, one of which meets your needs

00:01:04

by using the templates and entering the appropriate keywords.

00:01:08

A flow template will be suggested to you.

00:01:10

Let's go,

00:01:12

you will need to connect your dropbox space

00:01:14

to the flow with the correct credentials.

00:01:19

The flow is generally simple.

00:01:21

It proposes a trigger defining the start of the process. When a file is created

00:01:25

on the dropbox side.

00:01:27

Then a second action on the sharepoint side. Of course,

00:01:31

in the dropbox action block, identify the folder to monitor named here,

00:01:35

SharePoint exchange SS

00:01:38

in the other action block define the target location,

00:01:41

your SharePoint site and the corresponding folder

00:01:44

in the dropbox exchange SS library.

00:01:47

Some elements are prefilled. Since you are starting from a template,

00:01:51

the name of the created file will be identical

00:01:54

and will contain the content of the original file.

00:01:58

Note,

00:01:58

the flow will not delete the original file on

00:02:01

dropbox power automate actions on external services are limited.

00:02:06

You can complete this flow by opting to be notified via teams of the

00:02:09

file deposit depending on the detail to be included in this notification message,

00:02:14

retrieve the properties of the created file by referencing its id

00:02:24

lastly add a team's conversational message action

00:02:27

block where you are the recipient,

00:02:33

draft the message that should contain the file name

00:02:36

and its access link retrieved through the dynamic content

00:02:42

save test and import a file into your dropbox folder.

00:02:49

You can of course move a file from one dropbox folder to the SASS folder.

00:02:55

The flow executes and you receive a team's

00:02:57

notification of the deposit with the name.

00:02:59

However, the link is not clickable,

00:03:04

then modify your flow.

00:03:05

Switch to code with the small icon at the top

00:03:08

right and integrate the link into an html hypertext tag

00:03:15

test again by depositing two files simultaneously. This time.

00:03:20

Perfect.

00:03:22

You receive two teams notifications with functional links.

00:03:27

On the sharepoint library side, the files are indeed present

00:03:30

your exchange SAS works and meets your expectations.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

539 Views

Microsoft Video Training Power Automate – From discovery to mastering automation

Boost your productivity with our Power Automate course! Learn to automate your tasks and seamlessly integrate various Microsoft 365 services...

ALL COURSES