Answered

send only one email to list of multiple email addresses

(0) Share

Report

Posted on by da_1299

Hi all,

I would like to ask how can I make use of the flow to send one email to list of multiple email addresses as there are email address appeared 100 times so I don't want to send 100 emails to him.

At first, I have used 'get items' and its filter query is sent to filter only expiry date is less than a week.

And make use of 'compose' with the equation is the length(outputs('Get_items')?['body/value'])

And then I use apply to each to send email with the to column is inputting the 'supervisor email' which is a column with email address text stated in the shairpoint.

May I know how can I achieve it?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @da_1299 ,

I did a simple test for you.

Value:

union(variables('Thevar'),variables('Thevar'))

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
da_1299 28 on at

Like (0)

Report
Copy link

Link copied!

Thank you.
As I had used filter function to filter out the date already, May I know is it possible for me to start right after the compose variable? (with the equation is the length(outputs('Get_items')?['body/value']))

Thank you.

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

Like (0)

Report
Copy link

Link copied!

Hi @da_1299 ,

I am not very clear what your question is. I don't know why compose is used here. What is its purpose?

If there are many duplicate emails in your Email column, please try my method.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
da_1299 28 on at

Like (0)

Report
Copy link

Link copied!

I have a sharepoint list with the data containing deadline and the student email address about the assignments. I would like send an email reminder to the student a week before the deadline. However, when the student have lots of assignments needed to be handed in on that day, instead of sending 10 emails to that student, I would like to send one email to that student. May I ask how can I achieve this?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @da_1299 ,

Please try this:

This is my list. 'DateColumn' is a Date column.

This is my flow.

1. formatDateTime(addDays(item()?['DateColumn'], -7), 'yyyy-MM-dd')

2. formatDateTime(utcNow(), 'yyyy-MM-dd')

3. [{"TestEmail":"a","Subject":"a"}]

4. union(variables('Var1'),variables('Var1'))

Its result:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
da_1299 28 on at

Like (0)

Report
Copy link

Link copied!

what should I choose for the current item in the email? And also what should I enter for the last set variable value?Thank you.

Was this reply helpful? Yes No