Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

remove row or blank out in html table

(0) ShareShare
ReportReport
Posted on by 186

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
 
rosscortb_0-1674127813770.png

 

rosscortb_1-1674127829112.png

 

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: remove row or blank out in html table

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

    Hardesh15_0-1674213309985.png

    Use in this way-

    Hardesh15_1-1674213538037.png

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

    @Hardesh /Gopenly.in

  • rosscortb Profile Picture
    rosscortb 186 on at
    Re: remove row or blank out in html table

    @Hardesh15 Actually had another thought on it so tried this. 

    rosscortb_0-1674212555604.png

    if(equals(body('Create_HTML_table_6'),body('Create_HTML_table_5')),null,body('Create_HTML_table_6'))
     
    but got this 
    rosscortb_1-1674212623662.png

     

     

    Thanks

    Ross

     

     

  • rosscortb Profile Picture
    rosscortb 186 on at
    Re: remove row or blank out in html table

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

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: remove row or blank out in html table

    @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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard