{"id":977,"date":"2025-10-07T10:17:58","date_gmt":"2025-10-07T10:17:58","guid":{"rendered":"https:\/\/www.techpolaju.com\/blog\/?p=977"},"modified":"2025-10-07T10:18:00","modified_gmt":"2025-10-07T10:18:00","slug":"automate-invoice-email","status":"publish","type":"post","link":"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/","title":{"rendered":"\ud83d\udca1 5 Easy Steps to Automate Invoice Email to SharePoint"},"content":{"rendered":"\n<p>If you regularly receive invoices via email, manually downloading attachments and uploading them to SharePoint can be tedious and error-prone. In this beginner-friendly tutorial, you\u2019ll learn how to Automate Invoice Email to SharePoint using Power Automate to save time, reduce effort, and boost accuracy.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"913\" height=\"770\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-12.png\" alt=\"Automate Invoice Email to SharePoint\" class=\"wp-image-988\" style=\"width:567px;height:auto\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-12.png 913w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-12-300x253.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-12-768x648.png 768w\" sizes=\"auto, (max-width: 913px) 100vw, 913px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#%F0%9F%93%84_Use_Case_Overview\" >\ud83d\udcc4 Use Case Overview<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#%F0%9F%8E%AF_What_Youll_Learn\" >\ud83c\udfaf What You\u2019ll Learn<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#%F0%9F%A7%B0_Prerequisites\" >\ud83e\uddf0 Prerequisites<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#%F0%9F%AA%84_Step-by-Step_Automate_Invoice_Email_to_SharePoint\" >\ud83e\ude84 Step-by-Step: Automate Invoice Email to SharePoint<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#Step_1%EF%B8%8F%E2%83%A3_Create_a_New_Flow\" >Step 1\ufe0f\u20e3: Create a New Flow<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#Step_2%EF%B8%8F%E2%83%A3_Configure_the_Trigger\" >Step 2\ufe0f\u20e3: Configure the Trigger<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#Step_3%EF%B8%8F%E2%83%A3_Add_%E2%80%9CRun_a_Prompt%E2%80%9D_Action\" >Step 3\ufe0f\u20e3: Add \u201cRun a Prompt\u201d Action<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#Step_4%EF%B8%8F%E2%83%A3_Parse_the_JSON_Output\" >Step 4\ufe0f\u20e3: Parse the JSON Output<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#Step_5%EF%B8%8F%E2%83%A3_Create_SharePoint_Item_and_Add_Attachment\" >Step 5\ufe0f\u20e3: Create SharePoint Item and Add Attachment<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#_Conclusion\" >&nbsp;Conclusion<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/#%F0%9F%9A%80_Bonus\" >\ud83d\ude80\u00a0Bonus<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%84_Use_Case_Overview\"><\/span><strong>\ud83d\udcc4 Use Case Overview<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This automation flow will detect new invoice emails in your Outlook inbox, extract key invoice details using AI, and create a SharePoint list item with the attached invoice included.<\/p>\n\n\n\n<p><strong>Example scenario:<\/strong><br>\ud83d\udce5 Vendor sends an email with subject line <strong>\u201cInvoice\u201d<\/strong><br>\ud83e\udd16 Flow runs automatically, extracts details such as <strong>Amount<\/strong>, <strong>Date<\/strong>, <strong>Client Name<\/strong>, and <strong>Summary<\/strong><br>\ud83d\udcca A new item is created in your <strong>Invoices<\/strong> SharePoint list<br>\ud83d\udcce The original invoice file is added as an attachment<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"607\" height=\"652\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-1.png\" alt=\"\" class=\"wp-image-978\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-1.png 607w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-1-279x300.png 279w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\">\ud83d\udcf8 <em>Screenshot: Example of invoice email in Outlook<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%8E%AF_What_Youll_Learn\"><\/span><strong>\ud83c\udfaf What You\u2019ll Learn<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>By the end of this tutorial, you\u2019ll be able to:<br>\u2705 Use the <strong>When a new email arrives (V3)<\/strong> trigger efficiently<br>\u2705 Apply <strong>AI prompts<\/strong> to extract invoice data automatically<br>\u2705 Parse structured data using <strong>Parse JSON<\/strong><br>\u2705 Create SharePoint list items and attach files<br>\u2705 Optimize your flow using <strong>Include Attachments<\/strong> and <strong>Only with Attachments<\/strong> options<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%A7%B0_Prerequisites\"><\/span><strong>\ud83e\uddf0 Prerequisites<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Before you begin, make sure you have:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A <strong>Microsoft 365<\/strong> account with access to Power Automate<\/li>\n\n\n\n<li>A <strong>SharePoint site<\/strong> with a list named <strong>Invoices<\/strong>\n<ul class=\"wp-block-list\">\n<li>Columns: <strong>Amount<\/strong>, <strong>Date<\/strong>, <strong>Client Name<\/strong>, <strong>Summary<\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>An <strong>Outlook mailbox<\/strong> that receives invoice emails with attachments<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"550\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-5-1024x550.png\" alt=\"\" class=\"wp-image-979\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-5-1024x550.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-5-300x161.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-5-768x413.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-5.png 1122w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\">\ud83d\udcf8 <em>Screenshot: Invoices list in SharePoint with columns<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%AA%84_Step-by-Step_Automate_Invoice_Email_to_SharePoint\"><\/span><strong>\ud83e\ude84 Step-by-Step: Automate Invoice Email to SharePoint<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_1%EF%B8%8F%E2%83%A3_Create_a_New_Flow\"><\/span><strong>Step 1\ufe0f\u20e3: Create a New Flow<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to <a href=\"https:\/\/make.powerautomate.com\" target=\"_blank\" rel=\"noopener\">make.powerautomate.com<\/a><\/li>\n\n\n\n<li>Click <strong>Create > Automated cloud flow<\/strong><\/li>\n\n\n\n<li>Name your flow <strong>Invoice Processing<\/strong><\/li>\n\n\n\n<li>Choose the trigger <strong>When a new email arrives (V3)<\/strong><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_2%EF%B8%8F%E2%83%A3_Configure_the_Trigger\"><\/span><strong>Step 2\ufe0f\u20e3: Configure the Trigger<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Set the following options carefully:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Include Attachments:<\/strong> Yes<\/li>\n\n\n\n<li><strong>Only with Attachments:<\/strong> Yes<\/li>\n\n\n\n<li><strong>Subject Filter:<\/strong> Invoice<\/li>\n<\/ul>\n\n\n\n<p>This ensures that the flow runs only for relevant invoice emails that contain attachments.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/07\/image-66.png\" alt=\"\"\/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\">\ud83d\udcf8 <em>Screenshot: Configuring Include Attachments and Only with Attachments<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_3%EF%B8%8F%E2%83%A3_Add_%E2%80%9CRun_a_Prompt%E2%80%9D_Action\"><\/span><strong>Step 3\ufe0f\u20e3: Add \u201cRun a Prompt\u201d Action<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Next, use the <strong>Run a Prompt<\/strong> action to extract invoice data from the attached file using AI.<br>To add a prompt there, click the <strong>Prompt<\/strong> dropdown and select <strong>New Custom Prompt<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"964\" height=\"267\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-6.png\" alt=\"\" class=\"wp-image-981\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-6.png 964w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-6-300x83.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-6-768x213.png 768w\" sizes=\"auto, (max-width: 964px) 100vw, 964px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\">\ud83d\udcf8 <em>Screenshot: Run a prompt configuration<\/em><\/p>\n\n\n\n<p>\ud83e\udde0 <strong>Prompt Example:<\/strong><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>You are tasked with extracting key invoice data from the provided document. The goal is to identify and retrieve specific information accurately to facilitate further processing or analysis.<\/p>\n\n\n\n<p>### Instructions:<\/p>\n\n\n\n<p>1. Carefully analyze the attached invoice document.<\/p>\n\n\n\n<p>2. Extract the following details:<\/p>\n\n\n\n<p>&#8211; **Amount**: The total monetary value stated on the invoice.<\/p>\n\n\n\n<p>&#8211; **Date**: The invoice issuance or billing date.<\/p>\n\n\n\n<p>&#8211; **Client Name**: The name of the individual or organization billed.<\/p>\n\n\n\n<p>&#8211; **Summary**: A brief description or overview of the invoice contents or purpose.<\/p>\n\n\n\n<p>3. Ensure that the extracted data is accurate and corresponds exactly to the information in the document.<\/p>\n\n\n\n<p>4. Present the extracted information in a clear, structured format.<\/p>\n\n\n\n<p>### Output Format:<\/p>\n\n\n\n<p>Provide the values exactly in the given JSON structure below. If any value is missing, return an empty string (&#8220;&#8221;) for that key. Ensure only the top-level keys and their corresponding values are included, with no inner objects or arrays.<\/p>\n\n\n\n<p>&#8220;`json<\/p>\n\n\n\n<p>{<\/p>\n\n\n\n<p>&#8220;Amount&#8221;: &#8220;{extracted amount as a string}&#8221;,<\/p>\n\n\n\n<p>&#8220;Date&#8221;: &#8220;{extracted date as a string}&#8221;,<\/p>\n\n\n\n<p>&#8220;Client Name&#8221;: &#8220;{extracted client name as a string}&#8221;,<\/p>\n\n\n\n<p>&#8220;Summary&#8221;: &#8220;{extracted summary as a string}&#8221;<\/p>\n\n\n\n<p>}<\/p>\n\n\n\n<p>&#8220;`<\/p>\n\n\n\n<p>### Guidelines:<\/p>\n\n\n\n<p>&#8211; Extract only from the provided document; do not infer or add information.<\/p>\n\n\n\n<p>&#8211; If any field is missing or unclear in the document, indicate it with a null value or an empty string.<\/p>\n\n\n\n<p>&#8211; Maintain the original formatting of dates and amounts as found in the document.<\/p>\n\n\n\n<p>Provide the invoice document here:<\/p>\n<\/blockquote>\n\n\n\n<p>Copy the prompt given above into the <strong>Instructions<\/strong> text area. Then place your cursor at the end of the prompt, click <strong>Add content<\/strong>, and select <strong>Image or document<\/strong> to insert the document input placeholder. Finally, click <strong>Save<\/strong>. You can also test the prompt before saving it.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"375\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-7-1024x375.png\" alt=\"\" class=\"wp-image-982\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-7-1024x375.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-7-300x110.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-7-768x281.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-7-1536x562.png 1536w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-7.png 1844w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\">\ud83d\udcf8 <em>Screenshot: Prompt configuration with input document placeholder<\/em><\/p>\n\n\n\n<p>Attach the invoice file from the trigger:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Input File:<\/strong> Attachments Content<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1015\" height=\"477\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-8.png\" alt=\"\" class=\"wp-image-983\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-8.png 1015w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-8-300x141.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-8-768x361.png 768w\" sizes=\"auto, (max-width: 1015px) 100vw, 1015px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\">\ud83d\udcf8 <em>Screenshot: Run a prompt configuration with attachment input<\/em><\/p>\n\n\n\n<p>\ud83d\udca1When you add the attachments content, Power Automate will automatically wrap the action inside a <strong>For each<\/strong> loop.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_4%EF%B8%8F%E2%83%A3_Parse_the_JSON_Output\"><\/span><strong>Step 4\ufe0f\u20e3: Parse the JSON Output<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add a <strong>Parse JSON<\/strong> action to format the AI output.<\/p>\n\n\n\n<p><strong>Content:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>replace(replace(outputs('Run_a_prompt')?&#91;'body\/responsev2\/predictionOutput']?&#91;'text'],'```json',''),'```','')\n<\/code><\/pre>\n\n\n\n<p><strong>Schema:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"type\": \"object\",\n  \"properties\": {\n    \"Amount\": { \"type\": \"string\" },\n    \"Date\": { \"type\": \"string\" },\n    \"Client Name\": { \"type\": \"string\" },\n    \"Summary\": { \"type\": \"string\" }\n  }\n}\n<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1003\" height=\"652\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-9.png\" alt=\"\" class=\"wp-image-984\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-9.png 1003w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-9-300x195.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-9-768x499.png 768w\" sizes=\"auto, (max-width: 1003px) 100vw, 1003px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\">\ud83d\udcf8 <em>Screenshot: Parse JSON action with schema configuration<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_5%EF%B8%8F%E2%83%A3_Create_SharePoint_Item_and_Add_Attachment\"><\/span><strong>Step 5\ufe0f\u20e3: Create SharePoint Item and Add Attachment<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Create Item<\/strong> action\n<ul class=\"wp-block-list\">\n<li><strong>Site Address:<\/strong> Your SharePoint site URL<\/li>\n\n\n\n<li><strong>List Name:<\/strong> Invoices<\/li>\n\n\n\n<li><strong>Amount:<\/strong> From Parse JSON \u2192 Amount<\/li>\n\n\n\n<li><strong>Client Name:<\/strong> From Parse JSON \u2192 Client Name<\/li>\n\n\n\n<li><strong>Date:<\/strong> From Parse JSON \u2192 Date<\/li>\n\n\n\n<li><strong>Summary:<\/strong> From Parse JSON \u2192 Summary<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"984\" height=\"720\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-10.png\" alt=\"\" class=\"wp-image-986\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-10.png 984w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-10-300x220.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-10-768x562.png 768w\" sizes=\"auto, (max-width: 984px) 100vw, 984px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\">\ud83d\udcf8 <em>Screenshot: Create Item actions configured in Power Automate<\/em><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Add Attachment<\/strong> action\n<ul class=\"wp-block-list\">\n<li><strong>Site Address:<\/strong> Same site<\/li>\n\n\n\n<li><strong>List Name:<\/strong> Invoices<\/li>\n\n\n\n<li><strong>Id:<\/strong> From Create Item<\/li>\n\n\n\n<li><strong>File Name:<\/strong> Attachment Name (from trigger)<\/li>\n\n\n\n<li><strong>File Content:<\/strong> Attachment Content (from trigger)<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"666\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-11-1024x666.png\" alt=\"\" class=\"wp-image-987\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-11-1024x666.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-11-300x195.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-11-768x499.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-11.png 1032w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\">\ud83d\udcf8 <em>Screenshot: Add Attachment actions configured in Power Automate<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"_Conclusion\"><\/span><strong>&nbsp;Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Congratulations! You\u2019ve successfully built your first automation to Automate Invoice Email to SharePoint.<br>Now, every invoice email you receive will automatically create a SharePoint record, extract its details, and attach the invoice file &#8211; all hands-free.<\/p>\n\n\n\n<p>Start small, and you\u2019ll soon find Power Automate transforming your daily workflow.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%9A%80_Bonus\"><\/span>\ud83d\ude80\u00a0Bonus<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/substring-function\/\">\ud83d\ude80Ultimate Power Automate Substring Function Explained \u2013 6 Powerful Examples<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/email-attachments-to-teams\/\">\ud83d\ude803 Effortless Steps to Save Email Attachments to Teams<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/ai-draft-reply-flow\/\">\ud83d\ude80Master Power Automate AI Draft Reply Flow in 7 Steps for Effortless Email Replies<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>If you regularly receive invoices via email, manually downloading attachments and uploading them to SharePoint can be tedious and error-prone. In this beginner-friendly tutorial, you\u2019ll learn how to Automate Invoice Email to SharePoint using Power Automate to save time, reduce effort, and boost accuracy. \ud83d\udcc4 Use Case Overview This automation flow will detect new invoice &#8230; <a title=\"\ud83d\udca1 5 Easy Steps to Automate Invoice Email to SharePoint\" class=\"read-more\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/\" aria-label=\"Read more about \ud83d\udca1 5 Easy Steps to Automate Invoice Email to SharePoint\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-977","post","type-post","status-publish","format-standard","hentry","category-power-automate"],"_links":{"self":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/comments?post=977"}],"version-history":[{"count":6,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/977\/revisions"}],"predecessor-version":[{"id":992,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/977\/revisions\/992"}],"wp:attachment":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/media?parent=977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/categories?post=977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/tags?post=977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}