Answered

flow to combine content and send email to unique users

(0) Share

Report

Posted on by pailin

Hello, I'm trying to send a reminder email to many users.
Basically I have this output compose indicate user emails and thier project IDs.

{"Email": "user1@abc",

"ID": "198"},

{"Email": "user1@abc",

"ID": "203"},

{"Email": "user2@abc",

"ID": "205"},

{"Email": "user2@abc",

"ID": "222"},

{"Email": "user3@abc",

"ID": "254"},

For example, I want to send an email to user1@abc, inform that he has ID 198 and ID 203, then send email to user2@abc that hehas ID 205 and 222, and send email to user3 that he got ID 254.

Thank you in advance!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @pailin
According to your description, you want to filter the array and send the email to the users.
This is my test flow you can refer to (i use the classic power automate developer page):

(1)The Compose 3 action is used to create my test data:
(2)Select action is used to extract the Email :
(3)The Apply to each action:
union(body('Select'),body('Select'))
item()?['Email']

. If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
pailin 13 on at

Like (0)

Report
Copy link

Link copied!

That's works really fine! thank you 😄
1 more question according to this, If I have another table that indicate the name of all these project ID
example:
ID : Name
198 : AAA
203 : BBB
205 : CCC
How can I extract the name to send email with those ID above?

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, @pailin
Thanks for your response! This is my new test flow:

(1)Compose 3 and Compose 4 are used to create test data:

(2)The initialize variable action:

(3)The "Apply to each 3 " action:

item()?['ID']
items('Apply_to_each_3')?['ID']
json( concat( '[' , string( items('Apply_to_each_3') ) , ']' ) )
item()?['Email']
body('Filter_array_2')?[0]?['Name']
body('Select_2')?[0]

(4) The Select action is the same as above:

(5)The "Apply to each 2" action:

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

You may need to replace your action name in your side.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No