Intermediate | Flow of the Week: Automating Change Management Processes

Change Management processes are important to organizations to ensure work is scheduled, prioritized, repeatable and that oversight has been applied. However, a problem may arise if organizations layer too many levels of bureaucracy on top of these processes. But, the good news is that Microsoft Flow can automate many Change Management processes that allow organizations to achieve their Change Management goals, without accruing inefficiencies. In this weeks blog, we take a look at how Change Management notification processes can be streamlined using Microsoft Flow and ServiceNow.

» Read more

Advanced | Flow of the Week: Localize messages used in Flows using JSON object variables

Object variables can be used to provide “lookup table” functionality to Flows that need to initialize sets of variables together. The coalesce function can help with “fallback” or default behavior for keys that aren’t found in the table. This Flow of the Week will show how to use this technique to select sets of localized strings for use in easily generating emails in different languages from a single Flow.

» Read more

Advanced | Flow of the Week: Filtering Data with OData

A question that we frequently receive is how can I filter out data before it gets to Microsoft Flow? The answer to this question is: OData filter queries. In this blog post we are going to cover some of the most popular OData filter queries using some of our most popular connectors including SQL Server, Dynamics 365 and SharePoint Online.

» Read more

Advanced | Flow of the Week: Selective calendar event sync using Condition advanced editor mode and Boolean expressions

Some of the most popular Flow templates sync calendar events from one service to another (Office 365 to Google, Google to Office 365). I’ve found these useful, but I don’t want all events synced. In this post I’ll show how to use the Flow designer to write more complex Boolean logic in the “Condition” card’s advanced editor. This Boolean logic will help my Flow select only the events I care about syncing (using the body, subject, and/or time of the event). Along the way I’ll show how to use other Flow features like the “Control” connector to terminate a Flow run, datetime manipulation and formatting, and preventing infinite loops.

» Read more

Advanced | Flow of the Week: Get a daily email with the top failures captured in Application Insights

Today, i would like to show you how to address an issue which has been surfaced by one of our partners. As the Application Insights team recently shared with us, one of the most common questions from their users is: “How do I get periodic emails with the results of an Analytics query? “. Let’s build a flow which does precisely that. There is now a very simple answer for this, thanks to the new Azure Application Insights connector which was recently introduced.

» Read more