Email notification sent many times

[Fiskan]

I am not sure what is wrong with my flow. It keeps sending multiple email notifications when condition 2 is met. Look forward for any advise 🙂

[creativeopinion]

@Fiskan 
This is because your Send an email (V2) action is nested inside an apply to each loop. Is there a reason you are using an Apply to Each loop? You shouldn't need to use an Apply to Each loop since you are returning a single item from the When an item is created or modified trigger.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[Fiskan]

@creativeopinion Hm, when i recreate my flow without the apply to each, the same still occur. i.e. the email keep sending still. and i noticed a warning. Could you advise what kind of condition i could include? 

My requirement is simple: 

If notice period is not equal to 1 week and pre-approval is not obtained, the request will be auto-reject (also the status will be updated) and email will be sent out. 

I have tried to add this trigger condition (@equals(triggerOutputs()?['body/RunFlow'], true)) under the "When item is created and modified" setting and created a flag. but my issue is when the item is updated, this flag is not going back to the default value = True and will skip the whole flow. 

[Nived_Nambiar]

Hi @Fiskan 

I got why the flow sends the email notification multiple times, when condition2 is satisfied, the Yes branch updates the same list item and sends the email, since the list item is updated it agains the trigger the same flow which causes the flow to trigger.

Also i need to know about the trigger condition which you have placed there , could you give more context of that?

Also looking at update item , you are updating item as rejected, may be we can create a trigger condition which checks whether the item status is rejected, if yes not trigger the flow 🙂 ?

Also show what youa re updating in list item 🙂

Let me know 🙂

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Fiskan]

Hi @Nived_Nambiar ,

Thank you for the input. The trigger condition is for me to set a flag to stop the flow from rerunning. 🙂

But now that you mentioned about using the status field...i am giving it a shot. 

I am trying to add trigger condition as such but got an error: 

Anyway here is my update item details: 

[Nived_Nambiar]

Hi @Fiskan 

put single quotes around the highlighted ones 🙂

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Nived_Nambiar]

Hi @Fiskan 

Also give a try with this trigger condition only 🙂

This will trigger the flow when the status is not rejected

@equals(equals(triggerOutputs()?['body/ApprovedStatusValue'],'Rejected'),false)

Let me know whether it helps you as well 🙂

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Fiskan]

Hi @Nived_Nambiar 

Tried the trigger you recommended above. Hm, not working so far. it sent me 4 same mails so far. haha

[Fiskan]

@Nived_Nambiar  just to add on, even my 2 trigger cond after putting single quotes, it causes runtime for my flow. 😞

[Nived_Nambiar]

Show me the error which you got 🙂

[Nived_Nambiar]

Do you have any update item in no branch as well ?

Kindly let me know ?

[Fiskan]

Here you go @Nived_Nambiar for the no branch flow. and there is no error per se, there is just long runtime. it takes awhile to run and eventually nothing shows up.

[Nived_Nambiar]

Hi @Fiskan 

One question, do you need to trigger the flow only when the item modfiied has Approval Status Value as empty ?

if yes then change the trigger condition to this :

@empty(string(triggerOutputs()?['body/ApprovedStatusValue']))

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌