Unanswered

FLowCreating an HTML table from Excel grouped by Author

(0) Share

Report

Posted on by grngrl

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:

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
grngrl 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
grngrl 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No