Skip to main content

Notifications

Power Automate - General Discussion
Answered

Expected to Send Emails According to the Items However those are getting sent Multiple Times

(0) ShareShare
ReportReport
Posted on by

Hello,

 

I have a SP list which is consisting of items in each record. Each item is having an owner, for that I have created a People Field.

 

I have created a flow which runs everyday to check if Status='Open' and the date created is 90 days back, then it is expected to send email to the respective owner of the item as reminder for some actions. This is working perfectly fine. 

 

In addition to that, i want that the owners manager also should get the email. However when i am trying to add the managers name, then it is sending the emails equals to the items which are having status as open. For Example: Open Items: 20, Owner Akshay: 5, then still Akshay is getting 20 email. 

 

I am attaching the snaps of the flow. Can someone please help that where I need to make changes to work that flow as expected.

Snap1.jpgSnap2.jpgSnap3.jpgSnap4.jpg

 

Thanks,

  • AkshayManke Profile Picture
    AkshayManke on at
    Re: Expected to Send Emails According to the Items However those are getting sent Multiple Times

    Hello @v-xiaochen-msft

     

    I removed the parameter and now the flow is working exactly as expected. Many thanks for your help on this. 

     

    Warm Regards, 

  • Verified answer
    Re: Expected to Send Emails According to the Items However those are getting sent Multiple Times

    Hi @AkshayManke ,

     

    As my reply, the send email action is using the parameter from the 'Apply to each' action, so you cannot remove it.

    vxiaochenmsft_0-1666056427452.png

    vxiaochenmsft_1-1666056458089.png

    The 'value' in 'Apply to each' action is an array, and what you used in 'send email' action is rely on it.

     

    Best Regards,

    Wearsky

  • AkshayManke Profile Picture
    AkshayManke on at
    Re: Expected to Send Emails According to the Items However those are getting sent Multiple Times

    Hello @v-xiaochen-msft,

     

    Thanks for the help. However, when I am trying to remove the send email action out of apply to each, it is giving the below message. Could you please help further.

    Capture.JPG

    Thanks,

  • Verified answer
    Re: Expected to Send Emails According to the Items However those are getting sent Multiple Times

    Hi @AkshayManke ,

     

    The root cause is the 'send email' action is in the 'Apply to each' loop.

    vxiaochenmsft_0-1665541643282.png

    Remove the 'Apply to each' action and it will work. 

    Note: If you use the value from 'Get items filtered' action in the 'send email' action, it will nest 'apply to each' action outside the 'send email' action automatically because the output of 'Get items filtered' action is an array.

     

    Best Regards,

    Wearsky

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard