Flow / Power Automate - 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
  • 370 views

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 :

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.

résultat(s)
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.

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

 

résultat(s)
00:00:02
O Power Automate também permite automatizar ações
00:00:05
entre determinados serviços da Microsoft e outras soluções externas.
00:00:09
Vejamos o seguinte exemplo,
00:00:12
a sua empresa utilizou anteriormente armazenamento na nuvem hospedado pelo Dropbox seguindo o
00:00:16
transição para o Microsoft 365 e, portanto, para uma solução de armazenamento do SharePoint,
00:00:22
precisa de configurar uma troca automática ss entre estes dois espaços.
00:00:27
O objetivo é que, quando um ficheiro é depositado numa pasta dropbox específica,
00:00:32
é recuperado automaticamente numa biblioteca específica do sharepoint.
00:00:36
Este exemplo refere-se a uma solução do Dropbox mas
00:00:39
poderia muito bem ilustrar um Google Drive.
00:00:41
Claro
00:00:44
temos no lado do dropbox,
00:00:46
uma pasta chamada SP exchange SS que hospedará os arquivos a serem recuperados.
00:00:52
Do lado do sharepoint.
00:00:53
Uma biblioteca está disponível num site do SharePoint chamado Sass Dropbox.
00:00:59
Existem muitos modelos oferecidos pelo power automate, um dos quais satisfaz as suas necessidades
00:01:04
utilizando os modelos e introduzindo as palavras-chave apropriadas.
00:01:08
Um modelo de fluxo ser-lhe-á sugerido.
00:01:10
Vamos,
00:01:12
terá de ligar o seu espaço dropbox
00:01:14
para o fluxo com as credenciais corretas.
00:01:19
O fluxo é geralmente simples.
00:01:21
Propõe um gatilho que define o início do processo. Quando um ficheiro é criado
00:01:25
no lado do dropbox.
00:01:27
Em seguida, uma segunda ação no lado do sharepoint. Claro,
00:01:31
no bloco de ação do dropbox, identifique a pasta a monitorar com o nome aqui,
00:01:35
SharePoint troca SS
00:01:38
no outro bloco de acção definir a localização de destino,
00:01:41
o seu site do SharePoint e a pasta correspondente
00:01:44
na biblioteca SS do dropbox exchange.
00:01:47
Alguns elementos são pré-preenchidos. Uma vez que está a começar a partir de um modelo,
00:01:51
o nome do ficheiro criado será idêntico
00:01:54
e conterá o conteúdo do ficheiro original.
00:01:58
Nota,
00:01:58
o fluxo não eliminará o ficheiro original em
00:02:01
as ações do dropbox power automatize em serviços externos são limitadas.
00:02:06
Pode completar este fluxo optando por ser notificado através das equipas do
00:02:09
arquivo de depósito dependendo do detalhe a incluir nesta mensagem de notificação,
00:02:14
recuperar as propriedades do ficheiro criado fazendo referência ao seu id
00:02:24
por último, adicionar a ação de mensagem conversacional de uma equipa
00:02:27
bloquear onde é o destinatário,
00:02:33
rascunho da mensagem que deve conter o nome do ficheiro
00:02:36
e o seu link de acesso recuperado através do conteúdo dinâmico
00:02:42
salve, teste e importe um arquivo para a sua pasta do dropbox.
00:02:49
É claro que pode mover um ficheiro de uma pasta dropbox para a pasta SASS.
00:02:55
O fluxo é executado e recebe a de uma equipa
00:02:57
notificação do depósito com o nome.
00:02:59
No entanto, o link não é clicável,
00:03:04
depois modifique o seu fluxo.
00:03:05
Mudar para o código com o pequeno ícone na parte superior
00:03:08
direita e integrar o link numa tag de hipertexto html
00:03:15
testar novamente depositando dois ficheiros simultaneamente. Desta vez.
00:03:20
Perfeito.
00:03:22
Recebe duas notificações de equipas com ligações funcionais.
00:03:27
No lado da biblioteca do sharepoint, os ficheiros estão efectivamente presentes
00:03:30
a sua bolsa SAS funciona e corresponde às suas expectativas.

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

 

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

249 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

An Error Has Occurred

Impossible de sauvegarder votre progression. Veuillez recharger la page, vous connecter, et essayer de nouveau. Si le problème persiste, merci de contacter un administrateur.

Close

Reminder

Show

/

Join Live Training Session