Delete extra HTML column and not able to add leader name

[vaibhavtandon87]

Dear community,

I was building a flow to consolidate information from excel sheet on SharePoint and send email using the reference from below post:

Solved: Consolidated email reporting based on Excel Online... - Power Platform Community (microsoft.... 

1) However I am getting 2 extra columns in the HTML table named - @odata.etag and ItemInternalId. How to remove these tables?

2) While sending email, I am not able to dynamically add the name of the person in the email content like 'Dear xyz'. If I add dynamic content with column leader then 'send email' action converts into apply to each and sends multiple emails.

Attaching screenshot for the successful flow.

Please let me know if any further information is required?

  

 

[vaibhavtandon87]

anybody?

[vaibhavtandon87]

@efialttes, may be you can help? thanks in advance!