Create a HTML table from an Excel table after an Apply to each condition

Like (0) Share

Report

Posted on 24 Oct 2023 11:41:52 by Ricardinh0

Hey Guys,

I am trying to create a HTML table based on a single row from an excel table.

I am currently using the following:
1. List Rows Present in a Table

2. Apply to Each

3. Condition: If 'Generate Statement' = True

If Yes: Create HTML Table and then send as an email.

The excel table contains approx 40 rows. It is correctly identifying the one test row I want to include in the HTML table but it is duplicating it as many times as there are rows.

I just want the single applicable row to be included in the HTML table

Any help would be appreciated

All responses (6)

Answers (1)

Verified answer

ManishSolanki 15,085 Super User 2025 Season 2 on 24 Oct 2023 at 12:38:15

Like (1)

Report
Re: Create a HTML table from an Excel table after an Apply to each condition

Hi @Ricardinh0

We need to get rid of "Apply to each" action which causes the multiple emails to trigger.

Pls modify the flow as per the below instructions:

1. Delete all header & values rows from the "create html table" action.

2. Drag it out of apply to each action and place it just after the "Filter array" action.

3. Now, add the expressions for each columns. I have shown the example of 'Name' column:

item()?['Name']

Similarly, set the expression for all the required columns. It follows the following pattern:

item()?['<<Column Name in Table>>']

4. Drag out "Send an email" action out of the apply to each block and place it just after the "Create html table" action:

5. Delete the "Apply to each" action.

Pls retest the flow after making the required changes.

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

Thanks