Answered

Flow to send email alert when today's date appears in a SharePoint List

(1) Share

Report

Posted on by JS-20021459-0

I have a SharePoint list for HR Record Retention. There are several columns that include dates when certain records should be deleted. (It is not a huge list - maximum 20 rows and 40 columns). I want to create a Power Automate flow that runs every day (I can do that bit), and sends me an email whenever there is a date in any of the deletion columns that equals today. Ideally, if it could tell me which row and column the date appears in too, that would be helpful.

I am new to both SharePoint and Power Automate - but I've been looking for a way to automate such reminders for a long time, and thought this might be it.

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Riyaz_riz11 4,204 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Add "Recurrence" (daily based on the client request). : Add "Get items" from SharePoint list. In Filter Query use: DeleteDate1 eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}' or DeleteDate2 eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}' (you can repeat for all date columns).

Build Email with Row Details: Use "Apply to each" on filtered items. Use dynamic content like ID, Title, Delete Date etc based on the input needs you can add-on to build email body. Send summary email after loop ends.

Test with One Column First: Start with single date column. Check run history to see if filter finds matches. Add more columns once basic flow works. Use formatDateTime() to match SharePoint date format.

Handle No Matches: And also add "Condition" like before email: if length(body('Get_items')) > 0 then send email, else do nothing. Prevents empty emails daily.

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
JS-20021459-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Riyaz, that was so helpful. Once I'd set the region of my SharePoint site to South Africa (even though I'm in the UK), to get the date format yyyy-MM-dd, and worked out how to find the internal column names from my list, everything worked perfectly.

Was this reply helpful? Yes No