Send reminders to Teams from Microsoft Lists using Power Automate

Date based reminders are a great way to add value to any business process, especially when automated. Microsoft Lists has a great email based Set a reminder feature that can be used with no IT support required. Most modern workplace users spend the majority of their time in Microsoft Teams, so to have the reminder delivered to the Teams experience makes a lot of sense. In this blog post I will show how to simply send the reminder to a Teams user using Power Automate.

I am using a customized version of the Microsoft Lists Issue Tracker template for my demo. See Microsoft Lists: Updated Issue Tracker for more info. The primary customization is the addition of a due date column. DueDate will be the reference date for the reminder.

Create a new Flow by clicking Automate > Power Automate > See your flows.

"Automate" > "Power Automate" > "See your flows".

Click New flow > Scheduled cloud flow.

"New flow" > "Scheduled cloud flow"

Provide a Flow name, I.e. “Issue tracker – Daily (Teams)”, set Starting to “10:00 AM”, Repeat every to “1”, Day and then click “Create”.

Add a new Initialize variable action and set:

  • Name to “varNumDays”
  • Type to “Integer”
  • Value to “30”

Add another Initialize variable action and set:

  • Name to “varReminderDate”
  • Type to “String”
  • Value to the following expression: addDays(utcNow(), variables('varNumDays'), 'yyyy-MM-dd')
Add new Initialize variable actions called varNumDays and varReminderDate

Add a SharePoint Get items action and set:

  • Site Address and List Name to you target site and list
  • Filter query to the following ODATA filter query: DueDate eq '@{variables('varReminderDate')} and States ne 'Complete''
SharePoint Get items action

Add a Apply to each action and set:

  • Select an output from previous steps to “value” from the previous Get items action
Apply to each action

Add a Microsoft Teams Post message in a chat or channel action to the Apply to each container and set:

  • Post as to “Flow bot”
  • Post in to “Chat with Flow bot”
  • Recipient to “Person or group the issue is assigned to Email”
  • Message to a message of your choosing

In my example I have switched the message format to HTML (“</>”) and inserted the following code:

<p><strong>Issue tracker reminder: </strong><a href="@{items('Apply_to_each_-_Reminder')?['{Link}']}">@{items('Apply_to_each_-_Reminder')?['Title']}</a> is due in @{string(variables('varNumDays'))} days.</p>
Microsoft Teams Post message in a chat or channel

My completed Flow looks like the image below.

My completed Flow
Save and test your Flow. Assuming you have an issue due in 30 days you will get the following message in Teams from Flow Bot:
Issue tracker reminder

This is a very simple Flow to implement but its value should not be underestimated. Value comes in the form of users not having to manually look for items that are coming due, it is pushed to them. Automate the mundane! Teams, Lists and Power Automate as a platform give us further opportunities to add more value through centralization and automation.

Thanks for reading.

NY

4 thoughts on “Send reminders to Teams from Microsoft Lists using Power Automate

  1. Hi Norm

    I can not see “person or group”. I am able to select “assign email”. When I allow multipler approver in list, my flow is not working.

    he API operation ‘GetItems’ requires the property ‘body/value/0/Assignedto’ to be of type ‘Object’ but is of type ‘Array’.’

    Like

    1. Hi Teknojest,

      I would not have expected that error with the Get Items action. What step is the error occurring?

      NY

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s