{"id":110937,"date":"2018-02-07T06:24:21","date_gmt":"2018-02-07T14:24:21","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/how-to-extract-email-data-and-send-to-sharepoint-list\/"},"modified":"2025-06-11T08:09:47","modified_gmt":"2025-06-11T15:09:47","slug":"how-to-extract-email-data-and-send-to-sharepoint-list","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/how-to-extract-email-data-and-send-to-sharepoint-list\/","title":{"rendered":"Beginner | Flow of the Week: How to Extract Email Data and Send to SharePoint List"},"content":{"rendered":"<p><em>The following is a FOTW blog written by <a href=\"https:\/\/powerusers.microsoft.com\/t5\/Microsoft-Flow-Community\/ct-p\/FlowCommunity\">Flow Community <\/a>member Courtenay from Parserr.com. This tutorial highlights how the recently added <a href=\"https:\/\/preview.flow.microsoft.com\/en-us\/connectors\/shared_parserr\/parserr\/\">Parserr connector<\/a> can be used with Microsoft Flow. Let&#8217;s begin.<\/em><\/p>\n<p>Hi there, Courtenay from Parserr.com here &#8211; let\u2019s jump straight into it!<\/p>\n<p>Parerr is an easy connector for Microsoft Flow that allows you to easily extract email (and attachment) data and send it directly to the application that actually needs it.<\/p>\n<p>In the steps outline below, we will show you how to select the exact data you need from your email body and add it straight into a SharePoint List. However you could take your extracted email data and add it into any one of the 3rd part connectors supported by Microsoft Flow!<\/p>\n<h3>How to Extract Email Data and Send it to a SharePoint List:<\/h3>\n<p>1. Sign up for a\u00a0<a href=\"http:\/\/parserr.com\/#pricing\" rel=\"nofollow noopener noreferrer\" target=\"_blank\" title=\"Email Parser\">free Parserr account<\/a> and confirm your email address:<\/p>\n<p>\u00a0<\/p>\n<li-image align=\"inline\" alt=\"Parserr2.PNG\" height=\"223\" id=\"13422i59AE1E26919660E3\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image><img loading=\"lazy\" decoding=\"async\" height=\"183\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.png\" width=\"493\"\/><\/p>\n<p>\u00a0<\/p>\n<p>2. Click on the confirmation link in the email and login with the details you provided previously. Once logged in, you should be presented with the setup screen. Click the &#8220;Great. Lets get started&#8221; button<\/p>\n<li-image align=\"inline\" alt=\"Parserr3.PNG\" id=\"13423i92BB7479212DE716\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr202.png\"\/><\/p>\n<p>3. The next screen will provide you with your incoming email address. This address is where you will forward all your incoming inquiries that you wish to extract to SharePoint. Go ahead and copy the email address provided. Then make sure to forward a <strong>valid inquiry or email you wish to extract <\/strong>and make a note of your unique Parserr inbox (eg. BSB8GEBA@mgparserr.com) as shown below<\/p>\n<p>\u00a0<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr203.png\"\/><\/p>\n<p>\u00a0<\/p>\n<p>4. Once you have forwarded the email to the assigned email address (ending in mg.parserr.com), Parserr will detect the email and then ask you a few onboarding questions. In our case we would like to extract information from the body of the email:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr204.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"Parserr5.PNG\" height=\"209\" id=\"18975i54E499B3124A3971\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image>\n<p>\u00a0<\/p>\n<p>5. Choose &#8220;Microsoft Flow&#8221;.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr205.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"parserr2.PNG\" id=\"16033i4E6A6A5813F7846A\" size=\"large\" sourcetype=\"new\" width=\"599\"><\/li-image>\n<p>6. Next Parserr asks us where we&#8217;d like to extract our data. Choose SharePoint and click &#8220;Finish&#8221;.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr205b.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"SharePoint.PNG\" height=\"149\" id=\"18976iEC7E8B556DF8B055\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image>\n<p>\u00a0<\/p>\n<p>7. Depending on your email, Parserr may be able to automatically set your rules up automatically. In the case below, Parserr has detected that there are some parts of the body that may be able to be auto-extracted. If you don&#8217;t see this screen, not too worry, parsing rules are very simple to setup. Choose the rules you want to setup. If you arent sure if you want the rule, simply create it anyway. You can always delete it later. Click the &#8220;Yes, create the rules I have checked above&#8221; button.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr206.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"Parserr8.PNG\" id=\"13428iCAAD06481505BB4A\" size=\"large\" sourcetype=\"new\" width=\"599\"><\/li-image>\n<p>\u00a0<\/p>\n<p>8. Next, you will have the option to create further rules, or if you have no rules yet, an option to create a rules. Creating rules is really easy once you get the hang of it. The idea is to &#8220;chain&#8221; a number of steps together to extract the content you need. For instance in my rule for &#8220;First Name&#8221; above, the following steps happened:<\/p>\n<p>a) Step 1: Get row containing text &#8220;First Name&#8221;: This gets me the row in the body of the email that contains that phrase, First Name<\/p>\n<p>b) Step 2: Search &amp; replace: So simply remove the part, &#8220;First Name&#8221; so i can end up with the value that I need:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr207.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"Parserr9.PNG\" id=\"13429i050B9B0E3A19ACD5\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image>\n<p>Give your rule a name and click &#8220;Save&#8221;.<\/p>\n<div class=\"video-embed-center video-embed\">\u00a0<\/div>\n<p>9. Once you have your rules sorted, go have a look at your parsing results. You do this by clicking on <a href=\"https:\/\/parserr.com\/account\/incomingemails\" rel=\"nofollow noopener noreferrer\" target=\"_self\" title=\"Email parser\">&#8220;incoming emails&#8221;<\/a> in the left navigation and click the small arrow icon to open your first email:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr208.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"Parserr10.PNG\" id=\"13430i71543E8520A461A7\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image>\n<p>\u00a0<\/p>\n<p>10. Now its time to jump into Microsoft Flow and connect Parserr to SharePoint! Choose to create a new Flow and choose the Parserr connector and the trigger &#8220;Parserr &#8211; When an email is received&#8221;.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr209.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"Parserr11.PNG\" id=\"13431i13BE5FCEB2B65688\" size=\"large\" sourcetype=\"new\" width=\"539\"><\/li-image>\n<li-image align=\"inline\" alt=\"Parserr12.PNG\" id=\"13432i7D0B21980459E055\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr2010.png\"\/><\/p>\n<p>14. Next you will be prompted to add your username and password for Parserr. Please use the same username and password as would when you login to Parserr. This step needs to be 100% correct or the integration will not work correctly.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr2011.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"Parserr13.PNG\" id=\"13433i99E3C77F6FDAE989\" size=\"large\" sourcetype=\"new\" width=\"599\"><\/li-image>\n<p>\u00a0<\/p>\n<p>15. If you are connected properly to Parserr (previous step), you will see your Parserr email address appear in the trigger step. If you don&#8217;t see a value, don&#8217;t add your own custom value. This means your username and password were incorrect previously. Go back a step and try and edit your connection (username and password) to Parserr:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr2012.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"Parserr14.PNG\" id=\"13434i3B2B2AAF4D2AC0B6\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image>\n<p>\u00a0<\/p>\n<p>16. Click &#8220;New step&#8221; and then click &#8220;Add an action&#8221; as shown below:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr2013.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"Parserr15.PNG\" id=\"13435i965E58BD19CBD614\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image>\n<p>\u00a0<\/p>\n<p>17. Choose SharePoint and &#8220;Create Item&#8221; as your action.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr2014.png\"\/><\/p>\n<p>\u00a0<\/p>\n<p>18. For this example, we will add the rule we created in Parserr, &#8220;First Name&#8221;, as the &#8220;Title&#8221; field in SharePoint (Site address has been obfuscated for this example). The &#8220;Dynamic content&#8221; box shown on the right of the screen represents the rules created in Parserr and are available to be used as fields within your SharePoint columns. This is how we map Parserr extracted email data to SharePoint<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr2015.png\"\/><\/p>\n<p>19. Once you are complete, save your Flow. You should now be ready to test the entire process. Exciting! Firstly send through a new email to your Parserr email address (eg. 43HGH43@mg.parserr.com). Then check your <a href=\"https:\/\/parserr.com\/account\/incomingemails\" target=\"_self\" rel=\"noopener\">Parserr incoming emails<\/a> to see that Parserr has received the email and that the data has been sent to Flow (under Flow Data)<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr2016.png\"\/><\/p>\n<li-image align=\"inline\" alt=\"SharePoint3.PNG\" height=\"49\" id=\"18979i66DA3BD7F2445BB8\" size=\"large\" sourcetype=\"new\" width=\"600\"><\/li-image>\n<p>If you don&#8217;t see the &#8220;Flow data&#8221; this means the data has not been sent to Flow. To resolve this, check that your Flow has been saved and that you have followed the steps correctly above.<\/p>\n<p>\u00a0<\/p>\n<p>If you do see the &#8220;Flow data&#8221; tab, this means that the data has been sent successfully to Flow. If you load up your <a href=\"https:\/\/flow.microsoft.com\/manage\/environments\/\" target=\"_self\" rel=\"noopener\">Flow dashboard<\/a>, you should see some successful runs of your new flow:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr2017.png\"\/><\/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 <a href=\"https:\/\/powerusers.microsoft.com\/t5\/Microsoft-Flow-Community\/ct-p\/FlowCommunity\">Flow Community<\/a>!<\/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\/\" style=\"background-color: transparent; border-bottom-color: rgb(95, 151, 175); border-bottom-style: none; border-bottom-width: 0px; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; border-left-color: rgb(95, 151, 175); border-left-style: none; border-left-width: 0px; border-right-color: rgb(95, 151, 175); border-right-style: none; border-right-width: 0px; border-top-color: rgb(95, 151, 175); border-top-style: none; border-top-width: 0px; color: rgb(95, 151, 175); font-family: Tahoma,&amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; outline-color: invert; outline-style: none; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; vertical-align: baseline; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;\">Use This Flow<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to share today&#8217;s Flow of the Week co-authored by Courtenay from Parserr.com. In this tutorial, she walks us through how to use Microsoft Flow to extract email (and attachment) data and send it directly to a SharePoint list. Our Flow community is constantly innovating on how they use Flow to solve their business needs.<\/p>\n","protected":false},"author":130,"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":[2370],"class_list":["post-110937","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: How to Extract Email Data and Send to SharePoint List - 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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/\" \/>\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: How to Extract Email Data and Send to SharePoint List - 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 Courtenay from Parserr.com. In this tutorial, she walks us through how to use Microsoft Flow to extract email (and attachment) data and send it directly to a SharePoint list. Our Flow community is 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\/how-to-extract-email-data-and-send-to-sharepoint-list\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-07T14:24:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:09:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.png\" \/>\n<meta name=\"author\" content=\"Anh-Thu Chang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Anh-Thu Chang\" \/>\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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/anh-thu-chang\/\",\"@type\":\"Person\",\"@name\":\"Anh-Thu Chang\"}],\"headline\":\"Beginner | Flow of the Week: How to Extract Email Data and Send to SharePoint List\",\"datePublished\":\"2018-02-07T14:24:21+00:00\",\"dateModified\":\"2025-06-11T15:09:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/\"},\"wordCount\":995,\"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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/\",\"name\":\"Beginner | Flow of the Week: How to Extract Email Data and Send to SharePoint List - 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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.png\",\"datePublished\":\"2018-02-07T14:24:21+00:00\",\"dateModified\":\"2025-06-11T15:09:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#primaryimage\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.webp\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.webp\",\"width\":600,\"height\":223,\"caption\":\"graphical user interface, text, application, email\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#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: How to Extract Email Data and Send to SharePoint List\"}]},{\"@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\/832bd9200f8a84b566e8275b1f6cd2f2\",\"name\":\"Anh-Thu Chang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/7a9127d56ce7a663ceb020ce0454a54d41d09a3273474fc5f3cc1bf1434b1242?s=96&d=mm&r=gc57cb99285759871819b517e03e284f2\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7a9127d56ce7a663ceb020ce0454a54d41d09a3273474fc5f3cc1bf1434b1242?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7a9127d56ce7a663ceb020ce0454a54d41d09a3273474fc5f3cc1bf1434b1242?s=96&d=mm&r=g\",\"caption\":\"Anh-Thu Chang\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/v-thuch\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Beginner | Flow of the Week: How to Extract Email Data and Send to SharePoint List - 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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/","og_locale":"en_US","og_type":"article","og_title":"Beginner | Flow of the Week: How to Extract Email Data and Send to SharePoint List - Microsoft Power Platform Blog","og_description":"We are excited to share today's Flow of the Week co-authored by Courtenay from Parserr.com. In this tutorial, she walks us through how to use Microsoft Flow to extract email (and attachment) data and send it directly to a SharePoint list. Our Flow community is 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\/how-to-extract-email-data-and-send-to-sharepoint-list\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2018-02-07T14:24:21+00:00","article_modified_time":"2025-06-11T15:09:47+00:00","og_image":[{"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.png","type":"","width":"","height":""}],"author":"Anh-Thu Chang","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Anh-Thu Chang","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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/anh-thu-chang\/","@type":"Person","@name":"Anh-Thu Chang"}],"headline":"Beginner | Flow of the Week: How to Extract Email Data and Send to SharePoint List","datePublished":"2018-02-07T14:24:21+00:00","dateModified":"2025-06-11T15:09:47+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/"},"wordCount":995,"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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/","name":"Beginner | Flow of the Week: How to Extract Email Data and Send to SharePoint List - 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\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.png","datePublished":"2018-02-07T14:24:21+00:00","dateModified":"2025-06-11T15:09:47+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#primaryimage","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.webp","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Parserr201.webp","width":600,"height":223,"caption":"graphical user interface, text, application, email"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/07\/how-to-extract-email-data-and-send-to-sharepoint-list\/#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: How to Extract Email Data and Send to SharePoint List"}]},{"@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\/832bd9200f8a84b566e8275b1f6cd2f2","name":"Anh-Thu Chang","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7a9127d56ce7a663ceb020ce0454a54d41d09a3273474fc5f3cc1bf1434b1242?s=96&d=mm&r=gc57cb99285759871819b517e03e284f2","url":"https:\/\/secure.gravatar.com\/avatar\/7a9127d56ce7a663ceb020ce0454a54d41d09a3273474fc5f3cc1bf1434b1242?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7a9127d56ce7a663ceb020ce0454a54d41d09a3273474fc5f3cc1bf1434b1242?s=96&d=mm&r=g","caption":"Anh-Thu Chang"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/v-thuch\/"}]}},"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\/110937","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\/130"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110937"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110937\/revisions"}],"predecessor-version":[{"id":131112,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110937\/revisions\/131112"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110937"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=110937"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=110937"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=110937"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=110937"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=110937"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=110937"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}