Power Automate sent personalized outlook mails based on Exscel files

(1) Share

Report

Posted on by CU30011646-0

Hi,

I need urgent help. I’m fairly new to Power Automate and need to figure this out as soon as possible. :(

I need to create a Power Automate flow that filters Excel reports for employee logins. Then, a personalized Outlook email with parts of the Excel report is sent to the user. The Excel files (reports) are stored in separate folders on SharePoint. I’ve found two possible solutions:

Create an additional Excel file containing user login, name, surname, email, supervisor email, and manager email. For each user, a personalized email is sent, with the supervisor or manager added in CC.
As far as I know, Microsoft allows retrieving user/employee emails using the "Get user profile (V2)" action. Then, for each user login appearing in the report, a personalized email is sent.

It is crucial that only one email is sent per user, containing all relevant parts of the report. If a user does not appear in the report, no email should be sent.

I have basic access to Power Automate and am not sure if it is possible to create such a solution with my current permissions.

I would appreciate step by step guidance or any help!

Thanks in advance for your help!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

trice602 16,071 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I describe how to "send one email for related rows" in this demo here. It works very well and in production with lots of different ways to make it customizable for your individual solution.

Post | Feed | LinkedIn

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 16,071 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey there!

I am following up on this post power automate sent personalized outlook mails based on exscel files in this category building flows from 01/30/2025. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 1 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 16,071 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No