
Announcements
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!
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