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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Less than, equal too, ...
Power Automate
Unanswered

Less than, equal too, and Greater than Expresssions

(0) ShareShare
ReportReport
Posted on by 546

I've been looking at this post https://powerusers.microsoft.com/t5/Building-Flows/Less-than-equal-too-and-Greater-than-Expresssions/m-p/134798#M13284 by @Timmay313, and I'm trying something similar.

 

I'm using a schedule trigger of 1 time per week, to send an email when a task item is Due in the past 5 days and the status is not complete.

The simple logic:

Schedule 1 time per week

Get items

email person assigned to the task if the duedate is less than or equal to today and status is not equal to complete.

 

I seem to get stopped if I use "lessthan" as seen in the image attached, stating that the expression is invalid.

flowlessthan.jpg

Categories:
I have the same question (0)
  • PieterVeenstra Profile Picture
    13 on at
    Re: Less than, equal too, and Greater than Expresssions

    Hi @smorley,

     

    Dates don't support all these operations. Can you put the fucntion ticks() around your dates? Then you can do the less than etc operations.

  • smorley Profile Picture
    546 on at
    Re: Less than, equal too, and Greater than Expresssions

    Sorry @Pieter_Veenstra I'm not following.  What is the syntax around my DueDate field to show less than or equal to?

  • PieterVeenstra Profile Picture
    13 on at
    Re: Less than, equal too, and Greater than Expresssions

    Hi @smorley

     

    Please find the details fro date comparion on my blog

    https://veenstra.me.uk/2018/11/02/microsoft-flow-compare-dates-using-conditions-in-the-sharepoint-connector/

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard