How to Send email reminders based on column value using Power Automate

-

Sending email reminders based on column value in SharePoint List using Power Automate

The above stated flow will trigger a reminder notification based on column value in SharePoint List. We would be using a Scheduled Cloud Flow for the same. Please refer below steps.

Follow below Steps -

1. Sign in to MS Flows/Power Automate.

2. Click on "My Flows" - New Flow and choose "Scheduled Cloud Flow".



3. Create a Scheduled flow will repeat itself based on the frequency you will specify and send emails.

4. Get Items from the SharePoint List based on the column value.



5. Loop through each item and trigger send email.




I believe above stated steps will help you to implement them in your BAU requirements.


Comments

Post a Comment

Popular posts from this blog

Clear DataTable on button click

-
Image
How to clear DataTable on button click In this post we will learn how we can clear a datatable on a jQuery event. By click on "btnReset" we have to call datatable's destroy method to completely clear a datatable. We may need to clear a datatable on an event. Please follow the below code to achieve the same. HTML - <table id="tblResourcesData" class="display" width="100%" cellspacing="0">           <thead>               <tr>                   <th>Title</th>                   <th>Region</th>                 <th>Country</th>                <th>Email</th>             </tr>           </thead>  </table...
Read more

3D Charts in SharePoint

-
Image
How to create 3D Pie Chart in SharePoint Create a Page and add Script Editor web part to it and paste the below code. Code: <style> #chartdiv {   width: 100%;   height: 500px; } </style> <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script>  <script src="https://www.amcharts.com/lib/3/amcharts.js"></script> <script src="https://www.amcharts.com/lib/3/pie.js"></script> <script src="https://www.amcharts.com/lib/3/plugins/export/export.min.js"></script> <link rel="stylesheet" href="https://www.amcharts.com/lib/3/plugins/export/export.css" type="text/css" media="all" /> <script src="https://www.amcharts.com/lib/3/themes/light.js"></script> <script type="text/javascript"> $(document).ready(function () { GetListi...
Read more

How to deal with special characters in rest filters

-
Image
Special characters in SharePoint Rest filters You might have noticed while using SharePoint filters with special characters such as '&', '@' or '!' etc. you get error as we need to use encodeURIComponent in the rest api filtering. Below is the working example of filtering data from rest api having special character. Code -  function matchDataFromSPList(val){         $.ajax({                 url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbyTitle('ListName')/items?$filter= ColumnName eq '"+encodeURIComponent(val)+"'",                 type: "GET",                 headers: {                         "Accept": "application/json;odata=verbose"                 },                 async: false,...
Read more