Separate emails when creating a HTML Table from SharePoint list with 2 conditions

[Newbie2019]

Hi All,

I am trying to send an email with a summary HTML table within it.

When items are retrieved from my SharePoint list, I have 2 conditions which they must have:

1 - Attendance column is equal to false

2 - House is equal to McCormack

I currently have:

For the create HTML table I have:

On triggering the flow, I get multiple emails with multiple duplicates in the table rather than a single table / email.

I don't understand why there are multiple tables and why I am getting duplicates.

The number of duplicates, 5 , happens to be the number of total entries in the SharePoint list before applying the condition.

I am guessing that it may have something to do with the apply to each, but I'm not sure how to get around this.

Any suggestions or advice would be appreciated.

Cheers

[abm]

Hi @Newbie2019 

Extend your query under the Get items Filter Query. You don't need a loop to extract all the details if you using Create HTML table. Also you can do the expression replace under the HTML table element.

Try the following steps.

[Newbie2019]

Hi @abm 

Thanks for the reply.

I am a little confused as to what to do.

I am not sure about the filter query...

[abm · Accepted solution]

Hi,

Try this

Attendance eq 0 and House eq 'McCormack'

Thanks

[Newbie2019]

Thank you @abm 

You solved the problem. Thank you so much for your initial replay and prompt response.

I really appreciate it.

Cheers

Newbie2019

[sk2912]

Hallo @abm ,

I kind of have a similar problem. I have 3 sharepoint list :

- List 1 Make a offer (list collects how many offers)

- List 2 Offer accepted or not (How many accepeted and rejected)

- List 3 If offer accepted then send confimation email (Bascially completed offers list)

Have made flows for all these 3 list to update automatically

What i want is , to make a condition 

Condition 1 : Custumor ID number of List 1 =List 2 (NOT SharePoint ID, customer ID is seperate)

Condition 2 : Customer Accepted offer

When these condition satisfies then send email with all data of the particular customer from List 1 and List 2.

But when i tried it does not work. PLease let me knwo if there is a better solution as soon as possible.

Please have a look and let me know.

Thanks In advance,