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.