web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate HTML condition when a ...

Power Automate

Answered

HTML condition when a field is NULL or HTML no data

(0) Share

Report

Report

Posted on by S_Tran

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?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,757 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
S_Tran 164 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation