web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Trying to set a condit...
Power Automate
Answered

Trying to set a condition where a date is checked against today's date -5 days.

(0) ShareShare
ReportReport
Posted on by kddsling 49

Hi community! So, I've been struggling with figuring out the correct formula to put into a Power Automate condition. Essentially I want to take the value in a date field on a list and make the trigger occur if today's date is 5 days or less away from the value I am looking at. Currently I have my condition set as:

 

value is greater than or equal to addDays(utcNow(),-5)

 

Unfortunately, when testing this, the trigger is being set off by items with dates such as 2023-07-05 and 2023-06-30 even though today is 2023-05-17.

 

My date column that I am grabbing the value from is set to just have date and displays, mm/dd/yyyy.

 

Any assistance would be greatly appreciated!

Categories:
General topics
  • Verified answer
    kddsling Profile Picture
    kddsling 49 on at

    I believe I have figured it out. It needed a second condition so that it confines the range to things which will not occur in the past but only in the future. My issue was that I did not specify a date for the process to cut off at thus it triggered and acted on all future items that met the condition of being greater or equal to today's date minus 5 days. The flow needed a cut off condition so that it did not trigger on future items.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 231 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 217 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 170

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans