Answered

HTML condition when a field is NULL or HTML no data

(0) Share

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:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,396 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