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

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”.

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'

Insert a Data Operation – Select action and set:

• From