cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AkshayManke
Continued Contributor
Continued Contributor

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

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,

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

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

View solution in original post

v-xiaochen-msft
Community Support
Community Support

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

View solution in original post

4 REPLIES 4
v-xiaochen-msft
Community Support
Community Support

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

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,

v-xiaochen-msft
Community Support
Community Support

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
Continued Contributor
Continued Contributor

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, 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,433)