Send one email to different email addresses based on a condition

[KMagadia]

Hi,

I was able to build a scheduled flow which sends email notification to the "Site Contact" when the signed in visitor hasn't signed out yet (or if Actual Departure date is 'blank') and if the Estimated Departure date is less than today's date.

Currently, my flow may send multiple emails to a single person if there are more than one visitor signed in with the same "Site Contact".

What I wanted to achieve is to just send one email to the relevant Site Contacts, where the name of the visitors are listed in a table, instead of them receiving individual emails per visitors' name..

From the image above, Site Contact Name A should receive a notification for Gemma while Site Contact Name B should receive a notification for both Mariam and Hayley.

I hope someone can help me here! Thanks!

[v-bacao-msft]

Hi @KMagadia ,

Assuming the type of the SiteContact field is Person, you can refer to the following methods to achieve your needs.

We need to group according to the SiteContact, and then send the eligible items to the corresponding Site contact.

• Initialize two variables, one to store the emails of all sitecontacts, and the other to store the data to be displayed in the HTML table.
• Iterate over the value of Get items and append the email of SiteContact to the array variable.
• Use the union() function to remove duplicate emails and iterate through those emails.
• Find the eligible items according to email, and append the fields that need to be displayed in the table to the array variable.
• Create an HTML table and send it. Finally, you need to clear the HtmlTable array variable.

Overview:

Details of Apply to each 2:

Details of Apply to each 3:

Please take a try.

Best Regards,

[KMagadia]

Hi @v-bacao-msft,

I just followed your instructions..

A single email has been sent out but it doesn't capture the created HTML table to the email..

I am not sure what I missed.

mmmm...

[v-bacao-msft]

Hi @KMagadia ,

First, you need to check if you configured Output in the Body from the Create HTML table action.

You can then check that the results of each step in the Flow run history are as expected.

And make adjustments based on the results.

Best Regards,

[KMagadia]

Hi @v-bacao-msft,

My assumption is that the condition is incorrect because the "Expression Result" always appear as 'false' even if the entry is expected to satisfy the condition..

I think we would also need to have an additional check to not send any email if the html table is empty..

[v-bacao-msft]

Hi @KMagadia ,

Please check the Details of Apply to each 3 in the screenshot I provided to see if the configuration is as expected.

Best Regards,

[v-bacao-msft · Accepted solution]

Hi @KMagadia ,

In addition to determining whether the Table is empty, you can determine whether the HtmlTable variable is empty. If it is not empty, then send the message.

Best Regards,

[KMagadia]

Hi @v-bacao-msft,

Thank you so much for your help!

It looks like working 🙂

I'll reach out if I missed any! Again, thanks!