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

(0) Share

Report

Posted on by 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.

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (2)

Report

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

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

Was this reply helpful? Yes No
rpskt 32 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

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

Hi @rpskt :

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

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

Best Regards,

Bof

Was this reply helpful? Yes No
rpskt 32 on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
rpskt 32 on at

Like (0)

Report

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

Thanks @v-bofeng-msft
Can we add the same row data per user as an attachment to the email. Please to help.

Thanks

Was this reply helpful? Yes No
ak121 17 on at

Like (0)

Report

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

If a cell contains multiple emails, how can an email be sent separately to each individual?
ID Name email
1 aa email1@abc.ocm; email2@abc.com
2 bb email2@abc.com
3 cc email3@abc.ocm
output
to email1@abc.com - 1 aa
to email2@abc.on 1 aa
2 bb
to email3@abc.com 3 cc

Was this reply helpful? Yes No