Power Automate Flow to send single email with respective rows related to user

[rpskt]

Hi,

Requirement is to send single email to employee with his respective rows and CC to his respective Manager.

Data from sharepoint list

DOC_ID	Invoice_Num	Employee Email	Manager Email
AB12X	12SUM	11email	22email
SD12Z	1qwe2	12email	33email
asdas	asadsd	11email	22email
SD12Zw	1qwe2w	11email	22email

Expectation:

Employee 1:

DOC_ID	Invoice_Num	Employee Email	Manager Email
AB12X	12SUM	11email	22email
asdas	asadsd	11email	22email
SD12Zw	1qwe2w	11email	22email

Employee 2: 

DOC_ID	Invoice_Num	Employee Email	Manager Email
SD12Z	1qwe2	12email	33email

I have tried with initializing array and append to array but missing something.

Thanks in Advance.

[v-bofeng-msft · Accepted solution]

Hi @rpskt :

Please try this flow:

1\My Data Source is a Excel table

2\My flow

Reference Expression:
1\

union(body('Select'),body('Select'))

2\

items('Apply_to_each')['Employee']

3\

items('Apply_to_each')['Employee']

4\

body('Filter_array')[0]['Manager Email']

Best Regards,

Bof

[rpskt]

Hi @v-bofeng-msft 

This looks like working when manager email in cc not added. 

The requirement is to CC manager email in the single to each employee.

Thanks in advance

[v-bofeng-msft]

Hi @rpskt :

Sorry, expression 4 should be placed under the CC parameter:

body('Filter_array')[0]['Manager Email']

Best Regards,

Bof

[rpskt]

Hi @v-bofeng-msft 

Then, 4 emails are being received.

Just tried this and works.

Is it possible to create HTML table customized with table lines?

[v-bofeng-msft]

Hi @rpskt :

Custom html table is possible.I recommend two methods:

Method1:Customize column in create html action

Method2:First use Select action to get the custom table you want, and then use create html action to automatically generate html table.

Best Regards,

Bof

[rpskt]

Thanks @v-bofeng-msft 

Can we add the same row data per user as an attachment to the email. Please to help.

Thanks