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:

Business Process Flows

All responses (2)

Answers (0)

creativeopinion 10,103 on at

Like (0)

Report

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

@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
SriniK 2,902 on at

Like (0)

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

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

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

Helpful resources

News and Announcements

Quick Links

Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

Announcing Forum Attachment Improvements!

Leaderboard

Featured topics

Product updates

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

Helpful resources

News and Announcements

Quick Links

Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

Announcing Forum Attachment Improvements!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates