![]() Use the “Advanced options” to set “Filter query” to the following ODATA filter query: DueDate eq ' is the varReminderDate variable. Set the "Site Address" and "List Name" to your Issue Tracker site and list. Note: Microsoft Lists is really SharePoint, so that is why we are using the Power Automate SharePoint actions. Note: Click "Add dynamic content" > "Expression" to access the expression editor.Ĭlick "New step", search for "SharePoint" and select the "Get items" action. Set the "Name" to varReminderDate "Type" to "String" and "Value" to the following expression: addDays(utcNow(), variables('varNumDays'), 'yyyy-MM-dd') ![]() Set the "Name" to varNumDays "Type" to "Integer" and "Value" to "30". Tip: Use the advanced options to set your target time zone.Ĭlick "New step", search for "Variable" and select the "Initialize variable" action. ![]() Issue Tracker – Daily, set "Starting" to "10:00 AM", "Repeat every" to "1", "Day" and click "Create". From Issue Tracker t o the right of the Date reported column select + Add column or + and select "Date and Time".Ĭreate a new Flow by clicking "Automate" > "Power Automate" > "See your flows". We will add a Due Date column to connect our reminders to. Provide a name, color, icon and storage location (OneDrive aka "My lists" or SharePoint) and then click "Create". Review the sample and click "Use template". You can get started with the Issue Tracker by navigating to Microsoft Lists, click "New list" and then select "Issue tracker". In this demo, we will base our Power Automate Flow on the "Due Date" column and will send reminders 30 days in advance of the date. I am using the Microsoft Lists Issue Tracker template for this blog.Īutomated email reminders give users time and opportunity to intervene in the business process prior to expiration or end dates. In this blog post, I will show how to send email reminders for Microsoft Lists items based on a date column using Power Automate.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |