web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to send email with...
Power Automate
Unanswered

How to send email with the list of all people - Power Automate

(0) ShareShare
ReportReport
Posted on by 119

There are some tutorials that explain how to email someone on their birthday. What I am looking for is to send a single email with the list of all the people who celebrate their birthday that day.

I would like to know how I can send in the body of the email the name of the people who celebrate their birthday on that day.

I have been working on a flow with each of the following steps:

 

sebastianslz_2-1643318854615.png

 

Recurrence:

With this step I send my daily mail every certain hour.

 

Get items:

I created a sharepoint list where I have the name of the birthday boy, date of birthday (DOB), gender and department.

sebastianslz_3-1643318888876.png

 

Initialize variable:

sebastianslz_4-1643318922358.png

Apply to each:

sebastianslz_5-1643318951050.png

 

Append to string variable:

I add to the Birthdays variable the value that would be the name of the employee whose birthday is that day that is in the sharepoint list.

sebastianslz_6-1643318976780.png

Send an email

In the step of sending an email, I add the previously initialized variable "Birthdays" to the body of the email, which should contain the list of employees whose birthday is that day.

sebastianslz_7-1643319000735.png

 

I have supported myself with this question made in the Microsoft Power Automate forum but it does not work as it should since I am new to power automate.

Error:

At the moment of executing my manual flow I get in the condition as a result false in addition to two errors when I add the variable and send the mail.

sebastianslz_8-1643319066717.png

Can someone give me an orientation in knowing what I am doing wrong in the flow since my mail does not arrive either.



 

 

 

 

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    AntoniaOrm Profile Picture
    9 on at

    Hey, 

     

    Try changing your compose to this and separate your information in month-day-year by colums so you ca grab that info.  

    AntoniaOrm_0-1675364546322.png

    After, you can send email, but out side of the apply to each. like this:

    AntoniaOrm_1-1675364675265.png

    It works for me. Hope this helps. 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard