{"id":111010,"date":"2019-06-12T08:00:02","date_gmt":"2019-06-12T15:00:02","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/"},"modified":"2019-06-12T08:00:02","modified_gmt":"2019-06-12T15:00:02","slug":"beginner-flow-of-the-week-early-meeting-reminder","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/","title":{"rendered":"Intermediate | Flow of the Week: Early Meeting Reminder"},"content":{"rendered":"

Hi Flow Community!<\/p>\n

Have you ever missed an important meeting because it was before your normal work hours? This happened to me one too many times, so I decided to do something about it! My flow runs every night around 8 p.m. and sends me and email if I have a meeting before 10 a.m. the next day. This gives me time to change my alarm if needed or make other plans. 10 a.m. may not be \u201cearly\u201d to a lot of you, but these values are easy to change.<\/p>\n

Before I get into the implementation, if you only care about the solution, I\u2019ve created templates for Office 365 Outlook<\/a>, Outlook.com<\/a>, and Google Calendar\/Gmail<\/a>. I\u2019ll be walking through the Office 365 Outlook version, but the others are pretty much the same.<\/p>\n

In theory this a straightforward flow, given the handy \u201cGet calendar view of events\u201d action. Get current time, add hours, get events, send an email. But of course time zones have to show up and complicate things. So let\u2019s break it down.<\/p>\n

Here\u2019s the math-y part. \u201cGet current time\u201d uses UTC, so we have to convert it to local time to work properly with the startOfDay() function. It turns out that even though we specify the \u201cRound-trip [o]\u201d format, it loses the time zone information here, so we have to convert it back to UTC to be useful to the calendar action. We then add a day to get start of day tomorrow, then another 10 (or however many) hours to get the threshold for \u201cearly\u201d. These actions are also all available as functions if you\u2019d like to condense this part, but the actions make for a more readable and fillable template.<\/p>\n

\"\"<\/p>\n

NOTE: I didn\u2019t specify the minutes in my Recurrence trigger, meaning it will run sometime between 8:00 and 9:00. If you specify exactly 8:00 you can skip the time zone stuff and do +4h, +10h to get the range. This makes for a brittle template though because changing one value requires changing the others, and we have no real need to run exactly on the hour.<\/p>\n

\"\"<\/p>\n

This is the easy part. We pass the calculated times to \u201cGet calendar view of events action\u201d. For Outlook, we pass the \u201cisAllDay eq false\u201d filter because all-day events don\u2019t count as early. Google Calendar doesn\u2019t have an equivalent filter, so instead we use the \u201cFilter array\u201d action and check whether the start time has a \u201cT\u201d separator in it, indicating a specific start time vs. an all-day event.<\/span>
\n\"\"<\/p>\n

We then check if there are any events in the array. Normal condition stuff.<\/p>\n

\"\"<\/p>\n

From here we could send an email that says \u201cEarly meeting! Go check your calendar!\u201d and call it quits. But where\u2019s the fun in that? Instead, let\u2019s convert the events to local time and put them in a more readable format for the email. You can skip the \u201cApply to each\u201d in favor of a \u201cSelect\u201d action here, but that doesn\u2019t let us leave the time zone blank for the template.<\/p>\n

\"\"<\/p>\n

Finally, we send the reminder email. Outlook.com and Gmail require you to type in your own email address, but Office 365 has a handy \u201cGet my profile\u201d action that saves you the trouble.<\/p>\n

\"\"<\/p>\n

That\u2019s it! Hopefully this flow helps keep your schedule running smoothly. Extra credit if you can get it to filter out an 11:00 a.m. Monday through 5:00 p.m. Friday event (not \u201call-day\u201d but multi-day), or to remind attendees of the early meeting you\u00a0<\/em>scheduled. Let me know in the comments if you have any feedback or if you have any cool timing or scheduling flows of your own.<\/p>\n","protected":false},"excerpt":{"rendered":"

Have you ever missed an important meeting because it was before your normal work hours? Learn how to get reminder emails for early meetings using Microsoft Flow, and get a crash course in the joy of time zones at the same time.<\/p>\n","protected":false},"author":377,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2590,2836],"power-automate-tag":[2591,2638],"coauthors":[2946],"class_list":["post-111010","power-automate","type-power-automate","status-publish","hentry","power-automate-category-flow-of-the-week","power-automate-category-walkthroughs","power-automate-tag-flow-of-the-week","power-automate-tag-intermediate"],"yoast_head":"\nIntermediate | Flow of the Week: Early Meeting Reminder - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Intermediate | Flow of the Week: Early Meeting Reminder - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Have you ever missed an important meeting because it was before your normal work hours? Learn how to get reminder emails for early meetings using Microsoft Flow, and get a crash course in the joy of time zones at the same time.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/06\/Timezones.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Zack Sigmund\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/\",\"name\":\"Intermediate | Flow of the Week: Early Meeting Reminder - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/06\/Timezones.png\",\"datePublished\":\"2019-06-12T15:00:02+00:00\",\"dateModified\":\"2019-06-12T15:00:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#primaryimage\",\"url\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/06\/Timezones.png\",\"contentUrl\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/06\/Timezones.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Intermediate | Flow of the Week: Early Meeting Reminder\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Intermediate | Flow of the Week: Early Meeting Reminder - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/","og_locale":"en_US","og_type":"article","og_title":"Intermediate | Flow of the Week: Early Meeting Reminder - Microsoft Power Platform Blog","og_description":"Have you ever missed an important meeting because it was before your normal work hours? Learn how to get reminder emails for early meetings using Microsoft Flow, and get a crash course in the joy of time zones at the same time.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/06\/Timezones.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Zack Sigmund"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/","name":"Intermediate | Flow of the Week: Early Meeting Reminder - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#primaryimage"},"thumbnailUrl":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/06\/Timezones.png","datePublished":"2019-06-12T15:00:02+00:00","dateModified":"2019-06-12T15:00:02+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#primaryimage","url":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/06\/Timezones.png","contentUrl":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/06\/Timezones.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/beginner-flow-of-the-week-early-meeting-reminder\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Intermediate | Flow of the Week: Early Meeting Reminder"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/111010"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/377"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=111010"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/111010\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=111010"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=111010"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=111010"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=111010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}