Email Automation - Need Help

[jasperxx]

Appreciate if anyone could provide guidance on this.

Above is my table in online Excel. I want to create an automated flow that will send user's performance to each of them every day at 6 PM. In the Excel table, the same email address will appear at least 7 rows but each row has a different date of performance. The automation process needs to send these 7 rows of performance to the respective email address in one email rather than 7 emails each day and it won't disclose to other users. Is this possible?

[ManishSolanki]

Hi @jasperxx 

Pls refer my blog which groups the data based on a column & sends a consolidate email:

Single consolidated email to user (owner) for single select user field in SharePoint - Power Platfor...

In the above blog, SharePoint has been used as data source but same logic applies for excel sheet.

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

Thanks

[jasperxx]

Stuck over here:

[jasperxx]

I have tried to fix and the flow successfully run but the recipient receives multiple email despite"UNION " is used. Also, the email content didn't deliver the table content but just the header.

[PurpleMe]

You have send an email action inside apply to each that is the reason it is sending multiple mails. You can select the columns in html step and take it out of apply to each. Copy the dynamic content and paste it directly in create html in first step and then use html output in mail. It will then send one mail with multiple data inside.

[jasperxx]

Sorry. Im quite new to power automate. Not able to picture what you have mentioned. Do you mind showing me the step? Thanks.

[PurpleMe · Accepted solution]

In edit mode, on top right side there is 3 dots, click on three dots and select classic designer, then expand select , filter array , html step n send me a screenshot. I will then try to create a quick one n send it here.

[jasperxx]

[PurpleMe · Accepted solution]

I am not able to upload my pics here due to errors that I am getting but what I am doing is exactly explained here in this link....YouTube.com/watch?v=tp0jLnmKcEs

Let me know if you get any issues. 

[jasperxx]

It works. Thanks.

By any chance, you know how to convert the serial date value such as 45258 to formal date value? Also, any reference to format the html table. 

[PurpleMe]

I didn't understand what you mean by formal value and also there are multiple things that we can do for emails. But what type of format you r looking for? I will add here html table style that will make look good for your email table headers. But you can write different html style too. 

You can copy below and paste first in your email body and then put output of html table body. That will integrate the values automatically.

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

<style> table {   border: 1px solid #1C6EA4;   background-color: #EEEEEE;   width: 100%;   text-align: left;   border-collapse: collapse; } table td, table th {   border: 1px solid #AAAAAA;   padding: 3px 2px; } table tbody td {   font-size: 13px; } table thead {   background: #1C6EA4;   border-bottom: 2px solid #444444; } table thead th {   font-size: 15px;   font-weight: bold;   color: #FFFFFF;   border-left: 2px solid #D0E4F5; } table thead th:first-child {   border-left: none; } </style> Also, you can add footers or so, check this link out.... https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/ Mark this one as solution too that would help others as it's related only.