Using Microsoft Flow to Solve Business Problems

What is Microsoft Flow? With Flow you can setup automated workflows between your favourite apps and services to synchronise records and files, receive notifications, collect data, and more – and forget about repetitive tasks you or your team have to do.

Why do we need Microsoft Flow? A Microsoft blog article summarises this very well:

“Every organization faces constant pressure to do more with less. While technology is often key to operating more effectively and efficiently, cost and complexity have often prevented organizations from taking maximum advantage of the potential benefits.”

“We know not every business problem can be solved with off-the-shelf solutions. But developing custom solutions has traditionally been too costly and time consuming for many of the needs teams and departments face—especially those projects that integrate across multiple data sources or require delivery across multiple devices from desktop to mobile. As a result, too many technology needs end up unsolved or under-optimized. We piece together spreadsheets, email chains, and manual processes to fill in the gaps.”

“(PowerApps and) Microsoft Flow are both aimed squarely at these gaps. They give people who best understand their needs and challenges the power to quickly meet them, without the time, complexity and cost of custom software development.”

Some of the common business problems Flow can solve:

“I get hundreds of emails every day, and my notification options are all-or-nothing. It’s hard to keep up with all that traffic when I’m travelling. I’d like to get an SMS when specific people like a key customer prospect reach out directly to me.”

 

“Our teams are constantly meeting people at events and following up over email. We want to ensure we don’t miss any of these leads, but re-typing information from emails into our CRM system is tedious.”

 

“We work with agencies who create content and upload large files to OneDrive or Dropbox accounts. Our teams want to know right when the latest files arrive, without having to check every 30 minutes, and then they want to transfer a backup to SharePoint Online as soon as it comes through.”

Source: https://powerapps.microsoft.com/en-us/blog/introducing-microsoft-flow-and-announcing-the-public-preview-of-powerapps/

Flow is not a new concept – there are a number of similar offerings, such as IFTT (If This then That), and Zapier. Here’s how they compare at a glance:

Name # Connectors D365? Comments
IFTT 300+ No More consumer apps, free
Zapier 500+ Yes More business apps, free + paid plans
Flow 50+ Yes Microsoft Office app integration

Observations:

  • In terms of connectors (i.e. what apps and services these platforms can connect to), Zapier is the leader. However, it is worth noting that Flow is a new Microsoft product launched October 31st 2016 that receives frequent and continuous updates.
  • In the context of Dynamics 365, Only Zapier and Flow has native connectors. Both have connectors to CRM, but only Flow has connectors to other Dynamics 365 apps – including for Finance, Operations, and Common Data Service (previously called Common Data Model).
  • IFTT is more consumer focused and is free – e.g. “Save photos you’re tagged in on Facebook to a Dropbox folder”, and “Back up new iOS photos you take to Dropbox”. Zapier are more business focused and “trusted at companies large and small”. Flow is similar. In particular, it is targeted for power users, and has more integration with Microsoft products and services, such as Visual Studio Team Services (VSTS), Office 365, SharePoint, and Dynamics 365, as well as other common services like Dropbox, Twitter, and Facebook.

Features

Flow Features
Flow Features
  • Multi-step flows. You can setup and execute a sequence of events, such as in the example above: when a new tweet is posted by a user with more than 100 followers, create a new lead record in Dynamics 365, and add to a marketing list in MailChimp.
  • Conditions. Obviously being a workflow engine, it needs to have the ability to setup IF statements. Flow supports nested IF statements (i.e. IF within an IF.
  • Access to on-prem data. Using the data gateway, Flow is able to connect to on-prem systems, such as SQL Server.
  • Data Loss Prevenetion (DLP).  A newly added feature to allow prevention of business data or files from being transferred to and stored in personal services such as Dropbox and Google Drive.
  • Business-app Connectors. A variety of connectors such as for SharePoint, OneDrive, NAV, Excel, Yammer, Dynamics 365 (CRM, Operations, Financials, CDS, PowerApps, etc.), Salesforce, and MailChimp.
  • Mobile App. An app that provides the ability to design and create flows, view and control them, trigger them anytime with a single tap, and receive push notifications.
Flow Mobile
Flow Mobile
  • Multiple Environments. A newly added feature to allow isolation boundary for your flows, connections, gateways, and other resources.

Services

Flow has connectors for 50+ services, some of which are shown in the screenshot below. Some services are marked as Premium, such as Salesforce, Common Data Service, and MailChimp, i.e. they are not available in the free version.

Flow Services
Flow Services

Templates

Templates are services connected together to meet business requirements / solve business problems. There are thousands of templates available ready for configuration and use, published by Microsoft and as user contributions. You can publish your flows as templates for other people to discover and use. Here are some examples of Flow templates:

Flow Templates
Flow Templates

Applications

I have outlined above some business problems that Flow attempts to address, and hopefully the templates above give you some more ideas about what else can be done. Here are some other examples and possibilities:

  • Insert Twitter / Facebook posts as Lead or Case records in Dynamics 365
  • Synchronise Marketing List members between Dynamics 365 and MailChimp
  • Copy file attachments from an email (e.g. support@company.com) to respective client folders in SharePoint
  • Replicate case records when entered in Salesforce to Dynamics 365 / CDS

Licensing

The final part of this article is licensing (and pricing), which can be found in more details here: https://flow.microsoft.com/en-us/pricing/.

Flow is available for free, Plan 1, Plan 2, and as part of Office 365 / Dynamics 365 subscriptions. The main differences between the free, the various plans, and subscriptions are in the maximum number of runs per month (e.g. 750 for the free version, versus 2,000 if as part of Office 365 / Dynamics 365), maximum flow frequency (15 mins versus 5 mins), SLA, maximum custom APIs to connect to your own systems, and number of environments available.