
Announcements
I have a flow built that pulls an ADO query and sends a monthly status update. It is working fine. I'm curious to know if I can get the flow to send a more visually appealing table that is formatted with cell lines & headers like an email query coming out of ADO.
Is this possible? Would like it to look something like.... below
vs....
Hi @tysol,
Yes that would be possible with actions like Select, Create HTML table and inject ccs via the Compose. There are a lot of create resources with examples of this, for instance this blog: https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/
1. Use a Select to map your ADO query results columns.
2. Put the output in a Create HTML table action
3. Inject CSS in a Compose action and add the output of the Create HTML table action after that.
4. Use the output of the Compose in your Send email action body.