Creating a table in an email body which contains data from a selected row in excel

(1) Share

Report

Posted on by x_Shanazzle_x

Hi,

I am trying to create an approval email which pulls data from rows selected in an excel sheet and can be sent to the specified approver using the trigger email (I would also love to be able to send just one email rather than many individual ones to the approver, but I don't think that will be possible)

I have managed to create the below flow, but I really want to be able to collate the data from the selected rows and for it to be presented in a table format in one single email to the approver:

Email received:

Can anyone advise on how I can achieve this (Both things would be ideal - The table in the email approval body, and to be able to send multiple rows in one email rather than as individual emails)

Thank you!

All responses (1)

Answers (0)

Michael E. Gernaey 43,220 Super User 2025 Season 1 on at

Like (0)

Report

Re: Creating a table in an email body which contains data from a selected row in excel

Hi @x_Shanazzle_x

Technically the easiest thing should simply be, in between your List and Email, put a Create HTML Action.

Use your array of Excel Rows as the Input (from your List Rows)

Then pick the Columns you want

That or you can

Add a Select

Add ONLY the Columns you want from your List Rows

Then use your Create HTML Action against the output of the Select

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey