undefined

[Syndicate_Admin]

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

[lbendlin]

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.