Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Powerautomate - Excel file data - sending email multiple times

(0) ShareShare
ReportReport
Posted on by 9

I have a flow and this last section is not working as expected. I want to email the team leader, for each entry in the "body" variable. The leader's name is saved in the data, so I used the search for users block to find their email.

 

 

nicksawe_0-1679565384911.png

 

However, The moment I add a send an email block using the add an action link at the bottom, it creates another Apply to each block ! It then looks like this:

 

nicksawe_1-1679565625451.png

 

How do I avoid this, please? In the search for users block I have even set the threshold to 1, hoping this will only return one email but I still get the issue.

 

nicksawe_2-1679565873514.png

 

Thanks

 

 

 

 

 

 

  • Verified answer
    nicksawe Profile Picture
    9 on at
    Re: Powerautomate - Excel file data - sending email multiple times

    hi @v-chengfen-msft , Thanks for your reply. I ended up solving this by adding a Select and compose ( I think compose alone would have worked as well) before the email. So it now looks like this

     

    nicksawe_0-1679655010183.png

     

    Thanks

  • v-chengfen-msft Profile Picture
    on at
    Re: Powerautomate - Excel file data - sending email multiple times

    Hi @nicksawe ,

    Can you tell me that you are sending emails to the leader of each record, are there multiple records for the same leader?

    Can you show the apply to each for search user when the flow is executed?

     

    Best Regards

    Cheng Feng

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1