Send email to corresponding engineer

[da_1299]

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. 

Thank you.

[v-bofeng-msft]

Hi @da_1299 :

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

My Flow

The Result

Best Regards,

Bof

[da_1299]

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

[v-bofeng-msft]

Hi @da_1299 ：

Please put the formula into the "Expression"

Best Regards,

Bof