HTML Table Formatting Power Automate

[NegzJobz]

Hi,

I am new to Power Automate. I am preparing a table to be sent as an email to a list of clients. The table data comes from Query on a PowerBI dataset. And it contains availability of clients for two weeks. I created HTML Table based on this data and it shows the table as below:

I have a select Data Operation to choose the fields from data source and an HTML table which is being created automatically based on the select.

I want to edit this table so it will be clearer. Would like to show every two record of the table in grey like below:

I put a loop to increment a variable by two and used append to array variable to format based on that but it does not work properly.

Can someone help me on this?

Thanks

[v-dezhili-msft]

Hi @NegzJobz ,

Do you want your html table to change the background color every two rows?
I have a test for your reference.

Best Regards,

Dezhi

[NegzJobz · Accepted solution]

Thanks,

[NegzJobz]

Thanks so Much Dezhi. It worked. Great help

[aaaa3]

Hi @v-dezhili-msft ,

I am working on poweratomate flow for my project.

here I want to add OrderID is ______ in the confirmation email. 

Parse.Json

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "28 Byte Code": {

                "type": "string"

            },

            "DeliverLocation": {

                "type": "string"

            },

            "Dept": {

                "type": "string"

            },

            "DesktopAddon": {

                "type": "string"

            },

            "Division": {

                "type": "string"

            },

            "Image": {

                "type": "string"

            },

            "Memory": {

                "type": "string"

            },

            "Price": {

                "type": "string"

            },

            "Processor": {

                "type": "string"

            },

            "ProductFinal": {

                "type": "string"

            },

            "ProductID": {

                "type": "integer"

            },

            "Quantity": {

                "type": "string"

            },

            "Remarks": {

                "type": "string"

            },

            "Storage": {

                "type": "string"

            },

            "Title": {

                "type": "string"

            },

            "TotalPrice": {

                "type": "string"

            }

        },

        "required": [

            "28 Byte Code",

            "DeliverLocation",

            "Dept",

            "DesktopAddon",

            "Division",

            "Image",

            "Memory",

            "Price",

            "Processor",

            "ProductFinal",

            "ProductID",

            "Quantity",

            "Remarks",

            "Storage",

            "Title",

            "TotalPrice"

        ]

    }

}

The flow has been created and I will just need to make minor modifications such as extra field OrderID into html table.

May I know if i need to generate sample from parse json?

May I know how should I edit my create html table and send email html parts? Thank you.