Hi, Could you please suggest me some solution to resolve the below problem using power automate flows.?
I have a excel with below three rows
Col1 | Col2 |
ABC | mail_id_01 |
ABC | mail_id_02 |
XYZ | mail_id_01 |
1. If Col1 has duplicate rows then I want to concatenate email ids from Col2 (To: mail_id_01;mail_id_02) and send single email with the unique ABC value in the mail body.
2. If Col1 has no duplicate then I want to send single mail (To; mail_id_01) with the XYZ value in the mail body.
Thanks,
Suresh