Power Automate - Building Flows

Automatically send emails from Excel with PowerAutomate

Like (1) Share

Report

Posted on 21 Mar 2025 12:12:01 by HM-21031206-0

Hello,

I have followed instructions on this site to send automate emails from Excel.

https://www.myonlinetraininghub.com/automatically-email-reminders-from-excel-with-power-automate

Is there a way of adding person name in the body of email? e.g. I have a column in excel table Forename, so would want name to show in email, e.g. Dear Bob.

The email column is Person_Email_Add and the other columns are Forename, Surname, ID, Supervisor_email_add

The flow works fine, also is there a way of adding CC in the email from the field from the excel table Supervisor_email_add?

Thanks in advance.

Categories:

Business Process Flows

All responses (2)

Answers (0)

Suggested answer

rzaneti 4,085 Super User 2025 Season 1 on 27 Mar 2025 at 17:45:37

Like (0)

Report

Automatically send emails from Excel with PowerAutomate

Hi @HM-21031206-0,

Inside the email body input, you can combine both dynamic and static content. For your use case, you can simply add the dynamic content corresponding to the Forename column in the body, like this:

You can also refer to the following videos and blogs related to your issue (the first video and the first blog explore a very similar scenario to yours, combining dynamic and static content in the email body):

- Video: How to send emails from multiple Excel records with Power Automate: https://youtu.be/jzwoA0d8qW4

- Video: Using dynamic content in Power Automate: https://youtu.be/jpledJfaEPQ

- Blog: How to send bulk emails from an Excel table using Power Automate: https://digitalmill.net/2025/03/17/how-to-send-bulk-emails-from-an-excel-table-using-power-automate/

- Blog: Using loops and accessing array elements in Power Automate: https://digitalmill.net/2023/07/12/using-loops-and-accessing-array-elements-in-power-automate/

For the CC, you can simply show the input from the Advanced Parameters, click in Switch to advanced mode and use the dynamic content for Supervisor_email:

Let me know if it works for you or if you need any additional help!

If this is the answer to your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

Check more Power Platform content on my website.
Lets connect on LinkedIn.
Michael E. Gernaey 42,633 Super User 2025 Season 1 on 27 Mar 2025 at 17:19:44

Like (0)

Report

Automatically send emails from Excel with PowerAutomate

Hi @HM-21031206-0

While maybe others will, most of us are not going to look at that video. It doesn't for sure show us what you did. We need you to share your flows, your data, your inputs and outputs, your logic and explain it, not ask us to get it from a video.

Community site session details

Automatically send emails from Excel with PowerAutomate

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Automatically send emails from Excel with PowerAutomate

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates