Create one HTML table but with multiple rows unwanted

[Yue_Jiang]

I'm currently creating a HTML table using Power Automate. But my question is that, when the count number is larger than 5, i will create a HTML table and send out an email that includes it to myself. However, I find that due to the inevitable apply to each in the condition, the HTML table I've created will be made of duplicated rows, which is not i want. I want to combine all the materials from get items in one table and send out to myself. How to do that?

This is the email i receive. 

[ManishSolanki]

Hi @Yue_Jiang 

Use filter query in "Get items" action to get the filtered data. This will avoid apply to each action and condition. When you get filtered data directly from get items action, you can use "Select" action to select the required columns from the output of get items action. Pass the output of select to "Create HTML table" action and then share the output of html action in the email body.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[Yue_Jiang]

Thank you so much for replying to me. But the question is that i have to use condition since under yes, I also have some actions that i don't show in my post. Is there any better solution to it?

[v-yetonggu-msft]

Hi @Yue_Jiang ，

Please try use Initial variable and append to array variable:
I did a test for your reference.

In my scenario:

The Result:

My Flow:

{
"Material":@{items('Apply_to_each')?['Material']},
"Trade Name":@{items('Apply_to_each')?['TradeName']},
"Product Name":@{items('Apply_to_each')?['ProductName']},
"Supplier Name":@{items('Apply_to_each')?['SupplierName']}
}

Best Regards,

Sunshine Gu

[Yue_Jiang]

Dear Sunshine Gu,

Thank you so much for your help! I've tried your method but I find that If I have two rows of information, i will receive two emails: The first email contains a single row HTML table, the second email contains two rows of HTML table (this is what i want). I don't know why there is such a problem. 

[v-yetonggu-msft]

Hi @Yue_Jiang ,

Take Create html table out of Apply to each:

Best Regards,

Sunshine Gu

[Yue_Jiang]

Hi, Sunshine Gu. Thank you so much for your advice. But there are corresponding actions under True and False, i cannot directly get HTML table out of the Apply to each. Is there any better solution?

[v-yetonggu-msft · Accepted solution]

Hi @Yue_Jiang ,

You can create two branches, one branch gets records with Count Emails greater than or equal to 5, if the length of Get items is greater than 0, create an HTML table and send an email, and the other branch gets records with Count Emails less than 5.

Count_x0020_Emails ge '5'
Count_x0020_Emails lt '5'

length(outputs('Get_items')?['body/value'])

{
  "Material": @{items('Apply_to_each')?['Material']},
  "Trade Name": @{items('Apply_to_each')?['TradeName']},
  "Product Name": @{items('Apply_to_each')?['ProductName']},
  "Supplier Name": @{items('Apply_to_each')?['SupplierName']}
}

My Outlook Inbox:

Best Regards,

Sunshine Gu