Skip to main content
Community site session details

Community site session details

Session Id : 6W3cBRMRXmzs1YMdzye8WL
Power Automate - Building Flows
Unanswered

When Item Modified - Updated Item - do not trigger first condition

Like (0) ShareShare
ReportReport
Posted on 27 Aug 2019 14:39:19 by 48

 

Hi there...this is driving me a bit batty..

 

I am trying to create a flow that does the following

  1. Allows a user to input some basic information into a new or existing item.
  2. The flow will then calculate some fields and update the item
  3. The flow will send send an email to the project manager that the item was updated or modified or created

What is happending is that the step item 2, is triggering item 1, and everyone wakes up with a hundred emails in their inbox lol.

 

Is there a way to implement this workflow without triggering itself?

  

 

Capture.PNG

  • Leo_NYC Profile Picture
    48 on 28 Aug 2019 at 11:40:17
    Re: When Item Modified - Updated Item - do not trigger first condition

    Does Microsft have a form that we could use to perform the math functions before updating the item?  Maybe that could be an answer.

  • Leo_NYC Profile Picture
    48 on 28 Aug 2019 at 11:38:59
    Re: When Item Modified - Updated Item - do not trigger first condition

    Hi Alice,

     

    Thanks for much for your idea, I will try it out.

     

    The main concern is that I will have about 10 employees hitting that list so each one of them will have to be trained on something new (maybe this is why i am seeing all those "employee on-boarding" apps pop up everywhere).

     

    The goal of the flow is to have employees input basic information into the list without having to do too much math or thinking.  Here is the specific scope

     

    1. Employees enter in Customer information including the price of a project and click save.

    2. Upon saving, a "new or modified item" will be triggered, and the Flow would then take that information, specifically the price and split it up into three bins using some math, and update the item

    3. The second update causes step 2 above to repeat itself ad nauseum

     

    I could put in that step that the "mofiedbyflow" variable be reset to false after each update in step 2 above, and I guess clicking yes/no is easier than doing math.  However if the employee forgets to click the yes button then the automation comes to a halt.

     

    Microsoft should have an "edit item" function.  The "Edit Item" would not trigger an update, while the "Update Item" function will......that would solve everything I would think.

  • v-alzhan-msft Profile Picture
    on 28 Aug 2019 at 06:15:55
    Re: When Item Modified - Updated Item - do not trigger first condition

    Hi @Leo_NYC ,

     

    You could add a Modifybyflow field with Yes/No type in the list, add set the default value of Modifybyflow field to No, and everytime when manually add or modify an item in the list, keep the Modifybyflow field to No.

     

    Then in the flow you could:

    1. Add a Condition to check if the value in the Modifybyflow field is equal to false, if yes, do everytime you want to do in the If yes branch of the condition, leave the If else of the Condition blank.

    2. Everytime use a "Update item" action in flow, change the Modifybyflow field to Yes.

     

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Pstork1 Profile Picture
    67,351 Most Valuable Professional on 27 Aug 2019 at 15:19:30
    Re: When Item Modified - Updated Item - do not trigger first condition

    Sorry, no there isn't. I agree it's a pretty obvious need, but there is no regular action available to do it at this point other than using a REST call.  This has been requested before and the product team has declined the idea.  ou can read a full discussion of it here:

    https://powerusers.microsoft.com/t5/Flow-Ideas/Disable-Event-Firing-when-Flow-updates-a-SharePoint-list-item/idi-p/100399#comments

  • Leo_NYC Profile Picture
    48 on 27 Aug 2019 at 14:56:14
    Re: When Item Modified - Updated Item - do not trigger first condition

    Thank you so much for your response.

     

    Is there any way of doing this without having to learn how to code?  It seems like a simple and common requirement.

     

     

     


    @Leo_NYC wrote:

     

    Hi there...this is driving me a bit batty..

     

    I am trying to create a flow that does the following

    1. Allows a user to input some basic information into a new or existing item.
    2. The flow will then calculate some fields and update the item
    3. The flow will send send an email to the project manager that the item was updated or modified or created

    What is happending is that the step item 2, is triggering item 1, and everyone wakes up with a hundred emails in their inbox lol.

     

    Is there a way to implement this workflow without triggering itself?

      

     

    Capture.PNG


     

  • Pstork1 Profile Picture
    67,351 Most Valuable Professional on 27 Aug 2019 at 14:48:34
    Re: When Item Modified - Updated Item - do not trigger first condition

    If you do the update using an HTTP REST call and include the bNewDocumentUpdate set to false then it won't fire the update trigger.  Here's a BLOG post on how to update a sharepoint item without firing update.

    http://johnliu.net/blog/2019/2/flowninja-hack-78-modifying-modified-by-and-modified-time-with-microsoft-flow

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete