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 Platform Community / Forums / Power Automate / HTML condition when a ...
Power Automate
Answered

HTML condition when a field is NULL or HTML no data

(0) ShareShare
ReportReport
Posted on by 164

I have created an HTML table with certain SQL fields.  I wanted to put a condition if there is no data then I will send out an email stating "NO DATA".  I cannot get the condition to work.  Which is the best route to accomplish this?Condition.JPG

Categories:
I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    33,757 Most Valuable Professional on at

    Hi @S_Tran,

     

    For an individual field you could replace each value expression by this type of expression:

    if(empty(item()?['Order_x0020_Date']), 'NO DATA', item()?['Order_x0020_Date'])

     

    With the expression below you could check if the whole HTML table is empty

    length(outputs('Get_rows_(v2)')?['body/value'])

    is equal to 0

  • S_Tran Profile Picture
    164 on at

    That was perfect!  I used the one where the HTML table is empty.  Thanks for your help!

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 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard