Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
How can we create a Power Automate Flow to send email to the desired/selected person with the details from the table wherever their name(or any unique value) appears in the input Excel file.
Condition: Even if the name appears multiple times in the given list/table, only single email should go to the person with all the details in the email body (multiple rows with their details) as shown in examples below:
Sample Input Data in excel file table:
| Emp Name | Hours Worked | Month | Emp ID | Email ID | Project St. Dt | Level | Final Client |
| Deepika | 40 | Sep | 12345 | Deepika@xyz.com | 17-Jul-21 | Lead | ABC |
| Deepika | 45 | Oct | 12345 | Deepika@xyz.com | 17-Jul-21 | Lead | ABC |
| Ramesh | 54 | Sep | 45678 | Ramesh@xyz.com | 13-Oct-21 | Manager | DEF |
| Ramesh | 54 | Oct | 45678 | Ramesh@xyz.com | 13-Oct-21 | Manager | DEF |
| Reddy | 47 | Oct | 34567 | Reddy@xyz.com | 17-Sep-21 | Analyst | CDE |
| Reddy | 37 | Nov | 34567 | Reddy@xyz.com | 17-Sep-21 | Analyst | CDE |
'Emp Name' Filter Given: 'Deepika'
Desired Output in the Email Body:
| Emp Name | Hours Worked | Month | Emp ID | Email ID | Project St. Dt | Level | Final Client |
| Deepika | 40 | Sep | 12345 | Deepika@xyz.com | 17-Jul-21 | Lead | ABC |
| Deepika | 45 | Oct | 12345 | Deepika@xyz.com | 17-Jul-21 | Lead | ABC |
Example 2:
'Emp Name' Filter Given: 'Reddy'
Desired Output in the Email Body:
| Emp Name | Hours Worked | Month | Emp ID | Email ID | Project St. Dt | Level | Final Client |
| Reddy | 47 | Oct | 34567 | Reddy@xyz.com | 17-Sep-21 | Analyst | CDE |
| Reddy | 37 | Nov | 34567 | Reddy@xyz.com | 17-Sep-21 | Analyst | CDE |
At the bare minimum you need a key column in your Excel that uniquely identifies a row. Otherwise Power Automate will not be able to do that.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |