Answered

HTML Table Formatting Power Automate

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

Screen Shot 2022-12-08 at 10.28.02.png

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:

Screen Shot 2022-12-08 at 10.29.09.png

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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

Best Regards,
Dezhi

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks so Much Dezhi. It worked. Great help

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No