Answered

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

(0) Share

Report

Posted on by AkshayManke

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.

Thanks,

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @AkshayManke ,

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

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

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (0)

Report
Copy link

Link copied!

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.
Thanks,

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @AkshayManke ,

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

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

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No