Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

FLowCreating an HTML table from Excel grouped by Author


So I have a Flow which is scheduled, it is listing rows of "messages" sent by different authors throughout the previous week (this works). Now I have used Create HTML table and HTML to text to use for sending the output in an email (works). My question is how do you group together the messages sent by the author in one row and list the other author and his messages on another row and so on like below:



Community Champion
Community Champion

@grngrl  - May be you can run a loop on excel table by each author and append required information to array variable and then convert that to HTML table?



Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

thank you for your response, I am new to using the flow, would it be possible to show like how it can be done?

Regular Visitor

Now we were able to group together using the following flow, however when I try to make the link a hyperlink by using concat it is giving an extra character \ (<a href=\") also how can I remove the [{"Message":" and the {"Link":" on the output from the select



Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,476)