Apologies, I cannot read all those little actions easily but I feel like you are close, so please excuse me as I write these down just as a verification you.
Assuming you have a column called "EmailAddress"
0. Create a variable with your CSS for your HTML Table that goes in Email
1. Grab Data
2. Use a Select to grab only the Email Column (using the advanced map to just grab email so its a simple array with duplicates)
3. Use a compose to do a Union of the body of the Select
4. Do an Apply to each on the Output of #3
Inside Apply to Each
--Use Filter Array on data from #1, using the Current Item compared to EmailAddress from the Source Data Array
----Use a Select to grab whatever Columns you want from the previous Filter Array Step
----NOTE: add your headers to the array (multiple different ways)
----Add your Send Email Action
--------Add your Hello whatever
-------------Add your CSS style for your table (or any pre-words before that)
-------------Add your table
And you should have sent out a unique list of email data just for each person uniquely
As I said I can barely read that.. I am old, so I am putting this here in case you see something that stands out.
That or please share the Inputs and outputs of a flow Run so we can better point to the thing doing the wrong thing :-)
I am not sure why you need to create a JSON at all as your data from your report should be g2g.
