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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Expression to run the ...
Power Automate
Answered

Expression to run the flow if todays date is Less Than or Equal To 12 days from the StartDate column

(0) ShareShare
ReportReport
Posted on by 4

Good morning Everyone,

 

I am trying to set a condition to check and run a flow only if todays date is less than or equal to 12 days from the StartDate column. Any assistance would be appreciated, thank you!

Categories:
I have the same question (0)
  • wmiller-stratfs Profile Picture
    4 on at

    just to clarify with an example.

     

    StartDate is 5/26/2022, trigger is fired from a change to a Teams List. I have the flow set to "When and item or file is modified" to check if today's date is within 12 days of the start date. Not sure how to write the expression for that check. Check should return "True" for any day within the 12 days from today and the StartDate column. If Outside the 12 days, it would return "False".

     

    Thank you,

  • Verified answer
    v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @wmiller-stratfs ,

     

    1. You can use utcNow to get today's date.

    2. You can use addDays to add 12 days to today's date to judge whether it is greater than or equal to StartDate. If the result is true, it proves that today's date is within 12 days of StartDate.

    I have made a test for your reference:
    vliweimsft_0-1653039449994.png

     

    vliweimsft_1-1653039449997.png

     

    Beat Regards,

    Levi

  • BruG1973 Profile Picture
    4 on at

    Hi, I wonder if if you can help me , its similar question , how would I do it if the date was equal or less than todays date ? I am wanting to delete meetings ( running on schedule - which I am fine with) that have happened on that day so its just the expression I require help with please. 

  • BruG1973 Profile Picture
    4 on at

    test 

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard