Power Automate

Get items where SharePoint Date field EQ Today

(0) Share

Report

Posted on by kmw1130

995

I've been trying to get SharePoint list items where the Date field is equal to Today and then send an email.

Here is my flow:

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

wolenberg_ 1,476 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @kmw1130, based on your screenshot and setup, you're using Power Automate to retrieve items from a SharePoint list with a recurrence trigger and a filter for employee status. If you're looking to email employees whose "Date" field matches today's date, here's how to complete that logic:

Steps to Email Employees with Today’s Date
1. Add a Filter for Today’s Date
In your “Get items” action, update the Filter Query to include a date match:

EmpStatus eq 'Active' or EmpStatus eq 'PENDING HIRE' and Date eq 'formatdatetime(utcNow(),'yyyy-MM-dd')'

However, SharePoint expects dates in ISO format and without time. So instead, use this in Power Automate:

Add a “Filter array” after “Get items”

Use this expression:

formatDateTime(item()?['Date'], 'yyyy-MM-dd') is equal to formatDateTime(utcNow(), 'yyyy-MM-dd')

This ensures you're comparing just the date portion.

2. Loop Through Filtered Items

• Add an “Apply to each” loop using the filtered array
• Inside the loop, use “Send an email (V2)”
⁠◦ To: item()?['Email'] (or whatever your email column is)
⁠◦ Subject: “Welcome to the team!”
⁠◦ Body: Customize with dynamic content like name or start date

Make sure your SharePoint “Date” column is of type Date Only (not Date & Time) to avoid mismatches.
• If you're using a view to limit columns, confirm that “Date” and “Email” are included in that view.

If this helped or could help others in the community, feel free to give it a like or a kudo — it helps surface useful answers for everyone!

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Tomac 4,105 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @kmw1130

To begin, please go into a completed flow run and take a look at the Inputs of that Filter Array action. Does the SharePoint datetime look like the one you're trying to compare it to?

I see you're using the date format 'MM-dd-yyyy', but SharePoint stores dates internally as 'yyyy-MM-dd' in UTC (not timezone shifted) and if the SP field is datetime with a timestamp, you'll need to account for that as well.

Once you see what data you're getting from SharePoint for that date field, you should be able to match up your argument in the Filter Array action to match the format.

Was this reply helpful? Yes No