Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

Need help on condition when a date is blank

(0) ShareShare
ReportReport
Posted on by

I have a condition:

 

If Due Date is not equal to null it should go to the false path, but goes to the true path, when I look at the row of data the Due Date is blank, is there another test instead of checking for not equal to null to fix this ?

  • Re: Need help on condition when a date is blank

    I think I might see the issue, it thinks Start Date is always empty, even when there is data..I need to figure out if it is the name of the column, etc

  • Re: Need help on condition when a date is blank

    It is on the "Check if Start Date is not null"

  • trice602 Profile Picture
    trice602 11,643 on at
    Re: Need help on condition when a date is blank

    Hi @PowerTony ,

     

    Thanks for sharing your expression.  The loop I see in your previous post is a different apply to each.  

     

    trice602_0-1714400990470.png

     

     

  • Re: Need help on condition when a date is blank

    Here is the expression:

     

    empty(items('Apply_to_each_Team_Name_from_List')?['Start Date'])
  • trice602 Profile Picture
    trice602 11,643 on at
    Re: Need help on condition when a date is blank

    Hi @PowerTony ,

     

    This empty expression should work so it must be something else.  Can you please share your expression and the output of the list item?  Either the expression may be incorrect or the field is empty.

     

     

  • Re: Need help on condition when a date is blank

    I have a start date of 1/17/2024 and the following logic:

    PowerTony_1-1714397318406.png

     

     

     

    However it is hitting the false logic and not the true logic..I am wondering if I can use some sort of logic to look at the length of the field ?

     

  • trice602 Profile Picture
    trice602 11,643 on at
    Re: Need help on condition when a date is blank

    Hi @PowerTony ,

     

    I use the conditional action like this example:

     

    The left side is an expression: 

     

    empty(dynamic_start_date_content)

     

    is not equal to

     

    expression:  true

     

    Then I put the actions I want to do on the true side if the start date is not empty.

     

    trice602_0-1714155630546.png

     

     

  • Re: Need help on condition when a date is blank

    How would I write that ? (using a start date as well to check that seperately)

     

    as I have currently:

     

    PowerTony_0-1714155374947.png

     

  • trice602 Profile Picture
    trice602 11,643 on at
    Re: Need help on condition when a date is blank

    Hi @PowerTony ,

     

    I will typically use the empty expression first

     

    empty(Due_Date_dynamic_content) 

     

    is not equal to

     

    expression true

     

    Let me know if that helps!

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics

Restore a deleted flow