Answered

Create one HTML table but with multiple rows unwanted

(0) Share

Report

Posted on by CU-20080800-0

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?

Screenshot 2024-04-19 142546.png

This is the email i receive.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CU-20080800-0 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
CU-20080800-0 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Yue_Jiang ,

Take Create html table out of Apply to each:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
CU-20080800-0 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No