Microsoft embed the couple of new services to office 365 service club on May 4th 2016. From that day on wards, most of persons may noticed two new app tiles are visible in the suite bar.
One is Microsoft PowerApps and another one is Microsoft Flow (this is similar to the workflow designer)
This article covers the introduction to Microsoft Flow, its users and a simple example to connect Outlook and SharePoint. Will cover PowerApps later.
In our world, we are using most of the services separately and enjoying their benefits alone. There is no easier way to connect each services. For ex., There is no easier methods available to connect between the Dropbox and SharePoint, SharePoint and Twitter, Salesforce and Dropbox, etc…
To achieve those connectivity, we have to spend lot for our time and money to establishing the connectivity between each service. To avoid that cons, Microsoft introduces the Flow service, that bridges the gap between each services / application in the form of automated workflow.
At present, Microsoft Flow is in preview state and this enables us to setup (configure / create) automated workflows between our favorite apps and services to get notifications, synchronize files, collect data and more.
Below screenshot shows the apps / cloud services available for connectivity in flow. We have to setup a connection between each services to start creating a flow.
Before jump in to sample, Microsoft Flow ships with around 50 pre-defined templates. The template can save our time and simplify our work life by connecting the services in a flow instead of starting from scratch.
I have listed some available templates below,
- Save my email attachments to SharePoint Library
- Get daily remainders in email
- Send me an email when a new file is added to SharePoint online
- Save email attachments to dropbox
- Translate non-english emails
I’ll cover detail about each template in upcoming articles.
In this example, we are going to use a pre-defined template called “Save my email attachments to SharePoint Library” to create a flow.
This template used to copy the email attachments to the SharePoint Library, whenever a new emails reaches with attachments to the Inbox.
- User should have access to SharePoint site
- User should have office 365 outlook account
- SharePoint site should have some library to copy attachments. (In example, we are using document library named “Email Attachments”)
Create a new Flow:
- Signup and sign in to a Flow site https://flow.microsoft.com/en-us/ with an office 365 account
- Click Browse from the suite bar / enter “Save my email attachments to SharePoint Library” in search box to view the flow template, which is used for our example.
- Select / click “Save my email attachments to a SharePoint document library” box.
- In the template page, click “Use this template” button to start create a flow,
- Now the system redirected to the page, where you can create new connections to establish the permissions to access Outlook API and SharePoint Online API services.
- To add a connection, click on Select a connection drop down under Office 365 Outlook and then select “+ Add new connection”, which redirects the user to sign-in page for selected product.
- Click “Sign in to Office 365 Outlook”, which open an another window to enter credentials to add the connection to the flow.
- Once the connection established, Manage Permissions page looks like below, (for ex., I have used the same account to connect the Office 365 Outlook and SharePoint online). Click “Continue” start creating a new flow.
- You can set name for the flow in “Flow name” textbox. I have changed from “Save my email attachments to a SharePoint document library” to “My First flow application”
- Expand “On new email” by clicking on that, then select “Inbox” folder from outlook email box.
- Then expand, “Create File” to provide SharePoint site and Library details. And Flow application provides some predefined termsets for setting file name and content for new file.
- Enter SharePoint Online url in Site Url,
- Select or enter web relative url of library folder name in Folder Path
- Select “Name” term for File Name and “Content” term for File Content.
- Click “Create Flow” button available next to the Flow Name text box.
- We will get success message after creation of flow.
- Click Done to open “My Flows” page.
- Click List Rrns button to view the history of runs for the selected flow.
- If the outlook receives the emails in Inbox, our “My First flow application” flow runs and check for email attachments. If attachments available in email, the workflow will automatically copy the attachments to SharePoint Library “Email Attachments”
Microsoft flow provides a nice feature to integrate different services and all we can control by creating a workflow.