Flow - Send email to everyone, not just the birthday person

(0) Share

Report

Posted on by Joaoandrebs

361

hello everybody,

I have an extremely simple flow for sending birthday e-mails, I have a SharePoint list with all the birthday people and their e-mails. However, when sending the email, I would like it to be sent to ALL team members, and not just to the person who celebrates the birthday.

Something I couldn't think of straight...

Look the sequence,

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!
To send the birthday email to all team members, you can modify your flow to include all team members in the "To" field of the email. Here's how you can do it:
Get all team members' email addresses: You can use an Office 365 Users connector action "List all users" to get all the users in your team and their email addresses. You can filter the list to only include users whose email addresses are not empty.
Concatenate email addresses: Use the "Expressions" tab to create an expression that concatenates all the email addresses into a single string. For example, you can use the expression join(body('List_all_users')?['value'], ';') to concatenate all the email addresses separated by semicolons.
Send the birthday email: Use the "Send an email (V2)" action to send the birthday email. In the "To" field of the email, use the expression from step 2 to send the email to all team members.
Here's an example flow:
"When an item is created or modified" trigger on the SharePoint list with birthday people.
"List all users" action from the Office 365 Users connector to get all team members.
"Compose" action to create the email body with the birthday message.
"Compose" action to create the email subject.
"Compose" action to concatenate all the team members' email addresses into a single string.
"Send an email (V2)" action to send the birthday email to all team members. Use the subject and body from steps 3 and 4, and the email addresses from step 5 in the "To" field.
I hope this helps!

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@JohnM86 I understand, would you have an example to send a print? grateful

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

you dont need the compose action though - then add your send email and set the 'to' as the join output

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@JohnM86 ahh ok this alternative is cool, but I don't know if you understand, I already have the list of these emails in the sharepoint list, I have a column called email, so I think the solution would be simpler. (98 e-mails)

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

would be a similar concept, swap out the search users - put a SharePoint Get Items connector, use the SharePoint connect 'Value for the select - add the email column in select and follow the same process

Was this reply helpful? Yes No