{"id":110962,"date":"2018-04-11T07:06:22","date_gmt":"2018-04-11T14:06:22","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/get-email-with-list-of-places-based-on-point-of-interest\/"},"modified":"2025-06-11T08:09:05","modified_gmt":"2025-06-11T15:09:05","slug":"get-email-with-list-of-places-based-on-point-of-interest","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/get-email-with-list-of-places-based-on-point-of-interest\/","title":{"rendered":"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest"},"content":{"rendered":"<p><em>The following is a FOTW blog written by\u00a0<a href=\"https:\/\/powerusers.microsoft.com\/t5\/Microsoft-Flow-Community\/ct-p\/FlowCommunity\">Flow Community\u00a0<\/a>member Ahmad Najjar (Twitter: @ahmadn82). This tutorial highlights how to use Microsoft Flow to get an email with a list of places in your current location based on a point of interest. Let&#8217;s begin.<\/em><\/p>\n<p>Have you ever ended up stranded in a city, not knowing which tourist attraction to hit, which restaurant to go to or where is the nearest grocery store? Well, today you are saved! Because the solution is\u00a0simply\u00a0punching\u00a0one\u00a0Flow button!<\/p>\n<p>For this scenario, we\u2019ll create a Button flow that collects a point of interest (POI) from you. It will then find places based on the POI you passed (Museums, Restaurants, Things to do, etc\u2026), and list\u00a0those\u00a0places. You\u2019ll then get an email with a table of the places\u00a0found, along with some details about those places (rating, address, etc\u2026).<\/p>\n<p>This flow will demonstrate some advanced concepts, including\u00a0<strong>calling a public API using the HTTP action<\/strong>,\u00a0<strong>parsing\u00a0<\/strong><strong>returned body from the API as JSON<\/strong>, and\u00a0<strong>building an HTML email<\/strong>.<\/p>\n<p>\u00a0<\/p>\n<h2><strong>Trigger the Flow<\/strong><\/h2>\n<p>The flow will start out simple with a Button trigger.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.png\" style=\"width: 590px; height: 176px;\"\/><\/p>\n<p>On the Button trigger, we\u2019ll have one input to collect a\u00a0POI. Next, we\u2019ll\u00a0call\u00a0<a class=\"Hyperlink SCXW139926253\" href=\"https:\/\/developers.google.com\/places\/web-service\/search\" rel=\"noreferrer noopener\" target=\"_blank\">Google\u2019s places API<\/a>\u00a0and\u00a0we\u2019ll pass the POI entered along with some\u00a0<strong>Dynamic Content\u00a0<\/strong>from the Button trigger.<\/p>\n<p>\u00a0<\/p>\n<h2><strong>Calling the API<\/strong><\/h2>\n<p>Calling the API is straight forward, we\u2019ll be using the\u00a0HTTP\u00a0action in Flow.\u00a0Select\u00a0Get\u00a0as the\u00a0Method\u00a0type and in the\u00a0Uri\u00a0we\u2019ll be passing the following:\u00a0<a href=\"https:\/\/maps.googleapis.com\/maps\/api\/pl\" target=\"_blank\" rel=\"noopener\">https:\/\/maps.googleapis.com\/maps\/api\/pl<\/a>ace\/nearbysearch\/json?location=[LATITUDE],[LONGITUDE]&amp;rankby=distance&amp;keyword=[POINT_OF_INTEREST]\u00a0in\u00a0[CITY]&amp;key=[YOUR_API_KEY]<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic202.png\" style=\"height: 392px; width: 590px;\"\/><\/p>\n<p><strong>Latitude,\u00a0Longitude<\/strong><strong>\u00a0<\/strong>and\u00a0<strong>City\u00a0<\/strong>are\u00a0<strong>Dynamic Content\u00a0<\/strong>coming\u00a0from the\u00a0<strong>Button<\/strong><strong>\u00a0<\/strong>trigger, while\u00a0<strong>Point of Interest<\/strong><strong>\u00a0<\/strong>is the input value entered through the\u00a0<strong>Button<\/strong><strong>\u00a0<\/strong>trigger.<\/p>\n<p>\u00a0<\/p>\n<h2><strong>Parsing JSON<\/strong><\/h2>\n<p>Next, we need to parse the returned JSON from the\u00a0HTTP\u00a0action and loop through the returned places in that JSON.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic203.png\" style=\"height: 322px; width: 590px;\"\/><\/p>\n<p>We\u2019ll pass the\u00a0<strong>body<\/strong>\u00a0returned from the\u00a0<strong>HTTP<\/strong>\u00a0action which contains our JSON. Note that we need to pass in the schema for the JSON returned. The schema must match the JSON payload, so the properties from the JSON is mapped correctly,\u00a0however we don\u2019t\u00a0have\u00a0to\u00a0define all the properties\u00a0in our schema\u00a0for the\u00a0returned JSON, we only need to define the properties that we are going to use later in our\u00a0Flow.<\/p>\n<p>For the reference, our schema should look something\u00a0like\u00a0the figure\u00a0below:\u00a0<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic204.png\" style=\"width: 300px; height: 981px;\"\/><\/p>\n<h2><strong>Create HTML Table<\/strong><\/h2>\n<p>At this point, we could use the\u00a0Create HTML table\u00a0action, pass the\u00a0results\u00a0property from\u00a0Parse JSON\u00a0action, define custom\u00a0columns\u00a0and then send the output in an email.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic205.png\" style=\"height: 408px; width: 590px;\"\/><\/p>\n<p>However, we want the email look neat by doing some extra formatting!<\/p>\n<p>\u00a0<\/p>\n<h2><strong>Building an HTML email using string variables<\/strong><\/h2>\n<p>We\u2019ll build the HTML email by creating a string variable \u2013 a variable is an easy way to collect data each time an action happens inside of a loop. Whenever you use a variable, first you need to use the Initialize variable action. You can name your variable whatever you like, but you need to be sure to set the Type as String.\u00a0First, we\u2019ll initialize the\u00a0<strong>Table of\u00a0Places<\/strong><strong>\u00a0<\/strong>variable, and we\u2019ll pass the table opening tag and header in the\u00a0<strong>value<\/strong><strong>\u00a0<\/strong>field.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic206.png\" style=\"width: 590px; height: 371px;\"\/><\/p>\n<p>Then, we\u2019ll\u00a0initialize\u00a0another\u00a0<strong>String variable<\/strong><strong>\u00a0<\/strong>to format the \u201copen_now\u201d\u00a0value returned from the API, so instead of showing true\/false, we want to show Yes\/No.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic207.png\" style=\"height: 162px; width: 590px;\"\/><\/p>\n<p>\u00a0<\/p>\n<h2><strong>Apply to each<\/strong><\/h2>\n<p>Inside the\u00a0Apply to each\u00a0we are going\u00a0to construct\u00a0the email. For each\u00a0result (Place)\u00a0we\u2019ll\u00a0set a condition to check the \u201copen_now\u201d property, if it\u2019s true we set the \u201cOpen\u201d variable to Yes otherwise we set it to No.\u00a0<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic208.png\" style=\"width: 591px; height: 279px;\"\/><\/p>\n<p>Next, we\u00a0add a\u00a0row to our table\u00a0with the details\u00a0of that\u00a0Place\u00a0by using the\u00a0<strong>Append to string variable<\/strong>\u00a0action,\u00a0we\u2019ll append these details\u00a0to the \u201cTable of\u00a0Places\u201d variable we initialized earlier.<\/p>\n<p>One more formatting we\u2019ll do, is making\u00a0our\u00a0Place\u00a0name linkable, whereas when clicked it will\u00a0navigate\u00a0to the exact location of that\u00a0Place\u00a0in Google maps! For this, we\u2019ll wrap the\u00a0Place\u00a0name\u00a0with an\u00a0<strong>HTML anchor<\/strong>\u00a0and we\u2019ll construct the\u00a0<strong>href<\/strong>\u00a0as follows:\u00a0<a href=\"http:\/\/maps.google.com\/maps?q=\" target=\"_blank\" rel=\"noopener\">http:\/\/maps.google.com\/maps?q=<\/a>[<strong>LATITUDE<\/strong>],[<strong>LONGITUDE<\/strong>] (<strong>Note:<\/strong>\u00a0Latitude and Longitude are from the API results)<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic209.png\" style=\"height: 291px; width: 591px;\"\/><\/p>\n<p>\u00a0<\/p>\n<h2><strong>Finalizing<\/strong><\/h2>\n<p>We\u00a0need to add\u00a0two\u00a0last actions\u00a0after the\u00a0Apply to each.\u00a0We\u00a0need to close out that HTML table with another\u00a0Append to string\u00a0action.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic2010.png\" style=\"width: 591px; height: 153px;\"\/><\/p>\n<p>And now we\u2019re ready to send the email. In the\u00a0<strong>Send an<\/strong> <strong>email<\/strong><strong>\u00a0<\/strong>action\u00a0we\u00a0can fill out the\u00a0<strong>To<\/strong><strong>\u00a0<\/strong>and\u00a0<strong>Subject<\/strong><strong>\u00a0<\/strong>fields with whatever we\u2019d like. In the\u00a0<strong>Body<\/strong>, all\u00a0we\u00a0need to do is use the\u00a0\u201cTable of\u00a0Places\u201d\u00a0variable.\u00a0Finally, we need to set\u00a0<strong>Is HTML<\/strong><strong>\u00a0<\/strong>to yes, otherwise we won\u2019t get the table in the correct format!<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic2011.png\" style=\"width: 590px; height: 584px;\"\/><\/p>\n<p>The\u00a0final Flow would look like this:<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic2012.png\" style=\"width: 590px; height: 723px;\"\/><\/p>\n<h2><strong>Running the Flow<\/strong><\/h2>\n<p>Finally, if you want to run this flow from your phone or your desktop, just enter\u00a0a point of interest\u00a0you\u00a0want to find nearby, and you\u2019ll immediately get a list\u00a0of\u00a0places\u00a0\u2013 with helpful details about those\u00a0places!<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic2013-1.png\" style=\"width: 589px; height: 322px;\"\/><\/p>\n<p>\u00a0<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic2014.png\" style=\"width: 590px; height: 612px;\"\/><\/p>\n<p>Thanks again to the Microsoft Flow team for collaborating with us to bring you the Flow of the Week!<\/p>\n<p>If you have any questions or comments, please leave them in the comments below or post your questions in the Flow Community!<\/p>\n<p>Until next time.<\/p>\n<p>P.S. To never miss another blog post from the Flow blog &#8211; <a href=\"https:\/\/preview.flow.microsoft.com\/en-us\/galleries\/public\/templates\/a2caf7a0013311e79ad6899240afe964\/get-updates-from-the-flow-blog\/\">us this Flow.<\/a><\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to share today&#8217;s Flow of the Week co-authored by Flow MVP Ahmad Najjar. In this tutorial, he walks us through how to use Microsoft Flow to get an email with a list of places in your current location based on a point of interest. Our Flow community members are constantly innovating on how they use Flow to solve their business needs.<\/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":[3423],"job-role":[],"product":[3474],"property":[],"topic":[],"coauthors":[2899],"class_list":["post-110962","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-tips-and-guides","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>Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest - 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\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to share today&#039;s Flow of the Week co-authored by Flow MVP Ahmad Najjar. In this tutorial, he walks us through how to use Microsoft Flow to get an email with a list of places in your current location based on a point of interest. Our Flow community members are constantly innovating on how they use Flow to solve their business needs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/get-email-with-list-of-places-based-on-point-of-interest\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-11T14:06:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:09:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.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=\"5 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\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/jonathon-levesque\/\",\"@type\":\"Person\",\"@name\":\"Jonathon Levesque\"}],\"headline\":\"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest\",\"datePublished\":\"2018-04-11T14:06:22+00:00\",\"dateModified\":\"2025-06-11T15:09:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/\"},\"wordCount\":965,\"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\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.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\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/\",\"name\":\"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest - 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\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.png\",\"datePublished\":\"2018-04-11T14:06:22+00:00\",\"dateModified\":\"2025-06-11T15:09:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#primaryimage\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.webp\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.webp\",\"width\":1215,\"height\":363,\"caption\":\"graphical user interface, application\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest\"}]},{\"@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":"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest - 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\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/","og_locale":"en_US","og_type":"article","og_title":"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest - Microsoft Power Platform Blog","og_description":"We are excited to share today's Flow of the Week co-authored by Flow MVP Ahmad Najjar. In this tutorial, he walks us through how to use Microsoft Flow to get an email with a list of places in your current location based on a point of interest. Our Flow community members are constantly innovating on how they use Flow to solve their business needs.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/get-email-with-list-of-places-based-on-point-of-interest\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2018-04-11T14:06:22+00:00","article_modified_time":"2025-06-11T15:09:05+00:00","og_image":[{"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.png","type":"","width":"","height":""}],"author":"Jonathon Levesque","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathon Levesque","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/jonathon-levesque\/","@type":"Person","@name":"Jonathon Levesque"}],"headline":"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest","datePublished":"2018-04-11T14:06:22+00:00","dateModified":"2025-06-11T15:09:05+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/"},"wordCount":965,"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\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.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\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/","name":"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest - 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\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.png","datePublished":"2018-04-11T14:06:22+00:00","dateModified":"2025-06-11T15:09:05+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#primaryimage","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.webp","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Pic201.webp","width":1215,"height":363,"caption":"graphical user interface, application"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/04\/11\/get-email-with-list-of-places-based-on-point-of-interest\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Advanced | Flow of the Week: Get an email with a list of places in your current location based on a Point of Interest"}]},{"@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\/110962","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=110962"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110962\/revisions"}],"predecessor-version":[{"id":131093,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110962\/revisions\/131093"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110962"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=110962"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=110962"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=110962"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=110962"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=110962"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=110962"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}