Get Items - Filter Query - Date 90 Days Past

(0) Share

Report

Posted on by greddin1

I need to be able to send an email to the Created By user after a Date Hired field comes to 90 days past.

For example, if the SP list item's Date Hired value is utcNow() - 90 days then send email to the Created By.

Let's say the Date Hired value is 12/26/2024 and today's date is 03/26/2025. Since today's date minus 90 days is equal to the Date Hired 12/26/2024 I'd like to send an email.

Date Hired 12/26/2024 = 03/26/2025 - 90 days send the email.

Is there a way I could use the Get Items / Filter Query to determine the items where the Date Hired value is equal to Today's date - 90 days?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

David_MA 12,966 Super User 2025 Season 2 on at

Like (1)

Report
You can do the following:

Create a scheduled flow that runs at the time of the day you want the e-mail to be sent.

Use a get items action with a filter query to only get the items created 90 days ago.

Add a condition to see if any items were found.

Then use an apply to each action to process each item returned and send the e-mail.

The flow will look like this except the trigger will be a scheduled action:

The filter query in the get items action is configured as such:

The two expressions used are:

ge (greater to or equal): addDays(startOfDay(utcNow()), -90)

lt (less than): addDays(startOfDay(utcNow()), -89)

This would be the entire expression: Created ge '@{addDays(startOfDay(utcNow()), -90)}' and Created lt '@{addDays(startOfDay(utcNow()), -89)}'

The condition is configured as:

The expression on the left is: length(outputs('Get_items')?['body/value'])

Was this reply helpful? Yes No
greddin1 86 on at

Like (1)

Report

Thank you for the help!

Was this reply helpful? Yes No