Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Flow fails when using @empty on date field

(0) ShareShare
ReportReport
Posted on by 32

It has worked fine for other field types. Is there a different function I should be using for date fields?

  • ctyst Profile Picture
    32 on at
    Re: Flow fails when using @empty on date field

    It seems to be an issue with a field selected on a site column. I selected a different field and it works. Good to know. failure due to site column data.PNG

  • ctyst Profile Picture
    32 on at
    Re: Flow fails when using @empty on date field

    It may be that the flow is having trouble. This morning the @empty check worked, but now I am getting failed checks. I'm sure I'm not the first person to have that issue, but I couldn't find any threads on how to correct that issue. Could you point me to more information?

    failed checks.PNG

  • Verified answer
    v-xida-msft Profile Picture
    on at
    Re: Flow fails when using @empty on date field

    Hi @ctyst,

     

    Could you please share a screenshot of your flow’s configuration?

    Do you want to check if the date file is empty?

    Further, could you please show a bit more about the error message?

     

    I have made a test on my side and don’t have the issue that you mentioned. My flow’s configuration as below:19.JPG

    Within Condition box, click “Edit in advanced mode”, type the following formula:

    @empty(triggerBody()?['DueDate']) 

    Note: The DueDate column is a Date and Time type column in my SharePoint list.

     

    The flow works successfully as below:20.JPG

     

    Please check if there is something wrong with the formula that using @empty on your date field.

     

    Best regards,

    Kris

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow