Power Platform Community Forum Thread Details

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

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.