Send a single reminder for multiple items using Lists and Power Automate

This is a super useful tip / scenario from my friend Norm !

Norm Young

This post is inspired by a question I received from a previous blog post where the user wants to send a single email reminder for multiple Microsoft List items. The typical Power Automate pattern is one reminder per item. Consolidating items, by owner for example, is harder that you would think. I am using the Issue tracker template for my demo and we will send a single email message for all open items assigned to the same user on a weekly schedule.

Create a new Flow from Power Automate > Create new > Scheduled cloud flow. Provide a Flow name, i.e. “Issue tracker – Weekly report” and click “Create”.

Scheduled cloud flow

Insert a SharePoint – Get items action and set:

  • Site Address and List Name to your target site and list
  • Filter Query to: Status ne 'Completed' or Status ne 'Duplicate'

SharePoint - Get items

Insert a Data Operation – Select action and set:

  • From

View original post 385 more words

Leave a comment

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

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: