Send emails by manager's group

(1) Share

Report

Posted on by Wenxi

Hi all,

I'm new to power automate.

I'd like to create a flow that can send emails separately by manager's group. For example, as the screenshot below shows, there will be four emails for four managers (A, B, C, D), and the email content is the same. The recipients of the first email are A, A1, A2,..., A7. For the second email, the recipients are B, B1, B2, B3, B4. and so on...

How should I design this flow? Thank you!

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

v-mengmli-msft on at

Like (2)

Report

Hi @Wenxi ,

Please try this.

Best regards,

Rimmon

Was this reply helpful? Yes No
Wenxi 36 on at

Like (1)

Report

Hi @v-mengmli-msft ,

Thank you.
I tried this but got an error. When I added the second "select", another "apply to each" appeared automatically.

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

Like (1)

Report

Hi @Wenxi ,

Please use expression instead of dynamic content.

Best regards,

Rimmon

Was this reply helpful? Yes No
Wenxi 36 on at

Like (1)

Report

Hi @v-mengmli-msft ,

It's working! Thank you.
By the way, I'd like to add the manager's email as well. However, it seems like "concat" should not be used here. What action should I add?

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

Like (1)

Report

Hi @Wenxi ,

You can try join.

Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Best regards,

Rimmon

Was this reply helpful? Yes No
Wenxi 36 on at

Like (1)

Report

Hi @v-mengmli-msft ,

I tried "join" but got an error.

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

Like (1)

Report
Hi @Wenxi ,

Do you want to send an email to all managers?

Please try this.

join(union(body('Select'),body('Select')),';')

Best regards,

Rimmon

Was this reply helpful? Yes No
Wenxi 36 on at

Like (1)

Report

Hi @v-mengmli-msft ,

Not one email to all managers.
The manager and their group members are in the same email. For example, the first email is to Manager A and all the team members who report to Manager A.

Was this reply helpful? Yes No