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: 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