web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : re/KAv0Jv252XlN6j0e5HE
Power Automate - Building Flows
Unanswered

Only add html table to email if there is content for multiple tables

Like (0) ShareShare
ReportReport
Posted on 15 Jul 2022 12:37:14 by

Hi, 

 

I am trying to make a summary report that takes data from multiple SharePoint lists, creates HTML tables and an email is send to each department with their results. 

 

If there is no content in a HTML table, then the headers are present with no data. I don't want to show the table if there is no content (or give a statement of "You have no results"). I have got around this in the past by having a condition of "if the length of the table is greater than 0, send the email. If not then no action". This works great for one HTML table. 

 

However, I want to send an email with multiple HTML tables in so the email action must be outside the condition that checks for length. I thought i could just append it to a variable but all of this is inside an apply to each (for each department) so the results accumulate in the variable and the last department gets everyone's results. 

Below is what i currently have:

The 'Get data' scope has 3 'Get items' actions

All scopes in the apply to each are the same as the one shown. 

mrsamd_0-1657888388884.pngmrsamd_1-1657888435719.png

 

  • SD-29041212-0 Profile Picture
    4 on 29 Apr 2025 at 12:14:27
    Only add html table to email if there is content for multiple tables
    Oh........ Thats sad.
     
    This is my own post from 3 years ago. 
    Still no answer. 
  • SD-29041212-0 Profile Picture
    4 on 29 Apr 2025 at 12:13:26
    Only add html table to email if there is content for multiple tables
    Hi, 
     
    I am also having the same issue and cant find an answer. 
    Did you every work it out?

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete