remove row or blank out in html table

(0) Share

Report

Posted on by rosscortb

196

Hello,

In an html table viewed in outlook can I remove or blank out the product if there is no value in the qty of bottles column.

In the top table I want to remove Balvenie Doublewood 12yo or the second table Aerstone Sea Cask

For the points table I have

if(greater(item()?['PointsQuantity'],0),item()?['Product'],null)

Any ideas

Ross

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@rosscortb Construct your table in a compose rather than using from select. You need 3 compose actions for this.

In first compose you need to construct blank <tr><td> for product only then in second compose in which you will have product <tr><td> only then in 3rd compose construct whole html code. Then use condition

if(equals(output(compose2),output(compose1),null,output(compose2)) in 3rd compose.

Example-

Compose1 <tr><td>Product</td><td></td></tr>

Compose2 <tr><td>Product></td><td><if(...)</td></tr>

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
rosscortb 196 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 Can you break down a little more for please? I'm struggling to follow that.

Was this reply helpful? Yes No
rosscortb 196 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 Actually had another thought on it so tried this.
if(equals(body('Create_HTML_table_6'),body('Create_HTML_table_5')),null,body('Create_HTML_table_6'))

but got this

Thanks
Ross

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@rosscortb Please use compose actions. In your case it will still leave Product header if both html tables are equal.

Use in this way-

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No