Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Delete extra HTML column and not able to add leader name

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?






Helper IV
Helper IV


Helper IV
Helper IV

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

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,905)