Go with the (Microsoft) Flow

By Ross Smith, Solution Specialist, Data#3.

[Reading time: 3.30 mins]

Process automation is a hot topic. With the explosive growth of information across multiple disparate sources, and the expectation that we are all meant to be up-to-date 100 percent of the time, on all of our workload, there is no lack of vendors trying to fill the void between information and effective action across all platforms. There are so many players, from simple to amazingly complex, that even if I named all that I have seen in the last month, I would most likely omit some great products!

From the stalwarts like IFTTT, and Zapier at the simple workflow end (that I also currently use), to Hootsuite and Buffer at the more complex social end of the scale, there is something for everyone with more coming online almost weekly. Even while looking up the above to reference, I discovered Zoho Social – an automation tool for social media feeds to help engage more clients, with the most fantastic analytics that I have seen to date.

For a company that has a long history of process automation through platforms like CRM, SharePoint and SCCM Orchestrator, Microsoft has been surprisingly absent from this segment of the market. If you are a corporate customer with Office 365 Enterprise licensing and access to OneDrive and the other applications, there hasn’t been any easy way to link them all together.

It’s time to go with the flow

With the introduction of Flow earlier this year, Microsoft are no longer absent – although in my opinion, I wouldn’t say it has made a splash or even a ripple in the market. Hard-core ‘Microsoftophiles’ would have seen it come out via various low key announcements, and maybe even started playing with it however, with the ‘preview’ stamp still firmly emblazoned in the corner, there may be some quirks behind the scenes to work out. That being said, it has been reliable in testing and offers some valuable Microsoft-centric automation that will only grow over time.

find the perfect flow


Whereas popular platform IFTTT uses the term ‘recipe’, Flow refers to their workflows as ‘Flows’ and has some pre-canned templates. No real surprises there, but the list of support applications is surprisingly brief, with only 41 on the list at the time of writing:

flow options

This number is sure to grow, however, it could be argued that keeping this platform focused is actually a better strategy. There is the option of ‘custom API’ after all, so any keen developer could jump in and start to plumb in all kinds of other services, on-premises and Cloud-based alike.

Going deeper with Microsoft

However, where other platforms go wide, Flow goes deep with some good integrations with existing Microsoft productivity tools and some social platforms. Notably absent are any ecommerce sites like eBay, Storenvy or Shopify, however, I believe this is deliberate as the audience targeted is not the run of the mill user, but someone who lives in the Microsoft ecosystem day in, day out. Most of the example flows (or templates) relate directly to Microsoft products as can be seen below, or follow this link for the full list.


I can see Yammer, SharePoint, OneDrive and Office 365 (Outlook) in the Microsoft world, but then linking these to their competitors is a stroke of genius. For example, linking OneDrive to Google Drive or Dropbox enables a simple backup mechanism that the innovative side of my brain loves, but this is where the security consultant in me is losing his mind!

This is not for the faint hearted at a corporate level, and the possibility of an accidental security breach goes up exponentially, however, by talking to a Data#3 security expert, this minefield can be safely navigated to balance a happy end user and a company security advisor who can sleep easy.

As with all new products, they need to be carefully assessed. Guidelines should be developed so that the technology works with the business outcomes and not against.

Looking at the governance side of this new product naturally leads us to Azure Rights Management and Data Loss Protection (DLP). The challenge of stray data is perhaps not solved, but at least mitigated, while enabling users to be more flexible and take control of their data. Flow has the capacity to automate a lot of mundane tasks, to enable a more productive and responsive employee, all while remaining within the Microsoft suite of products.

So, in short, even though this product/platform is still in preview, requires an Office 365 account and only has 41 integrated applications, there is still a lot to get excited about for a Microsoft shop. Check out the getting started guides here and go with the flow.

Tags: Business Productivity, Microsoft, Microsoft Flow


Subscribe to our blog


What is the role of partners in a aaS world
What is the role of partners in a vendor-driven ‘as a Service world?

Digitalisation has changed gear and the shift to Everything as a Service has revised not just the way businesses think…

Deep Dive Into Azure Purview
A deep dive into Azure Purview

In collaboration with Microsoft’s Azure engineering team, Data#3 peels off the wrapping on Microsoft’s upcoming data governance platform, Purview. Our…

Customer Story: Knight Frank Australia

Knight Frank Cloud Transition Enables Breakthrough Property Services Objective The Knight Frank team in Australia sought to reduce its on-premises…

Azure Cosmos Vulnerability
Vulnerability in Microsoft Azure Cosmos DB

TLDR: I recommend all customers using Cosmos DB rotate all connection keys for each instance of Cosmos DB immediately.  …

Citrix on Azure
Citrix on Azure: 4 things to know before moving from on-premises to the cloud

Over the last year, organisations around the world have had to rethink the workplace technology they provide to their people.

Remote Working on Citrix Azure
The security risks of remote working and how Citrix on Azure can help

We are living in a time of significant change when it comes to how and when we work. The events…

Microsoft Data#3 Certified
Data#3 leads the way with Microsoft certifications and advanced specialisations

August 10, 2021; Brisbane, Australia: Leading Australian technology services and solutions provider, Data#3, today announced that it has successfully renewed…

Want to move your VMware to the cloud? Here’s why an Azure VMware Solution is an ideal choice

For many years, VMware has been a global leader in virtualisation solutions. Customers of all sizes and across all industries…