{"id":857,"date":"2025-09-11T01:18:59","date_gmt":"2025-09-11T01:18:59","guid":{"rendered":"https:\/\/www.techpolaju.com\/blog\/?p=857"},"modified":"2025-09-11T01:37:26","modified_gmt":"2025-09-11T01:37:26","slug":"populate-word-document","status":"publish","type":"post","link":"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/","title":{"rendered":"4 Easy Steps \u2013 Populate Word Document Without Premium License"},"content":{"rendered":"\n<p>This tutorial shows the easiest way to create personalized Word documents and automatically send them without paying for premium connectors. Using Power Automate, SharePoint, and Excel, you can streamline your onboarding emails completely free with standard licenses, while learning how to populate Word documents efficiently.\u201d<\/p>\n\n\n\n<p>This guide walks you step-by-step through building the flow.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"667\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-15-1024x667.png\" alt=\"Populate Word Document\" class=\"wp-image-900\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-15-1024x667.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-15-300x195.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-15-768x500.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-15.png 1178w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%F0%9F%9A%80_What_Youll_Achieve\" >\ud83d\ude80 What You\u2019ll Achieve<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%F0%9F%A7%B0_Prerequisites\" >\ud83e\uddf0 Prerequisites<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%F0%9F%A7%B1_Step-by-Step_Create_Word_Excel_Files_and_Build_the_Flow\" >\ud83e\uddf1 Step-by-Step: Create Word &amp; Excel Files and Build the Flow<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%F0%9F%94%B9_Step_1_Prepare_SharePoint_Library\" >\ud83d\udd39 Step 1: Prepare SharePoint Library<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%F0%9F%94%B9_Step_2_Create_a_Word_Template\" >\ud83d\udd39 Step 2: Create a Word Template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%F0%9F%94%B9_Step_3_Create_an_Excel_File\" >\ud83d\udd39 Step 3: Create an Excel File<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%F0%9F%94%B9_Step_4_Create_the_Scheduled_Flow\" >\ud83d\udd39 Step 4: Create the Scheduled Flow<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#Configure_the_trigger\" >Configure the trigger<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#Add_the_following_actions\" >Add the following actions:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#Action_1_List_rows_present_in_a_table\" >Action 1: List rows present in a table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#Action_2_Get_file_content_using_path\" >Action 2: Get file content using path<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#Action_3_Create_file\" >Action 3: Create file<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#Action_4_Update_file_properties\" >Action 4: Update file properties<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#Action_5_Get_file_content\" >Action 5: Get file content<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#Action_6_Send_an_email_V2\" >Action 6: Send an email (V2)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#Action_7_Update_a_row\" >Action 7: Update a row<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%E2%9C%85_Result\" >\u2705 Result<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%F0%9F%92%A1_Bonus_Tips\" >\ud83d\udca1 Bonus Tips<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/#%F0%9F%94%97_Bonus_Resources\" >\ud83d\udd17\u00a0Bonus Resources<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%9A%80_What_Youll_Achieve\"><\/span>\ud83d\ude80 What You\u2019ll Achieve<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>With this Populate Word Document tutorial, you\u2019ll be able to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a Word template with dynamic placeholders<\/li>\n\n\n\n<li>Pull employee data from an Excel file stored in SharePoint<\/li>\n\n\n\n<li>Automatically generate Word files for each new employee<\/li>\n\n\n\n<li>Send personalized welcome emails with attached Word documents<\/li>\n\n\n\n<li>Update Excel to mark \u201cSent\u201d<\/li>\n<\/ul>\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%A7%B0_Prerequisites\"><\/span>\ud83e\uddf0 Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Microsoft 365 account with Power Automate<\/li>\n\n\n\n<li>SharePoint document library<\/li>\n\n\n\n<li>Excel file with employee data<\/li>\n\n\n\n<li>Word template with Quick Parts placeholders<\/li>\n<\/ul>\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%A7%B1_Step-by-Step_Create_Word_Excel_Files_and_Build_the_Flow\"><\/span>\ud83e\uddf1 Step-by-Step: Create Word &amp; Excel Files and Build the Flow<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%B9_Step_1_Prepare_SharePoint_Library\"><\/span>\ud83d\udd39 Step 1: Prepare SharePoint Library<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to <a href=\"https:\/\/m365.cloud.microsoft\/apps\" target=\"_blank\" rel=\"noopener\">Microsoft 365 Apps<\/a>.<\/li>\n\n\n\n<li>Open <strong>SharePoint<\/strong> &gt; <strong>gear icon<\/strong> (top-right) &gt; <strong>Site contents<\/strong>.<\/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=\"265\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-1024x265.png\" alt=\"Microsoft 365 Apps\" class=\"wp-image-860\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-1024x265.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-300x78.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-768x199.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image.png 1317w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"598\" height=\"334\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-1.png\" alt=\"SharePoint Site contents\" class=\"wp-image-861\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-1.png 598w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-1-300x168.png 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<ul start=\"3\" class=\"wp-block-list\">\n<li>Open your <strong>Documents<\/strong> library or create a new one.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"550\" height=\"232\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-2.png\" alt=\"SharePoint Document Library\" class=\"wp-image-862\" style=\"width:541px;height:auto\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-2.png 550w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-2-300x127.png 300w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<ul start=\"4\" class=\"wp-block-list\">\n<li>Add two custom columns-you can add more depending on your template\u2019s dynamic data:\n<ul class=\"wp-block-list\">\n<li><strong>Employee Name<\/strong><\/li>\n\n\n\n<li><strong>Employee Email<\/strong><\/li>\n<\/ul>\n<\/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=\"598\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-1024x598.png\" alt=\"SharePoint Document Library\" class=\"wp-image-865\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-1024x598.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-300x175.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-768x448.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-3-1536x897.png 1536w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-3.png 1540w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%B9_Step_2_Create_a_Word_Template\"><\/span>\ud83d\udd39 Step 2: Create a Word Template<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click <strong>New &gt; Word Document<\/strong> in your library.<\/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=\"274\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-4-1024x274.png\" alt=\"New Word document\" class=\"wp-image-866\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-4-1024x274.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-4-300x80.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-4-768x205.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-4.png 1394w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the new document, click <strong>Editing<\/strong> (top-left) &gt; <strong>Open in Desktop<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"206\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-1024x206.png\" alt=\"Editing word document\" class=\"wp-image-867\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-1024x206.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-300x60.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-768x155.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-5-1536x309.png 1536w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-5.png 1907w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add your welcome message, then place your cursor where you want to insert the custom column values..<\/li>\n\n\n\n<li>Insert placeholders: <strong>Insert > Quick Parts > Document Property<\/strong> > select custom columns.<\/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=\"444\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-1024x444.png\" alt=\"Word document Quick Parts\" class=\"wp-image-868\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-1024x444.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-300x130.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-768x333.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-6-1536x666.png 1536w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-6.png 1901w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After adding both columns, rename the file \u2018Welcome Template\u2019 and then close it.<\/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=\"543\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-7-1024x543.png\" alt=\"Word document rename\" class=\"wp-image-869\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-7-1024x543.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-7-300x159.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-7-768x408.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-7-1536x815.png 1536w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-7.png 1585w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%B9_Step_3_Create_an_Excel_File\"><\/span>\ud83d\udd39 Step 3: Create an Excel File<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Return to your SharePoint library and click New > Excel Workbook in the same location.<\/li>\n\n\n\n<li>Add a table with columns:\n<ul class=\"wp-block-list\">\n<li><strong>Employee Name<\/strong><\/li>\n\n\n\n<li><strong>Employee Email<\/strong><\/li>\n\n\n\n<li><strong>Email_Sent<\/strong> (avoid spaces in the column name-use an underscore or write it as a single word)<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"386\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-8-1024x386.png\" alt=\"Excel workbook\" class=\"wp-image-870\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-8-1024x386.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-8-300x113.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-8-768x289.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-8.png 1083w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%B9_Step_4_Create_the_Scheduled_Flow\"><\/span>\ud83d\udd39 Step 4: Create the Scheduled Flow<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to <a href=\"https:\/\/make.powerautomate.com\" target=\"_blank\" rel=\"noopener\">Power Automate<\/a> > <strong>Create > Scheduled Cloud Flow<\/strong>.<\/li>\n\n\n\n<li>Flow Name: <strong>Welcome Emails<\/strong><\/li>\n\n\n\n<li>Click on &#8220;Create&#8221; button<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Configure_the_trigger\"><\/span>Configure the trigger<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Frequency: Select Day.<\/li>\n\n\n\n<li>Time zone: Choose your own time zone; otherwise, the flow will run according to UTC.<\/li>\n\n\n\n<li>At these hours: Enter the hour you want the flow to run.<\/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=\"657\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-9-1024x657.png\" alt=\"Scheduled Cloud Flow\" class=\"wp-image-872\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-9-1024x657.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-9-300x192.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-9-768x492.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-9.png 1045w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Add_the_following_actions\"><\/span>Add the following actions:<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Action_1_List_rows_present_in_a_table\"><\/span><strong>Action 1: List rows present in a table<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<p>Use this action to retrieve employee names and email addresses from the table in your Excel file.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Location: Select the SharePoint site where you\u2019ve saved the Excel file.<\/li>\n\n\n\n<li>Document Library: Choose the document library where the Excel file is stored.<\/li>\n\n\n\n<li>File: Click the folder icon and select the Excel file.<\/li>\n\n\n\n<li>Table: From the dropdown, select the name of the table inside your Excel file.<\/li>\n\n\n\n<li>Filter Query: Enter the following filter query to ensure only rows where the email has not yet been sent are picked up:<br><code>Email_Sent eq ''<\/code><br>(This uses the Email_Sent column to check whether the email has already been sent. After the flow sends an email, it will update this column\u2019s value to \u201cSent.\u201d)<\/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=\"792\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-10-1024x792.png\" alt=\"List rows present in a table\" class=\"wp-image-880\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-10-1024x792.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-10-300x232.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-10-768x594.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-10.png 1091w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Action_2_Get_file_content_using_path\"><\/span><strong>Action 2: Get file content using path<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<p>This action retrieves the content of the Word template file.<br>You\u2019ll use this content in the next action to create a new Word file for each record.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Site Address: Select the SharePoint site where your Word template file is saved.<\/li>\n\n\n\n<li><strong>File Path:<\/strong> Click the folder icon and select the Word template file.<br><strong>Note:<\/strong> If your template file is in the <strong>Documents<\/strong> library, it may appear as <strong>Shared Documents<\/strong> here. This is because <strong>Shared Documents<\/strong> is the internal name of the library.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"421\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-11-1024x421.png\" alt=\"Get file content using path\" class=\"wp-image-882\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-11-1024x421.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-11-300x123.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-11-768x316.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-11.png 1027w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Action_3_Create_file\"><\/span><strong>Action 3: Create file<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<p>Use this action to generate a new Word file by using the output content from the previous action.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Site Address:<\/strong> Select the SharePoint site where you want to save the new file.<\/li>\n\n\n\n<li><strong>Folder Path:<\/strong> Choose the document library in the selected SharePoint site where the new Word file should be saved.<\/li>\n\n\n\n<li><strong>File Name:<\/strong> Enter <code>Welcome-Doc-.docx<\/code>. Place your cursor before <code>.docx<\/code> and insert <strong>Employee Name<\/strong> from the dynamic content list by clicking the flash icon. Select <strong>Employee Name<\/strong> under the action <strong>List rows present in a table<\/strong>. If it\u2019s not listed, type <code>Employee Name<\/code> in the search field to find it. <br>\ud83d\udca1Once the dynamic content <strong>Employee Name<\/strong> is selected, Power Automate will automatically wrap the action inside a <strong>For each<\/strong> loop.<\/li>\n\n\n\n<li><strong>File Content:<\/strong> Click the flash icon and select <strong>File Content<\/strong> from the dynamic content list under the action <strong>Get file content using path<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"456\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-12-1024x456.png\" alt=\"Create file\" class=\"wp-image-895\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-12-1024x456.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-12-300x134.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-12-768x342.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-12.png 1026w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Action_4_Update_file_properties\"><\/span><strong>Action 4: Update file properties<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<p>Use this action to add <strong>Employee Name<\/strong> and <strong>Employee Email<\/strong> from the Excel file into the corresponding SharePoint library columns for the new document, ensuring these values are correctly reflected inside the Word document.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Site Address:<\/strong> Select the SharePoint site where you saved the new file in the previous <strong>Create file<\/strong> action.<\/li>\n\n\n\n<li><strong>Library Name:<\/strong> Choose the document library in that SharePoint site where the new file was saved.<\/li>\n\n\n\n<li><strong>Id:<\/strong> From the dynamic content list, click the flash icon and select <strong>body\/ItemId<\/strong> under the <strong>Create file<\/strong> action.<\/li>\n\n\n\n<li><strong>Advanced Parameters:<\/strong> Expand this section and check both <strong>Employee Name<\/strong> and <strong>Employee Email<\/strong> to populate these values for the new document.<\/li>\n\n\n\n<li>Employee Name: Insert <strong>Employee Name<\/strong> from the dynamic content list by clicking the flash icon. Select <strong>Employee Name<\/strong> under the action <strong>List rows present in a table<\/strong>. If it\u2019s not listed, type <code>Employee Name<\/code> in the search field to find it.<\/li>\n\n\n\n<li>Employee Email: Insert <strong>Employee Email<\/strong> from the dynamic content list by clicking the flash icon. Select <strong>Employee Email<\/strong> under the action <strong>List rows present in a table<\/strong>. If it\u2019s not listed, type <code>Employee Email<\/code> in the search field to find it.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1025\" height=\"720\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-13.png\" alt=\"Update file properties\" class=\"wp-image-897\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-13.png 1025w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-13-300x211.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-13-768x539.png 768w\" sizes=\"auto, (max-width: 1025px) 100vw, 1025px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Action_5_Get_file_content\"><\/span><strong>Action 5: Get file content<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<p>Use this action to retrieve the newly updated Word file. It will return the Word document with all values populated from the Excel table.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Site Address: Select the SharePoint site where you saved the new word file<\/li>\n\n\n\n<li>File Identifier: From the dynamic content list, click the flash icon and select <strong>body\/Id<\/strong> under the <strong>Create file<\/strong> action<\/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=\"508\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-14-1024x508.png\" alt=\"Get file content\" class=\"wp-image-899\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-14-1024x508.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-14-300x149.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-14-768x381.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-14.png 1032w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Action_6_Send_an_email_V2\"><\/span><strong>Action 6: Send an email (V2)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<p>Use this action to send an email with the newly created Word document attached. The document will include all values populated dynamically from the Excel table.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the gear icon above the right side of the <strong>To<\/strong> field, then select <strong>Use dynamic content<\/strong>.<\/li>\n\n\n\n<li>To: Insert <strong>Employee Email<\/strong> from the dynamic content list by clicking the flash icon. Select <strong>Employee Email<\/strong> under the action <strong>List rows present in a table<\/strong>. If it\u2019s not listed, type <code>Employee Email<\/code> in the search field to find it.<\/li>\n\n\n\n<li>Subject: Enter a subject line for the email, for example, <code>\"Welcome Email\"<\/code><\/li>\n\n\n\n<li>Body: Enter the email text and insert dynamic content as shown in the image below<\/li>\n\n\n\n<li>Attachments: Click on <strong>Advanced parameters<\/strong> and enable <strong>Attachments<\/strong> to reveal the attachments field. <br>Click <strong>Add new item<\/strong> and configure as follows:\n<ul class=\"wp-block-list\">\n<li>Name &#8211; 1: Enter <code>Welcome-Doc-.docx<\/code>. Place your cursor before <code>.docx<\/code> and insert <strong>Employee Name<\/strong> from the dynamic content list by clicking the flash icon. Select <strong>Employee Name<\/strong> under the action <strong>List rows present in a table<\/strong>. If it\u2019s not listed, type <code>Employee Name<\/code> in the search field to find it. <\/li>\n\n\n\n<li>Content &#8211; 1: Insert <strong>File Content<\/strong> from the previous action <strong>Get file content<\/strong> by selecting it from the dynamic content list using the flash icon.<\/li>\n<\/ul>\n<\/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=\"789\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-16-1024x789.png\" alt=\"Send an email (V2)\" class=\"wp-image-902\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-16-1024x789.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-16-300x231.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-16-768x592.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-16.png 1027w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Action_7_Update_a_row\"><\/span><strong>Action 7: Update a row<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<p>Use this action to update the <strong>Email_Sent<\/strong> column for the employee who has already received the email. This ensures the flow won\u2019t send a duplicate email the next time it runs.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Location: Select the SharePoint site where you\u2019ve saved the Excel file.<\/li>\n\n\n\n<li>Document Library: Choose the document library where the Excel file is stored.<\/li>\n\n\n\n<li>File: Click the folder icon and select the Excel file.<\/li>\n\n\n\n<li>Table: From the dropdown, select the name of the table inside your Excel file.<\/li>\n\n\n\n<li>Key Column: Select &#8220;Employee Email&#8221;<\/li>\n\n\n\n<li>Key Value: insert <strong>Employee Name<\/strong> from the dynamic content list by clicking the flash icon. Select <strong>Employee Name<\/strong> under the action <strong>List rows present in a table<\/strong>. If it\u2019s not listed, type <code>Employee Name<\/code> in the search field to find it. <\/li>\n\n\n\n<li>Email_Sent: Write &#8220;<code>Sent<\/code>&#8221; there in this field<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"996\" height=\"807\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-17.png\" alt=\"Update a row\" class=\"wp-image-904\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-17.png 996w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-17-300x243.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/09\/image-17-768x622.png 768w\" sizes=\"auto, (max-width: 996px) 100vw, 996px\" \/><\/figure><\/div>\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=\"%E2%9C%85_Result\"><\/span>\u2705 Result<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>After running this flow, Power Automate will <strong>populate Word document <\/strong>without a premium license, automatically email them to each employee, and update your Excel sheet to mark the documents as \u2018Sent.\u2019<\/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%92%A1_Bonus_Tips\"><\/span>\ud83d\udca1 Bonus Tips<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use filters to avoid unnecessary flow runs.<\/li>\n\n\n\n<li>Archive old files in SharePoint to keep your flow fast.<\/li>\n\n\n\n<li>Test with a single row before applying to all employees to ensure your <strong>Populate Word Document <\/strong>setup works correctly.<\/li>\n<\/ul>\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%94%97_Bonus_Resources\"><\/span>\ud83d\udd17\u00a0Bonus Resources<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\/automate-email-to-task\/\">\ud83d\udd04\u00a0Effortless 8-Step Power Automate Email to Task flow Guide<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/power-automate-email-export-in-5-steps\/\">\ud83d\udd04\u00a0Effortless Power Automate Email Export in 5 Steps<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/important-email-alert\/\">\ud83d\udd045 Easy Steps to Create a Power Automate Important Email Alert for Smarter Workflows<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial shows the easiest way to create personalized Word documents and automatically send them without paying for premium connectors. Using Power Automate, SharePoint, and Excel, you can streamline your onboarding emails completely free with standard licenses, while learning how to populate Word documents efficiently.\u201d This guide walks you step-by-step through building the flow. \ud83d\ude80 &#8230; <a title=\"4 Easy Steps \u2013 Populate Word Document Without Premium License\" class=\"read-more\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/populate-word-document\/\" aria-label=\"Read more about 4 Easy Steps \u2013 Populate Word Document Without Premium License\">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-857","post","type-post","status-publish","format-standard","hentry","category-power-automate"],"_links":{"self":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/857","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=857"}],"version-history":[{"count":30,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/857\/revisions"}],"predecessor-version":[{"id":911,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/857\/revisions\/911"}],"wp:attachment":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/media?parent=857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/categories?post=857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/tags?post=857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}