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.
