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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Condition = empty

(0) ShareShare
ReportReport
Posted on by 85

Hi,

 

I am having trouble with checking if a CSV output is blank. 

If it is blank, go to YES, if not, NO.

 

It always says the condition is TRUE despite it having data in there.

 

I don't think it's checking it!

 

Capture.PNG

Categories:
I have the same question (0)
  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @originalltd,

     

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

    Do you want to check if the output of “Create CSV table” action is blank?

    Further, could you please show a bit more about DocEntry column in your SQL table?

     

    If you want to check if the output of “Create CSV table” action is blank, I think there is something wrong with your formula in Condition box.

    I have made a test on my side and please take a try with the following workaround:11.JPG

    The flow works successfully as below:12.JPG

     

    Please check if the DocEntry column has values in your SQL table.

     

    Best regards,

    Kris

  • originalltd Profile Picture
    85 on at

    @v-xida-msft

     

    Thanks for your reply.

    Adding @empty(body('Create_CSV_table'))  to the condition field worked.

     

     

    Do you know if simple syntax's like "Contains / Is Equal To" will include items like "is Blank" or "Is Not Blank" in future?

     

    Many thanks,

    James

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard