https://www.sikich.com

How to Automate Workflows Using Microsoft Flow

INSIGHT 2 min read

WRITTEN BY

Jeremy Centner

For those of us who work with the Microsoft stack of tools and applications, it’s a very exciting time.  Microsoft’s move to Office 365 and Dynamics 365 has solidified its stance that the Azure cloud is the future of business systems. With these cloud offerings, Microsoft is also deploying new powerful add-on tools designed for user efficiency. Two of the most recently deployed tools are called Power Apps and Microsoft Flow.

Power Apps is designed for super users to create internal applications that can hook into and leverage data sources such as SQL Databases and Excel. Flow is an Azure hosted workflow service that allows non-developers to create workflows and automate processes across multiple platforms. The two applications can be used in conjunction with one another, but it’s not required.  Typical uses for Flow can include push notifications, file synchronization, data collection, and automated approvals.  Microsoft has hundreds of prebuilt templates for users to log in and get started with. If the templates don’t provide what you need, then you can create your own flow process from a list of supported triggers and services. In addition to the browser version, Microsoft has created a Flow mobile app that allows users to receive notifications on their mobile devices, eliminating the lag time in any workflow approvals.

Below is an example of the design process utilizing the Outlook to One Drive template.  This template will take email attachments from Outlook and move them into a selected folder of OneDrive for business.

Browse for a Flow template

Select the appropriate Flow template

Define workflow parameters, actions, and notifications

Author

Jeremy Centner is the Pre-Sales Solution Architect Director at Sikich on the Enterprise Technology team. Jeremy has been working with the Dynamics products since 2011 with a focus on the manufacturing and distribution industries. His experience spans implementation consulting and project management to requirements gathering, business analysis, and solution presentations. With the vast experience in all aspects of ERP sales and implementations utilizing the Microsoft solution stack, Jeremy brings a unique perspective and provides extensive value to clients.