Answered

Issue with Sending Emails in Flow

(0) Share

Report

Posted on by Javian

Hi Everyone,

I'm a novice and I'm attempting to a flow where I send one email to a user with multiple rows of data. So I have the data below

And this is my flow

The problem I am having is that when I tested initially with just my email, it went through fine as this:

But when I changed it to the current data set, the email is no longer being sent. So how do I get to send one email to each user concatenating all their apps?

Please note, I did not use the recipient email because I'm not sure how to

And also, how do I get to customize the table?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Re: Issue with Sending Emails in Flow

Hi @Javian ,

Try to use this expression in the "To" input from "Send email" action: body('Filter_array_for_employee)[0]['Email']. This expression is capturing the first record from your filtered array, and accessing its email property.

Also, I wrote a blog post exploring a very similar use case (send data extracted from an Excel table by email): http://digitalmill.net/2023/10/11/how-to-send-notifications-from-multiple-excel-records-to-the-same-email-with-power-automate/

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

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
Javian 4 on at

Like (0)

Report

Re: Issue with Sending Emails in Flow

Thanks @rzaneti! This definitely helped solved the issue. Appreciate it

Was this reply helpful? Yes No