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 / Triggered flow sending...
Power Automate
Unanswered

Triggered flow sending multiple emails instead of just one.

(0) ShareShare
ReportReport
Posted on by 3
Hi Guys,
 
Would appreciate a hand with a flow I can not work out. 
 
I have created a "when a new response is submitted"  triggered flow. In the MS Form that triggers the flow, Question 1 is in check-list format and asks the user to select who is the sender of the form. The answer to that question will determine what data to use in a row in an excel table to later populate the email signature in the email. The flow is successful but it sends multiple emails from all senders listed in the excel table instead of only the one I selected in the form.
 
I have asked ChatGPT many times and can not solve the problem. It seems to revolve around the Filter Array. ChatGPT tells me to add a Compose, but doesn't resolve the issue.
 
Note: Currently the email comes from my email account, but that is just for testing until I iron this out.
 
Please see screen shots of the flow in edit mode and the actions details:
 
 
Would appreciate some help. :)
Categories:
I have the same question (0)
  • stampcoin Profile Picture
    5,058 Super User 2025 Season 2 on at
     
    You can delete the for each,  use first() function to get the value, in this way you won't get for each.
     
    for example, if your excel has column named Email, you can try
     
    first(body('Filter_array'))?['Email']  formulafor send an email (v2)
     
     

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 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard