cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
da_1299
Helper I
Helper I

Send email to corresponding engineer

Hi All,

 

I would like to send out email reminder to corresponding 'Engineer' about the overdue date of the item. I would like to ask how can I generate a flow to send a html table to the corresponding engineer about the overdue items? Also, as the email address are duplicated, how can I send only 1 email to 1 supervisor about the overdue date. 

 

For example, from the below sharepoint list, Engineer Eda will receive 1 email with the html list showing Da, Eda items are expired. Engineer ho.wk will receive 1 email with the html list showing Kei item is expired. 

 

Picture1.png

Thank you.

 

3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

Hi @da_1299 :

I've made a test for your reference:
I assume there is a SP list named Da1299

v-bofeng-msft_0-1623135245209.png

My Flow

v-bofeng-msft_6-1623136828954.png

v-bofeng-msft_3-1623135628642.png

v-bofeng-msft_4-1623135680634.png

The Result

v-bofeng-msft_7-1623136886330.png

Best Regards,

Bof

 

 

 

I would like to how to select the items('Apply_to_each')?['EngineerEmail'])?

Hi @da_1299 :

Please put the formula into the "Expression"

vbofengmsft_0-1625635253145.png

Best Regards,

Bof

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,031)