{"id":1003,"date":"2025-10-18T15:18:22","date_gmt":"2025-10-18T15:18:22","guid":{"rendered":"https:\/\/www.techpolaju.com\/blog\/?p=1003"},"modified":"2025-10-18T15:18:26","modified_gmt":"2025-10-18T15:18:26","slug":"contract-renewal-alert","status":"publish","type":"post","link":"https:\/\/www.techpolaju.com\/blog\/power-automate\/contract-renewal-alert\/","title":{"rendered":"\ud83d\udcc5 Powerful Automated Contract Renewal Alert in 11 Steps"},"content":{"rendered":"\n<p>If your organization struggles to keep track of upcoming contract renewals, this tutorial is for you. You\u2019ll learn how to create an Automated Contract Renewal Alert Flow in Power Automate that alerts stakeholders in advance &#8211; preventing missed renewals, penalties, or unwanted auto-renewals.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"574\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-26-1024x574.png\" alt=\"Contract Renewal Alert\" class=\"wp-image-1031\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-26-1024x574.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-26-300x168.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-26-768x431.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-26.png 1419w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\ud83d\ude80 <strong>What You\u2019ll Achieve<\/strong><\/p>\n\n\n\n<p>By the end of this tutorial, your Automated Contract Renewal Alert flow will:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Send reminders 30 days before a contract\u2019s renewal date<\/li>\n\n\n\n<li>Notify the contract owner automatically<\/li>\n\n\n\n<li>Highlight contracts nearing expiry in a SharePoint list<\/li>\n\n\n\n<li>Reduce manual tracking and ensure timely action<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\ud83e\uddf0 <strong>Prerequisites<\/strong><\/p>\n\n\n\n<p>To follow along, you\u2019ll need:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Access to <strong>Microsoft 365 Power Automate<\/strong><\/li>\n\n\n\n<li>A <strong>SharePoint list<\/strong> containing your contracts<\/li>\n\n\n\n<li>Columns such as:\n<ul class=\"wp-block-list\">\n<li><em>Contract Name<\/em><\/li>\n\n\n\n<li><em>Contract Owner<\/em><\/li>\n\n\n\n<li><em>Renewal Date<\/em><\/li>\n\n\n\n<li><em>Reminder Sent <\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\ud83e\uddf1 <strong>Step-by-Step: Create the Automated Contract Renewal Alert<\/strong> <strong>Flow<\/strong><\/p>\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\/contract-renewal-alert\/#%F0%9F%94%B9_Step_1_Prepare_Your_SharePoint_List\" >\ud83d\udd39 Step 1: Prepare Your SharePoint List<\/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\/contract-renewal-alert\/#%F0%9F%94%B9_Step_2_Create_a_Scheduled_Flow\" >\ud83d\udd39 Step 2: Create a Scheduled Flow<\/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\/contract-renewal-alert\/#%F0%9F%94%B9_Step_3_Get_Contracts_from_SharePoint\" >\ud83d\udd39 Step 3: Get Contracts from SharePoint<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/contract-renewal-alert\/#%F0%9F%94%B9_Step_4_Select\" >\ud83d\udd39 Step 4: Select<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/contract-renewal-alert\/#%F0%9F%94%B9_Step_5_Compose\" >\ud83d\udd39 Step 5: Compose<\/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\/contract-renewal-alert\/#%F0%9F%94%B9_Step_6_Initialize_Variable\" >\ud83d\udd39 Step 6: Initialize Variable<\/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\/contract-renewal-alert\/#%F0%9F%94%B9_Step_7_Apply_to_Each_and_Filter_Array\" >\ud83d\udd39 Step 7: Apply to Each and Filter Array<\/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\/contract-renewal-alert\/#%F0%9F%94%B9_Step_8_Create_HTML_table\" >\ud83d\udd39 Step 8: Create HTML table<\/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\/contract-renewal-alert\/#%F0%9F%94%B9_Step_9_Send_Reminder_Emails\" >\ud83d\udd39 Step 9: Send Reminder Emails<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/contract-renewal-alert\/#%F0%9F%94%B9_Step_10_Apply_to_Each_and_Update_item\" >\ud83d\udd39 Step 10: Apply to Each and Update item<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/contract-renewal-alert\/#%F0%9F%94%B9_Step_11_Test_and_Monitor_the_Flow\" >\ud83d\udd39 Step 11: Test and Monitor the Flow<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%B9_Step_1_Prepare_Your_SharePoint_List\"><\/span>\ud83d\udd39 Step 1: Prepare Your SharePoint List<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>In SharePoint, create a list called <strong>Contracts<\/strong> with the following columns:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column Name<\/th><th>Type<\/th><th>Example<\/th><\/tr><\/thead><tbody><tr><td>Contract Name<\/td><td>Single line of text<\/td><td>IT Support Agreement<\/td><\/tr><tr><td>Contract Owner<\/td><td>Person or Group<\/td><td><a href=\"mailto:john@company.com\">john@company.com<\/a><\/td><\/tr><tr><td>Renewal Date<\/td><td>Date<\/td><td>2025-11-15<\/td><\/tr><tr><td>Reminder Sent <\/td><td>Yes\/No<\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Make sure each contract has a renewal date and an assigned owner.<\/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%94%B9_Step_2_Create_a_Scheduled_Flow\"><\/span>\ud83d\udd39 Step 2: Create a Scheduled Flow<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Go to <strong><a href=\"https:\/\/make.powerautomate.com\" data-type=\"link\" data-id=\"https:\/\/make.powerautomate.com\" target=\"_blank\" rel=\"noopener\">make.powerautomate.com<\/a><\/strong> \u2192 <strong>Create<\/strong> \u2192 <strong>Scheduled Cloud Flow<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Flow name: <code>Automated Contract Renewal Alert<\/code><\/li>\n\n\n\n<li>Recurrence: Once daily (every morning at 8 AM)<\/li>\n\n\n\n<li>Click <strong>Create<\/strong><\/li>\n<\/ul>\n\n\n\n<p>This ensures the flow checks for upcoming renewals automatically.<\/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%94%B9_Step_3_Get_Contracts_from_SharePoint\"><\/span>\ud83d\udd39 Step 3: Get Contracts from SharePoint<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add the action <strong>Get items (SharePoint)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Site Address: Your SharePoint site<\/li>\n\n\n\n<li>List Name: <em>Contracts<\/em><\/li>\n<\/ul>\n\n\n\n<p>Then add a <strong>Filter Query<\/strong> to retrieve only contracts that are due soon:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>RenewalDate lt '@{addDays(utcNow(),30)}' and ReminderSent ne 1\n<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"478\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-16-1024x478.png\" alt=\"Get items action\" class=\"wp-image-1018\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-16-1024x478.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-16-300x140.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-16-768x358.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-16.png 1224w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p> <\/p>\n\n\n\n<p>This filter captures contracts with renewal dates within the next 30 days.<\/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%94%B9_Step_4_Select\"><\/span>\ud83d\udd39 <strong>Step 4: Select<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add a <strong>\u201cSelect\u201d<\/strong> action to extract the contract owner\u2019s email address.<br>We\u2019ll use this email address later to filter contracts by their respective owners.<\/p>\n\n\n\n<p>First, click the small icon next to the <strong>Map<\/strong> field to switch it to a single input field.<br>Then, copy the expressions below into their corresponding fields:<\/p>\n\n\n\n<p><strong>From:<\/strong> <code>@{outputs('Get_items')?['body\/value']}<\/code><br><strong>Map:<\/strong> <code>@{item()?['ContractOwner\/Email']}<\/code><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"361\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-18-1024x361.png\" alt=\"\" class=\"wp-image-1021\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-18-1024x361.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-18-300x106.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-18-768x270.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-18.png 1102w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/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=\"%F0%9F%94%B9_Step_5_Compose\"><\/span>\ud83d\udd39 <strong>Step 5: Compose<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add a <strong>\u201cCompose\u201d<\/strong> action to remove duplicate email addresses using the <strong>union<\/strong> expression.<br>Copy the expression below into the <strong>Inputs<\/strong> field:<\/p>\n\n\n\n<p><strong>Inputs:<\/strong> <code>@{union(body('Select'), body('Select'))}<\/code><\/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%94%B9_Step_6_Initialize_Variable\"><\/span>\ud83d\udd39 <strong>Step 6: Initialize Variable<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add an <strong>\u201cInitialize variable\u201d<\/strong> action to define a table style for the HTML table that will appear in the email later.<\/p>\n\n\n\n<p><strong>Name:<\/strong> Table Style<br><strong>Type:<\/strong> String<br><strong>Value:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;style>\ntable {\n  width: 80%;\n}\ntable th {\n  background-color: skyblue;\n}\ntable td {\n  background-color: lightskyblue;\n  text-align: center;\n}\n&lt;\/style><\/code><\/pre>\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%B9_Step_7_Apply_to_Each_and_Filter_Array\"><\/span>\ud83d\udd39 <strong>Step 7: Apply to Each and Filter Array<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add an <strong>\u201cApply to each\u201d<\/strong> action and use the output from the <strong>Compose<\/strong> action to loop through each contract owner\u2019s email address.<\/p>\n\n\n\n<p><strong>Select an output from previous steps:<\/strong> <code>@{outputs('Compose')}<\/code><\/p>\n\n\n\n<p>Inside the loop, add a <strong>\u201cFilter array\u201d<\/strong> action to filter contracts based on the current contract owner\u2019s email address.<br>We\u2019ll use this filtered output in the next step to create an HTML table.<\/p>\n\n\n\n<p><strong>From:<\/strong> <code>@{outputs('Get_items')?['body\/value']}<\/code><\/p>\n\n\n\n<p><strong>Filter Query:<\/strong> <code>@{item()?['ContractOwner\/Email']} <strong>is equal to<\/strong> @{items('Apply_to_each')}<\/code><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"491\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-20-1024x491.png\" alt=\"Filter Array action\" class=\"wp-image-1024\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-20-1024x491.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-20-300x144.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-20-768x368.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-20.png 1221w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/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=\"%F0%9F%94%B9_Step_8_Create_HTML_table\"><\/span>\ud83d\udd39 <strong>Step 8: Create HTML table<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add a <strong>\u201cCreate HTML table\u201d<\/strong> action to generate a table using the output from the <strong>Filter array<\/strong> action.<br>We\u2019ll use this table in the next step to include in the email body.<\/p>\n\n\n\n<p><strong>From:<\/strong> <code>@{body('Filter_array')}<\/code><\/p>\n\n\n\n<p><strong>Columns:<\/strong><br>Choose <strong>Custom<\/strong> and then map the following values:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Header<\/td><td>Value<\/td><\/tr><tr><td>Contract Name<\/td><td>@{item()?[&#8216;ContractName&#8217;]}<\/td><\/tr><tr><td>Renewal Date<\/td><td>@{item()?[&#8216;RenewalDate&#8217;]}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"596\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-22-1024x596.png\" alt=\"Create HTML table action\" class=\"wp-image-1026\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-22-1024x596.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-22-300x174.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-22-768x447.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-22.png 1145w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/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=\"%F0%9F%94%B9_Step_9_Send_Reminder_Emails\"><\/span><strong>\ud83d\udd39 Step 9: Send Reminder Emails<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add the action <strong>Send an email (V2)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>To:<\/strong> <code>@{items('Apply_to_each')}<\/code><\/li>\n\n\n\n<li><strong>Subject:<\/strong> <code>Contract Renewal Reminder<\/code><\/li>\n\n\n\n<li><strong>Body:<\/strong> <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>@{variables('Table Style')}\nHello,\nThis is a reminder that the following contract(s) are due for renewal within the next 30 days. Please review them and take the necessary action before the renewal date.\n@{body('Create_HTML_table')}<\/code><\/pre>\n\n\n\n<p>You can also CC finance or legal teams if needed.<\/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%94%B9_Step_10_Apply_to_Each_and_Update_item\"><\/span><strong>\ud83d\udd39 Step 10: Apply to Each and Update item<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add another <strong>\u201cApply to each\u201d<\/strong> action<\/p>\n\n\n\n<p><strong>Select an output from previous steps<\/strong>: <code>@{body('Filter_array')}<\/code><\/p>\n\n\n\n<p>And inside it, add an <strong>\u201cUpdate item\u201d<\/strong> action to update the filtered items in SharePoint.<br>Set the <strong>\u201cReminder Sent\u201d<\/strong> field to <strong>true<\/strong> to ensure that when the flow runs again, it won\u2019t send duplicate alerts for the same contracts.<\/p>\n\n\n\n<p>Site Address: SharePoint Site URL<br>List Name: Contract Renewals<br>Id: <code>@{items('Apply_to_each_1')?['ID']}<\/code><br>Reminder Sent: Yes<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"624\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-24-1024x624.png\" alt=\"Update item action\" class=\"wp-image-1028\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-24-1024x624.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-24-300x183.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-24-768x468.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/10\/image-24.png 1141w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/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=\"%F0%9F%94%B9_Step_11_Test_and_Monitor_the_Flow\"><\/span><strong>\ud83d\udd39 Step 11: Test and Monitor the Flow<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Manually run the flow to test it. Power Automate will scan the SharePoint list, find contracts expiring in the next 30 days, and send email notifications to owners.<\/p>\n\n\n\n<p>Check the <strong>Run History<\/strong> to verify each step executed successfully.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\ud83d\udcc8 <strong>Bonus Tips<\/strong><\/p>\n\n\n\n<p>\ud83d\udd27 <strong>Enhance Notifications<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add a Teams notification using <strong>\u201cPost a message in a chat or channel\u201d<\/strong> action.<\/li>\n\n\n\n<li>Include contract details or a direct link to the SharePoint item.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\ud83c\udfc1 <strong>Wrapping Up<\/strong><\/p>\n\n\n\n<p>Your Automated Contract Renewal Alert Flow in Power Automate 2025 is now ready!<br>It automatically checks for upcoming renewals, notifies the responsible people, and helps you stay compliant without manual tracking.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\ud83d\udca1 <strong>Bonus Resources<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/automate-invoice-email\/\">\ud83d\udca1\u00a05 Easy Steps to Automate Invoice Email to SharePoint<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/substring-function\/\">\ud83d\udca1Ultimate 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\udca13 Effortless Steps to Save Email Attachments to Teams<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>If your organization struggles to keep track of upcoming contract renewals, this tutorial is for you. You\u2019ll learn how to create an Automated Contract Renewal Alert Flow in Power Automate that alerts stakeholders in advance &#8211; preventing missed renewals, penalties, or unwanted auto-renewals. \ud83d\ude80 What You\u2019ll Achieve By the end of this tutorial, your Automated &#8230; <a title=\"\ud83d\udcc5 Powerful Automated Contract Renewal Alert in 11 Steps\" class=\"read-more\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/contract-renewal-alert\/\" aria-label=\"Read more about \ud83d\udcc5 Powerful Automated Contract Renewal Alert in 11 Steps\">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-1003","post","type-post","status-publish","format-standard","hentry","category-power-automate"],"_links":{"self":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/1003","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=1003"}],"version-history":[{"count":19,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/1003\/revisions"}],"predecessor-version":[{"id":1034,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/1003\/revisions\/1034"}],"wp:attachment":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/media?parent=1003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/categories?post=1003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/tags?post=1003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}