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 : C1iZ6otwtQFgV3HwAU3olF
Power Automate - Building Flows
Answered

Excel Email Workflow - Multiple Email Notifications

Like (0) ShareShare
ReportReport
Posted on 11 Feb 2020 15:28:01 by 15

Hello,

 

I am in the middle of creating an email notification workflow through sharepoint/excel online. The workflow is successful, however it only sends me a notification for the first item that matches. I need a notification for each individual item that matches my condition from the excel table and for that notification to be sent to the email address in the same row. I have attempted to use the "apply to each" condition, but it just ends up sending me multiple emails about the same row.

 

Can someone explain in laymen terms how to achieve this? Review Example.pngREVIEW TESTER 2.PNG

(Photo's attached)

 

I really appreciate your help!

 

I have the same question (0)
  • LSmarie Profile Picture
    15 on 11 Feb 2020 at 17:06:29
    Re: Excel Email Workflow - Multiple Email Notifications

    @Jcook  That worked and was so easy! Thank you for your help!

  • Verified answer
    Jcook Profile Picture
    7,779 Most Valuable Professional on 11 Feb 2020 at 16:50:58
    Re: Excel Email Workflow - Multiple Email Notifications
    Sorry,

    Instead of using get row. Which gets 1 row, could you try using Lost rows present in table

    —Josh
    If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
  • LSmarie Profile Picture
    15 on 11 Feb 2020 at 16:49:07
    Re: Excel Email Workflow - Multiple Email Notifications

    @Jcook I have added the steps that you listed. I am receiving multiple emails, all containing the exact same information. 

     

    For example,

    If there are three stores that are marked "overdue" I am getting three separate emails all containing the information for only one store. 

  • Jcook Profile Picture
    7,779 Most Valuable Professional on 11 Feb 2020 at 16:39:03
    Re: Excel Email Workflow - Multiple Email Notifications
    Hello,

    Add an Apply to each under the get row and use the excel get row value in the apply to each loop.

    Additionally add the steps under the get row into this loop.

    —Josh
    If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 840 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 712 Super User 2025 Season 2

#3
stampcoin Profile Picture

stampcoin 373 Super User 2025 Season 2

Last 30 days Overall leaderboard