Flow keeps sending emails every minute

(0) Share

Report

Posted on by MN003

441

Good Morning,

I built a second flow that is intended to send an email to an appropriate person if a user cancels their SharePoint list item/approval request. I set it up to how I thought it would work but it keeps sending emails every minute based on the result of the condition. Anything I'm missing here?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report

Re: Flow keeps sending emails every minute

Hi @MN003

As far as I can see, you've created a loop where your flow in condtion "no" updates an item which again triggers your flow again? Or that you have some other flow running with a one minute reccurance which updates the information in your sharepoint list.

{ If my post answered your question, please Accept it as a solution ✔ }
{ This will in turn help others find solutions to similar questions }

Best Regards
Heartholme

Was this reply helpful? Yes No
MN003 441 on at

Like (0)

Report

Re: Flow keeps sending emails every minute

Hi @Heartholme

Thanks so much for your response. I modified my flow to the below. Do you think this would eliminate the looped email issue?

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report

Re: Flow keeps sending emails every minute

Hi again @MN003 ,

It's a bit hard for me to tell from this screenshot, but at first glance it looks better. Please check if this did the trick and if not I need to know which columns the updateitem to assist you further I think.

Was this reply helpful? Yes No
MN003 441 on at

Like (0)

Report

Re: Flow keeps sending emails every minute

Understood. Still isn't working like I hoped :(. Here is the update item from within this flow.

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report

Re: Flow keeps sending emails every minute

@MN003

I see, the issue is still that you have status value here to cancelled here:

So when your flow sees that update item sets it to cancelled it will first of all run the flow again, because it triggers on an item being modified. Since the item is still set to cancelled it will end up the same place, and therefore send the email over and over again.

So if you change the item state to for example "completed" in your update item, you should solve the issue 😊

If you are satisfied with the result, please Accept my post as a solution. This will in turn help other find solutions to similar questions.

Best Regards
Heartholme

Was this reply helpful? Yes No
MN003 441 on at

Like (0)

Report

Re: Flow keeps sending emails every minute

This time it ran 3 times (I have 3 items on the SPO list), but this was the result 😞
I'm not sure if it may be related to a cancel button I have in my Power Apps form in SharePoint. When a user clicks the button, it updates the IsCancelled field to yes.

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report

Re: Flow keeps sending emails every minute

@MN003

This is a strange case. I see that every value is updated in your last SP action, so maybe for some reason that trigger the flow again 3 times. I would try to quickly rebuild the flow and see if the issue persists. Similar issues here:
https://powerusers.microsoft.com/t5/General-Power-Automate/Automated-SharePoint-Item-Edit-Flow-launching-multiple-times/td-p/354915
https://powerusers.microsoft.com/t5/Building-Flows/RESOLVED-Flow-running-multiple-times-for-when-bulk-items-added/td-p/833715
Sorry that I couldn't be of more help here.

Was this reply helpful? Yes No
MN003 441 on at

Like (1)

Report

Re: Flow keeps sending emails every minute

Thanks very much for trying to help and providing some resources I can look through. Hopefully I'll figure something out 🙂

Was this reply helpful? Yes No