cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NegzJobz
Frequent Visitor

HTML Table Formatting Power Automate

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

1 ACCEPTED SOLUTION

Accepted Solutions

4 REPLIES 4
v-dezhili-msft
Microsoft
Microsoft

Hi @NegzJobz ,

 

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

vdezhilimsft_0-1670570986357.png

 

vdezhilimsft_1-1670570986358.png

 

vdezhilimsft_2-1670570986359.png

 

vdezhilimsft_3-1670570986360.png

 

vdezhilimsft_4-1670570986362.png

 

vdezhilimsft_5-1670570986363.png

Best Regards,

Dezhi

 

 

 

Thanks,

Thanks so Much Dezhi. It worked. Great help

Hi @v-dezhili-msft ,

I am working on poweratomate flow for my project.

aaaa3_0-1673418016156.png

aaaa3_1-1673418038912.png

aaaa3_2-1673418060621.png

 

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

aaaa3_4-1673418108856.png

 

 

 

 

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,239)