One notification for all items in list

[Jonathan-101]

I have a flow that checks a list every Monday morning and reports all items within a date column within the list that are dated in the next 7 days. Everything works fine except that I would like to combine all the due items that are within the next 7 days into one notification.

Can anybody assist 🙂

[tom_riha]

Hello @Jonathan-101 ,

I think the easiest way would be to use the 'Create HTML table' action. After the 'Get items' add the 'Create HTML table'. Use the 'value' output from 'Get items' as the action input, and select the table columns and what values you want to display in these column. Then you can delete the 'Apply to each', and send the HTML table with all the items in a single email to the recipient.

[ekarim2020]

You should be able to send a single email with a formatted HTML table like this:

This demo flow will use the Select and Create HTML Table action:

 

See below for the HTML table formatting code you can copy-and-paste:

 

The compose actions:

 

This is the HTML table styling code:

<style>
table {
  border: 1px solid #1C6EA4;
  background-color: #EEEEEE;
  width: 100%;
  text-align: left;
  border-collapse: collapse;
  table-layout: auto;
}
table td, table th {
  border: 1px solid #AAAAAA;
  padding: 10px;
}
table tbody td {
  font-size: 13px;
}
table thead {
  background: #1C6EA4;
  border-bottom: 2px solid #444444;
}
table thead th {
  font-size: 15px;
  font-weight: bold;
  text-align: left;
  color: #FFFFFF;
  border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
  border-left: none;
}
</style>

 

 
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[Jonathan-101]

Hi all thank you for your suggestions and help.

I have set up the above, I receive an email notification but noting attached? please see below flow

[ekarim2020]

The first step will be to check if the filter query returning any results?

Click the runtime output for select to open it and examine what data items were selected.

 

Also in the Send an email action, please make sure that the outputs are in the correct order:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[Jonathan-101]

Hi Ekarim2020

Thank you for the quick response - the flow is now working.. yippeeee 

The only minor point is there is a strange item in the email notification as below

[ekarim2020]

Double check that the HTML includes everything. I've added it again below:

<style>
table {
  border: 1px solid #1C6EA4;
  background-color: #EEEEEE;
  width: 100%;
  text-align: left;
  border-collapse: collapse;
  table-layout: auto;
}
table td, table th {
  border: 1px solid #AAAAAA;
  padding: 10px;
}
table tbody td {
  font-size: 13px;
}
table thead {
  background: #1C6EA4;
  border-bottom: 2px solid #444444;
}
table thead th {
  font-size: 15px;
  font-weight: bold;
  text-align: left;
  color: #FFFFFF;
  border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
  border-left: none;
}
</style>

[Jonathan-101]

Hi yes updated and still the same attached to the email

[ekarim2020 · Accepted solution]

The HTML email with the table should look something like this:

If the email doesn't looks similar to the above then the HTML formatting is not being applied.

Please send a screen shot of the update Send an email action.  You can also try deleting the Send an email action, then re-creating it.

Ellis

[Jonathan-101]

Hi sorry - it is working - when viewed in Outlook and not outlook on the web, for some reason the view is not HTML?

When reading email in outlook on the web everything is perfect - thank you