Power Automate: A Daily Email Summary of New SharePoint List Items

An email for every new request floods inboxes. A single morning summary is kinder. Here is the flow.

1. Trigger: Recurrence

New scheduled cloud flow → Recurrence: every 1 day at 08:30, time zone (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi.

2. Get yesterday’s items

Add SharePoint → Get items, pick the site and list, and in Filter Query enter:

Created ge '@{addDays(utcNow(),-1)}'

Set “Top Count” to something sensible (for example 500) — the default page size can silently cut results.

3. Stop if there is nothing

Add a Condition: length(outputs('Get_items')?['body/value']) is greater than 0. Put the remaining steps in the “Yes” branch so nobody receives empty summaries.

4. Build a table

Data Operation → Select to pick only the columns you want (Title, Requester, Amount, Link), then Create HTML table from the Select output.

5. Send one email

Office 365 Outlook → Send an email (V2) with a subject like New requests – @{formatDateTime(utcNow(),'dd MMM yyyy')} and the HTML table in the body.

Polish

• Count in the subject: @{length(outputs('Get_items')?['body/value'])} new requests.
• Style the table with a little CSS in a Compose step (borders, header colour).
• Add a link to the list view filtered to “Created: yesterday”.

Learn more patterns in the Power Automate intermediate course.