web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint Flow turned...
Power Automate
Unanswered

SharePoint Flow turned off, Items added to list, turned flow on, it fired for all items.

(2) ShareShare
ReportReport
Posted on by 17

Hey, I created a Flow on SharePoint list, it sends email notification to different users on the basis of different data fields. Now I wanted to add some records in such a way it does not send any notification. I turned off the flow and made the changes to the list by adding new items. But as soon as i turned the flow on it started running for the new items which I added while flow was off. Is it the right behavior? If so then what is the purpose of turning it off? How can I achieve this that flow does not operate when I put it off?

Categories:
I have the same question (0)
  • v-yamao-msft Profile Picture
    on at

    Hi @smyjafri,

     

    When testing this issue, it returns the same result as you mentioned. Though I turned off the flow to make changes on the list, but it started running as soon as I turned on the flow for the changes I made on the list.

     

    There is a similar request on the Flow Ideas Forum, please vote the idea at here, PGs will take hot ideas into consideration in the future releases:

    https://powerusers.microsoft.com/t5/Flow-Ideas/Turning-off-Flow-and-turning-back-on-still-create-new-instances/idi-p/71672

     

    Besides, I will help confirm this issue on my side further.

     

     

    Best regards,

    Mabel Mao

  • Verified answer
    ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    @smyjafri:

     

    One work around might be to edit your Flow and put a Control-Terminate action at the top of the Flow immediately following the trigger and save it.  That way, the Flow will run but won't send out any emails or otherwise cause issues while you are adding the new items.  When you are through adding the new items, remove the Control-Terminate action and save.  I am assuming that the Flow will not be turned off.

     

    If this works for you, please mark your question as Solved.

     

    Scott

  • Verified answer
    smyjafri Profile Picture
    17 on at

    Thank you @ScottShearer. I do not know wether its a right solution or not but this is definitely a super workaround. It worked for me.

    Thank. 

    Once again thanks @ScottShearer and @v-yamao-msft for the help and replying.

  • SJNBham Profile Picture
    51 on at

    A workaround we figured out is to disable the workflow, import/update the list data, make a copy of the disabled workflow, delete the original workflow, and then turn on the new copy of the workflow. The tracking of whether an item has a pending create/update event seems to be tied to the original workflow. If you use the terminate action method instead, you'll end up with potentially tens of thousands of workflows that fire and don't do anything but terminate. However, those workflows take time to complete and count toward limits. It would be great if Microsoft provided an option to turn off a flow and select whether create/update events should be tracked while the flow is disabled. 

  • alexfilipovici Profile Picture
    on at

    You may temporarily set a conditional trigger, e.g. 

    @equals(1,0)

    Then, add the items and remove the condition from the trigger.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard