Power Automate

Get an email one day after its selected in a sharepoint list column

(1) Share

Report

Posted on by Charlie Martharper

931 Season of Giving Solutions 2025

Hi guys!

I have a sharepoint list date type, and I want to send an email like at 8 am the next day. How could I do it?

Thanks!!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Kalathiya 2,420 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello @Charlie Martharper,

Yes, you can do this using a creating a scheduled flow that checks SharePoint list and sends emails at 8:00 AM.

Please follow below steps:

#1. Create a Scheduled cloud flow.
#2. Set it to run every day at 8:00 AM.
#3. Add Get items (SharePoint) to retrieve list items.

Filter Query:

DueDate eq '@{formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')}' //DueDate - Replace with your date column

#4. Add send an email action and send the email.

on trigger please select the frequency to day and select your Timezone and define the time.

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,204 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Create a Scheduled Cloud Flow

Run the flow every day at 8:00 AM.

Get Items from SharePoint List

Use Get items action to retrieve list records.

Filter Items

Check if the SharePoint Date column equals yesterday's date (or today's date minus 1 day).

Example expression:

formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')

Send Email

For each matching item, use Send an email to send the notification.

Alternative :

Create an automated flow that triggers when an item is created/modified.
Add a Delay Until action and set it to the item's date + 1 day at 08:00 AM.
Then use Send an email.

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No
Charlie Martharper 931 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Hi! @Kalathiya

If my utc is brussels copenhagen madrid paris, the date in filter query 'yyyy-MM-dd' should I change it?

In my SP column looks like this 'dd-MM-yyyy':

Was this reply helpful? Yes No
Kalathiya 2,420 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @Charlie Martharper,

No need to change it, SharePoint stores dates in UTC internally, so yyyy-MM-dd is the correct format even if the column return dd-MM-yyyy.

If this helped resolve your issue, please click “Does this answer your question?” so the solution is marked and easier for others to find.

Was this reply helpful? Yes No