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 / condition evaluating a...
Power Automate
Answered

condition evaluating a date field

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

I have a string type field that saves a date with the following format

January 5, 2020 9:21 PM

I want to evaluate the following

If the field date is equal to the field date minus 30 minutes

I know it is done in an expression, but I have no idea how to do it.

 

all this with the aim of sending a notification 30 minutes before that date

Categories:
I have the same question (0)
  • Verified answer
    Jay-Encodian Profile Picture
    2,920 on at

    Hi @Anonymous 

    This is the expression to parse the string to ISO 8601 format (yyyy-MM-ddThh:mm:ssZ): formatDateTime('January 22, 2020 9:21 PM','yyyy-MM-ddTHH:mm:ssZ')

    You can then add required minutes to the datetime value: addMinutes(formatDateTime('January 22, 2020 9:21 PM','yyyy-MM-ddTHH:mm:ssZ'),-30)

    Example using the above expressions with the Compose action:

    1.png

    Ref date comparison... it's a little hard to advise as I don't follow your logic, it's impossible for a value to be equal to itself minus a value?!? 🙂

    I'm guessing you would compare against another datetime value or the current time (utcNow())...

    HTH

    Jay

    -------------------------------------------------------------------------

    If I have answered your question, please mark your post as Solved.

    If you like my response, please give it a Thumbs Up

     

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