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 / Error on Condition, Da...
Power Automate
Unanswered

Error on Condition, Date Item in list is blank

(0) ShareShare
ReportReport
Posted on by 920 Super User 2024 Season 1

My flow works fine for the first row -

 

wonka1234_0-1706734796303.png

 

 

second row throwing an error 

wonka1234_1-1706734807697.png

 

my flow - 

 

wonka1234_2-1706734846803.png

 

my expressions are like so - 

formatDateTime(utcNow(), 'yyyy-MM-dd')

 

throwing an error above - 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

 

How can I deal with the null values here?

 

Categories:
I have the same question (0)
  • Verified answer
    wskinnermctc Profile Picture
    6,519 Moderator on at

    The quickest way would be to add a condition before your current condition that checks if the field is null. If the field is not null then go to the next condition that compares dates, if the field is null then go down a different branch.

     

    Here is an example where I am checking a column named "Submit Date".

     

    The first condition uses an expression on the Submit Date that checks if the field is empty() and if it is empty() then have an output of true, if it is not empty, then output of false. So if the condition is true, it goes down the no value branch, but if there is a value, it goes to the next condition where the date is compared.

     

    The expression used is:

    if(empty(items('Apply_to_each')?['SubmitDate']),true,false)

    You can see the example below

    Condition Check.png

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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard