{"id":110816,"date":"2017-04-10T07:07:04","date_gmt":"2017-04-10T14:07:04","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/flow-of-the-week-creating-appointments-from-excel-table\/"},"modified":"2025-06-11T08:14:50","modified_gmt":"2025-06-11T15:14:50","slug":"flow-of-the-week-creating-appointments-from-excel-table","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/flow-of-the-week-creating-appointments-from-excel-table\/","title":{"rendered":"Beginner | Flow of the Week: Creating appointments from an Excel table"},"content":{"rendered":"<p>Hello Flow Community!<\/p>\n<p>Today I am going to create a flow to address an actual business need from one of our customers.\u00a0This question came from the <a href=\"http:\/\/reddit.com\/r\/microsoftflow\" style=\"font-size: 13.008px;\">Microsoft Flow Subreddit<\/a>\u00a0and was asked like this:<\/p>\n<p><em>Hi there! I would like to make a flow, that uses Excel and Outlook meetings. When\u00a0I schedule a meeting in Outlook,\u00a0I want some of the text from the text field, to transfer to our budget, that we have in Excel. Alternatively, if that isn&#8217;t possible, I want to write the customer&#8217;s information in our budget Excel, and then have it send out a meeting invitation, with text pulled from the Excel sheet<\/em><\/p>\n<p>\u200b<strong>I&#8217;m going to go ahead and use his second option<\/strong> &#8211; <em>Alternatively, if that isn&#8217;t possible, I want to write the customer&#8217;s information in our budget Excel, and then have it send out a meeting invitation, with text pulled from the Excel sheet<\/em><\/p>\n<p><em>\u200b<\/em>\u200bFirst things first &#8212; we are going to need to set up our Excel sheet properly. I asked the user to send me the sheet he uses for his budget tracking, removed all the data, and then converted it to a table.<\/p>\n<p>Here is the <a href=\"https:\/\/1drv.ms\/x\/s!AnFATp1ms-B-jKB3MeLSggFTMWjCtg\">sample sheet<\/a> we are using for this Flow. Get familiar with it a bit before you dive into the rest of this tutorial and if you&#8217;re going to follow along, make sure to host it in OneDrive so it can be accessed in the cloud.<\/p>\n<ol>\n<li>Open <a href=\"https:\/\/flow.microsoft.com\/\">the Microsoft Flow portal<\/a>.<\/li>\n<li>Click on <strong>My Flows<\/strong>.<\/li>\n<li>Click on <strong>Create From Blank<\/strong>.<\/li>\n<li>Since Excel has actions and not triggers, we\u2019re going to work around that by using the trigger type <strong>Recurrence<\/strong> and then setting it to check our Excel file every 1 hour.\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.png\"\/><\/p>\n<\/li>\n<li>Add a new step into your flow and now choose Excel and the action <strong>Get Rows.\u00a0<\/strong>Select your Excel file and the proper table within it.\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw2.png\"\/><\/p>\n<\/li>\n<li>Add a new step to your Flow. Choose <strong>Apply to each<\/strong> and select <strong>Value<\/strong> from your Excel dynamic content.\u00a0(This\u00a0tells our flow &#8220;for every row that contains X do the action Y&#8221;, which we will define next.)\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw3.png\"\/><\/p>\n<\/li>\n<li>Now let&#8217;s create the\u00a0conditions that will send the actual meeting invite based off the sheet. For the\u00a0Object name, select the Dynamic content item <strong>Confirmation sent<\/strong> from our Excel sheet,\u00a0then select <strong>Is equal to<\/strong>\u00a0from the dropdown menu and set the\u00a0value to\u00a0<strong>No.<\/strong>\u00a0(This tells the flow to check if this column has a Yes or No within it, and if it has a No, to take the action outlined below.)<\/li>\n<li>Now,\u00a0under the box that says <strong>IF YES<\/strong>,\u00a0lets add a new step to our flow. Choose Office 365 Outlook, select the action <strong>Create Event V2,<\/strong> and fill in all the necessary sections with dynamic content from our columns in our Excel table. This creates the appointment and maps your Excel columns to fields in the appointment and email.\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw4.png\"\/><\/p>\n<p>\tAnd now finally, lets add a step that updates that Excel column to say YES\u00a0for <strong>Confirmation sent<\/strong> once the appointment has been sent. This way it doesn&#8217;t send again the next time it checks.<\/p>\n<\/li>\n<li>Add a step to your flow and search for Excel. Add the action <strong>Update row<\/strong>, select your same spreadsheet and table we have already been working with, and fill in the <strong>Confirmation Sent<\/strong>\u00a0row with a <strong>Yes. <\/strong>For every other column use the dynamic content item associated with it like shown here:\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw5.png\"\/><\/p>\n<\/li>\n<\/ol>\n<p>And voila! Just like that, you can fill out your budget tracking spreadsheet and let flow set your meeting time, invitees, what\u2019s said in the appointment email and more! This is the beauty of Flow: if you have a unique need like this one, there is likely a solution that you can create to save yourself time and energy!<\/p>\n<p>If you want us to create a Flow for your company or for your problem, let us know on the\u00a0<a href=\"https:\/\/powerusers.microsoft.com\/t5\/Microsoft-Flow-Community\/ct-p\/FlowCommunity\">Microsoft Flow Community<\/a>, <a href=\"https:\/\/twitter.com\/MicrosoftFlow\">Twitter<\/a>, or here in the comments!<\/p>\n<p>Thanks for reading!!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today I am going to create a flow to address an actual business need from one of our customers: &#8220;I want to write the customer&#8217;s information in our budget Excel, and then have it send out a meeting invitation, with text pulled from the Excel sheet&#8221;<\/p>\n","protected":false},"author":348,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[],"job-role":[],"product":[3474],"property":[],"topic":[],"coauthors":[2899],"class_list":["post-110816","post","type-post","status-publish","format-standard","hentry","audience-it-professional","product-power-automate"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Beginner | Flow of the Week: Creating appointments from an Excel table - 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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Beginner | Flow of the Week: Creating appointments from an Excel table - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Today I am going to create a flow to address an actual business need from one of our customers: &quot;I want to write the customer&#039;s information in our budget Excel, and then have it send out a meeting invitation, with text pulled from the Excel sheet&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/flow-of-the-week-creating-appointments-from-excel-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-10T14:07:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:14:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.png\" \/>\n<meta name=\"author\" content=\"Jonathon Levesque\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathon Levesque\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/jonathon-levesque\/\",\"@type\":\"Person\",\"@name\":\"Jonathon Levesque\"}],\"headline\":\"Beginner | Flow of the Week: Creating appointments from an Excel table\",\"datePublished\":\"2017-04-10T14:07:04+00:00\",\"dateModified\":\"2025-06-11T15:14:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/\"},\"wordCount\":681,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.png\",\"keywords\":[\"Flow of the Week\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/\",\"name\":\"Beginner | Flow of the Week: Creating appointments from an Excel table - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.png\",\"datePublished\":\"2017-04-10T14:07:04+00:00\",\"dateModified\":\"2025-06-11T15:14:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#primaryimage\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.webp\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.webp\",\"width\":761,\"height\":316},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Beginner | Flow of the Week: Creating appointments from an Excel table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/017e233f3881f5857f3e7f6f221ef772\",\"name\":\"Jonathon Levesque\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g42ef9de3d3e22347884fca1cf41497c5\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g\",\"caption\":\"Jonathon Levesque\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/jolevesq\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Beginner | Flow of the Week: Creating appointments from an Excel table - 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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/","og_locale":"en_US","og_type":"article","og_title":"Beginner | Flow of the Week: Creating appointments from an Excel table - Microsoft Power Platform Blog","og_description":"Today I am going to create a flow to address an actual business need from one of our customers: \"I want to write the customer's information in our budget Excel, and then have it send out a meeting invitation, with text pulled from the Excel sheet\"","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/flow-of-the-week-creating-appointments-from-excel-table\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2017-04-10T14:07:04+00:00","article_modified_time":"2025-06-11T15:14:50+00:00","og_image":[{"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.png","type":"","width":"","height":""}],"author":"Jonathon Levesque","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathon Levesque","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/jonathon-levesque\/","@type":"Person","@name":"Jonathon Levesque"}],"headline":"Beginner | Flow of the Week: Creating appointments from an Excel table","datePublished":"2017-04-10T14:07:04+00:00","dateModified":"2025-06-11T15:14:50+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/"},"wordCount":681,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.png","keywords":["Flow of the Week"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/","name":"Beginner | Flow of the Week: Creating appointments from an Excel table - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.png","datePublished":"2017-04-10T14:07:04+00:00","dateModified":"2025-06-11T15:14:50+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#primaryimage","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.webp","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/fotw1.webp","width":761,"height":316},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/10\/flow-of-the-week-creating-appointments-from-excel-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Beginner | Flow of the Week: Creating appointments from an Excel table"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/017e233f3881f5857f3e7f6f221ef772","name":"Jonathon Levesque","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g42ef9de3d3e22347884fca1cf41497c5","url":"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g","caption":"Jonathon Levesque"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/jolevesq\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/348"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110816"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110816\/revisions"}],"predecessor-version":[{"id":131304,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110816\/revisions\/131304"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110816"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=110816"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=110816"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=110816"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=110816"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=110816"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=110816"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}