Unanswered

Filter Query for Checking dates in a Table is less than 7 days away

(0) Share

Report

Posted on by DM-09011940-0

Hi. So pretty new actually to power automate and still getting my head round it. I think my problem more so lies with less understanding of FX queries. I have a sharepoint list with a specific column of dates, I need to send an e-mail to the user specified in another column when that date is 7 days away. I'm guessing the filter query needs to go along the lines of "columname eq Todaysdate < 7 days" Sounds very silly typing it out and maybe this is the wrong forum all together. Any help is appreciated or even guidance of where to post this"

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

You can try as below

First, you need to get the data from your source, like a SharePoint list or an Excel table. You can do this by using the "Get items" action (for SharePoint) or "Get rows" (for Excel).

Add the "Filter array" action:
After retrieving the data, add a "Filter array" action to narrow down the results based on your date condition.

If the column that contains the dates is called DateColumn (replace this with the actual name of your column), you can use the following expression to filter for dates that are within the next 7 days from today. This will check if each date in that column is less than 7 days away from the current date.

@less(items('Get_items')?['DueDate'], addDays(utcNow(), 7))

(If you got your solution you can mark as solution and gives kudos)

Regards,

Srini

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

@DM-09011940-0

You might be interested in this YT Tutorial:

Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

📅 Student Birthdays
📅 Project Due Dates
📅 Contract/Membership Renewals
📅 License Expirations
📅 Client Anniversaries

---

IN THIS VIDEO:

✓ How to Send an Email based on a Date Column in SharePoint
✓ Using the Recurrence Trigger in Power Automate
✓How to Use the Filter Array Action with multiple conditions
✓ How to Get Dynamic Content from a Filter Array Action
✓ How to Get a Date Three Days from Today
✓ How to Create a Dynamic Date Based on utcNow()
✓ How to Return a Count of Items
✓ How to initialize and set a variable
✓ How to use the Send an Email (V2) action
✓ How to send test emails

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No