Advanced HTML Tables in Power Automate - Formatting cells, rows and vertical tables

In this video I'll be showing you how to build advanced HTML tables in Power Automate. We'll explore how to highlight specific rows based on a condition, change the color of cells, and even flip data into a vertical table.

Out of the box, Power Automate has an action that creates an HTML table from a data source like a SharePoint list. But what if you want to take it a step further? In this tutorial, I'll guide you through some advanced techniques to make your HTML tables stand out.

Before we dive in, we'll go over the basic principles of HTML. Then, I'll demonstrate how to highlight rows based on a condition, change cell colors, and flip data into a vertical table.

If you're interested in learning these advanced techniques, make sure to give this video a like and subscribe to my channel. Let's get started with the demonstration!

00:00 Intro
01:47 Plain old create an html table
03:29 HTML Table understanding
07:08 Create HTML table ROWS via Select
11:05 Create Table Via Compose
13:14 Method 1: inline background and text colour
17:55 Method 2: using css tags for red text
19:25 Format Numbers to include decimal places and £
21:18 Create a Link via a href
23:10 Vertical HTML Table

[FabioSilva-kjbm]

Thanks Damien. Today you saved my life with two different videos. I really appreciate it.

[zachbean]

This really helped, as i have a query on 3 lists (parent, 2 child lists) and wanted to bring the latest details into a table. The select after the apply to each to grab the results from the array variable was perfect! Thanks for the detailed explanation!

[AmeliaNguyen-fogt]

Thank you sir! My problem was I wanted to get this done quickly so I was skipping away like a ballerina but after 500+ tabs of googling on this topic, I decided I'm gonna just do exactly how you have it from the start and IT WORKED WONDERFULLY! THANK YOU SO MUCH!

[g]

Nice one Damien! - Have had my head buried in a Power Apps build for a while and now need to plan the reporting/output aspects. I'm looking for good reporting examples and this video ticks most boxes on my list. Cheers for sharing 👍

[emmanuelmaceda]

Great vid as usual Damien! One of my struggles is making power automate "replicate" what PowerFX can seem to do to a table very quickly. And while PowerFX can indeed handle these type of things quickly, the real struggle is when you have a big amount of data and you now need Power Automate to do the "heavy lifting". Your vid is great help! Thank you!

[lukasmillet]

Amazing tutorial, everything explained perfectly. Thanks!

[claudiemalette]

Thank you so much for this! I had been struggling with the « Create an HTML table » action, especially adding hyperlink as the action changed a bunch of characters that then had to be replaced in order for the href to work. Your way of doing it made it so much easier! The boss is going to love the conditional formatting 😉

[stefankirst]

Thanks for your fantastic Power Automate videos!

[Worrelpa]

Great timing Damien, I have a ta ke to create tomorrow using a lot of those things.

My scenarios is from one list I have an array of email addresses already extracts from one list.
I then have to filter the second list by the email addresses in the first array.
Extract those records
Then put the data into a table.
The other data in the second table has a multiple value choice value column for skills
I need to extract the persons display name in one column.
The skills as comma separated values in the second column.

Going to break it down into chunks see if I can work it out.

Bit of a monster flow doing a mail merge type functionality.
One thing I use a lot of in this one is objects in variables (could be composes) to use if expressions to convert / transform data then use the variable outputs to process the data. Been meaning to blog about it as a pattern but not gotten round to it. Saves a ton of steps and having to go down a flow and changing multiple values as you only have to change the values at the top.

[mikaeldias]

I don't want to use 'Create an HTML table' anymore! Thanks a lot!

[alexmcla]

Thanks, great vid Damian! Glad your back fit and well!!
I notice you're using a combination of classes and styles. Have you used styles only where classes won't work in emails?

[xuanyingren]

This indeed saved my life Damien!! Thank you so much! Just one quick question - is there anyway to have multiple lines in one cell for the vertical table? I tried using “replace” with <br> but it always showed error “the first parameter is not string” but null. Wondering if you have any insights on this?

[battle_born]

Thank you so much!!! This video saved my sanity 😁

[dexterx]

This is great, I'm struggling a bit to combine this with your previous video, where you get an array of the tables then loop through that based on manager name. In this video you do not use the create html table action, should I just replace the create html table action with the first select from this video. If not what would be the alternative?

[berniceleong]

Hi.. Your video really helps me in html table styling, i follow yr suggested action, it works. Seeking your advice to include a sort (employee name) expression. i have tried few ways, all resulted in error.

[hugarohugaro]

Hello Damien, as usual this is a phenomenal resource, I have a question:

The column I am trying to format is a string which contains a % value, I am using your following code Ratio (%)]']), 0.5), 'style=''background-color: green; color: white''', '') and I am getting the following error: 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

[menhardbesho]

Great tutorial, thank you Damien!
Is there a method of adding a Total Row at the end of the table? For example to add up the Amounts in this demonstration. Thank you for the great content.

[dblumenstetter]

Great video, I was playing vertical table setup for a few days, this cleared it up in minutes. Quick question, is it possible to consolidate or merge row values that are the same? My first row is Date. Is it possible to merge the date cells that are the same value? Thanks

[meljovanovic]

Hi @DamoBird365 - thank you for your video, I have built 3 beautiful vertical tables, formatting correctly and sending by email with no prior HTML experience! What I am struggling with is how to apply the conditional formatting (if expression) to the 'Concat' function used in the Select action for the vertical table, as it is in the text method rather than the array method.
Can you explain how you would add the IF expression (I need 3 conditions for IF=[Yes, no or N/A]) to row 3 in your vertical table where you have used the concat expression?

[stevebrown]

Hi -- if you wanted to group by the Company column and add subtotals under another "value" column, could you do this in the compose/css step?