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

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Issue with Sending Emails in Flow

(0) ShareShare
ReportReport
Posted on by 4

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 

Javian_1-1715186078786.png

And this is my flow

Javian_2-1715186147738.pngJavian_3-1715186188114.pngJavian_4-1715186211047.png

 

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

Javian_5-1715186280855.png

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)
  • Verified answer
    rzaneti Profile Picture
    4,241 Super User 2025 Season 2 on at
    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/ 

  • Javian Profile Picture
    4 on at
    Re: Issue with Sending Emails in Flow
    Thanks @rzaneti! This definitely helped solved the issue. Appreciate it

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

Coming soon: forum hierarchy changes

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
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard