Converging HTML Tables

[bsprakermg]

I am in the process of trying to create a flow that will only take data from a list of table rows with a "Date Opened" = date flow is triggered. I want this data to go into 1 email. Current output is separate emails with the rows listed over and over again. I am having a problem with combining the data...should I filter it differently? Use a different function? 

[trice602]

Hi @bsprakermg ,

Your flow looks really good and here's my recommendation to modify a little:  in this example, my excel table has an email column and I want to send one email to each email address but with all their related rows.

I start with a variable array and then loop through that entire column and append my email addresses (even duplicates).

Next a compose Union will remove duplicates, expression is in the note.

Then you can see all the guts of the apply to each here but essentially for each email address in my filter array, I want to create an html table and send the email to the currentItem.

If this helps you keep moving, please mark as a solution 😁

[bsprakermg]

I tried this and included my filtering (that was working before) for what columns I wanted in the email and now I am getting this error:

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Filter_array' at line '1 and column '4537' is invalid. Action 'Apply_to_each_Email_Address' must be a parent 'foreach' scope of action 'Filter_array' to be referenced by 'repeatItems' or 'items' functions.'.'.