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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow with date condition?
Power Automate
Unanswered

Flow with date condition?

(0) ShareShare
ReportReport
Posted on by 832

Hey! So I have a Sharepoint list with several date columns. Two of them are the Proposed date of solving an issue ('Proposed Date'), and another column is the date that the issue actually gets resolved ('Resolve Date')

I want a conditional that checks if the Resolve Date comes after the Proposed Date. How would I accomplish this?

I tried this conditional, putting the two dates apart and in betwen an "is greater than":

Captura.JPG

However, I get this error: Unable to process template language expressions for action 'Condición_2' at line '0' and column '0': 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

Checking with ChatGPT it says that I should use the dropdown option "after" or "before", but at least that's not in my options.

Categories:
I have the same question (0)
  • Chriddle Profile Picture
    8,449 Super User 2025 Season 2 on at

    One of the values you want to compare contains no data (is null).

    I doubt ChatGPT can help you here.

  • WorkingRicardo Profile Picture
    832 on at

    Yeah, I was imagining one was Null, but how do I fix that or how do I create the Condition I need?

  • Chriddle Profile Picture
    8,449 Super User 2025 Season 2 on at

    You can check if:

    coalesce(Resolve_Date, '1800-01-01')
    greater than
    coalesce(Propose_Date, '2200-01-01')

    The coalesce() function checks if the value is null and if so returns the second value.
    Otherwise the original value is returned.

    In other words, if a value is null, set it to a very low or very high value to ensure that the condition returns false.

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
Expiscornovus Profile Picture

Expiscornovus 185 Most Valuable Professional

#2
harshdeol Profile Picture

harshdeol 167 Moderator

#3
S-Venkadesh Profile Picture

S-Venkadesh 159 Moderator

Last 30 days Overall leaderboard