cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jonathan-101
Helper V
Helper V

One notification for all items in list

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 🙂

 

1.PNG2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

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

Snag_7a8fda.png

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

View solution in original post

9 REPLIES 9
tom_riha
Super User
Super User

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.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
ekarim2020
Super User
Super User

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

ekarim2020_0-1642106107608.png

 

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

Snag_589fbc8.png

 

Snag_585e304.png

Snag_5863c8e.png

 

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

Snag_5867ddd.png

Snag_586cd54.png

The compose actions:

Snag_597b41d.png

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
Helper V
Helper V

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 flow1.PNG2.jpg3.PNG4.PNG5.jpg

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.

Snag_5a8518.png

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

ekarim2020_0-1642157537202.png

 


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

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

 

Email.jpg

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>

 

Hi yes updated and still the same attached to the email

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

Snag_7a8fda.png

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

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,407)