I have a SharePoint library, we'll call it Library "Test". I have a custom approval (NOT using the approval actions in FLOW) process I built using standard SharePoint and Office 365 Connectors. The FLOW has some delays in it as well.
The FLOW triggers on "When a file is created or modified (Properties only). The problem is that the workflow may run for a few days, waiting for a status change. If Joe User comes along and makes a change to the file or to any of it's properties...that kicks off the FLOW again. I don't want that (in SharePoint Designer, you could only have one instance of one workflow running on an item or on a document and it's properties at a time. If somebody modified the list or library item while a SPD workflow another instance of the workflow running - quick note for Microsoft...I've been noticing that FLOW offers some GREAT functionality, but it misses huge too often when it comes to SharePoint which I would presume is the primary platform for FLOWs. If that presumption is correct, I'm hoping to see the FLOW team do some focused analysis on what is left to cover
to make sure FLOW is solid when it comes to SharePoint and does everything that Designer did - I digress, but only because I have a certain level of passion around workflows) to happen. This ends up creating an infinite loop, because actions inside the workflow that write back to the underlying library (changing column values) start up a new instance of the workflow.
Is there a workaround to stop this infinite loop?
I don't think there is...in the event I'm correct in my understanding...it would be great (super useful) to have the choice to be able to configure a global setting for the workflow...something like this:
Check this box to only allow one instance of this workflow to run at a time (if this workflow is running and is triggered again, the subsequent workflow will be terminated).
Check this box to allow multiple instances of this workflow to run at the same time (if this workflow is running and is triggered to run again, the trigger will be successful and a 2nd instance of this workflow will begin. There is no limit to the number of workflow instances that can run simultaneously).
Thank you for your hard work FLOW team. You have a useful, feature rich product. Hoping to see it become a little tighter within SharePoint and with global settings.
Have you tried the trigger “When a file is created(properties only)”? Will it meet your needs? Using this trigger, your flow will be only triggered when a file is created but not updated.
When using the trigger “When a file is created or modified(Properties)”, to stop the flow to be triggered when the file or any other properties are modified, you may add a Condition to check if the Created time is equal to Modified time.
If they are equal, it means that the file is newly created, if they are not equal, it means that there are some modifications on the file.
After the Condition, you could add other action under If yes/If no branch according to your needs.
Please take the following screenshot for a reference:
Please have a try with it and feel free reply if you need more help.
Thank you for your help, but my issue is a little different. Well after the file is created and person A modifies the file properites, then 4 minutes later person B modifies the properties...I want the workflow to NOT run because there is already an instance of it running.
Ideally this would be a global setting as there could be times where I would want multiple instances of the same FLOW running concurrently. But in my use case above, I do not.
Thanks for clarification.
My understanding is that you just want the flow triggers for one modification but not every time a modification happens.
I am afraid that it might be not possible, the trigger “When a file is created or modified” will trigger the flow whenever a new file is created or a modification happens.
You may consider submitting your request at Flow Ideas Forum, hope PGs will take it into consideration in future releases:
i've hit the same roadblock. I am reverting back to SP designer and WF2013. I was not able to find a workaround.
There are a ton of scenarios when the item is modified and it is absurd that the whole flow runs tom-to-bottom.
We need single-instance workflows badly. If anyone has managed to find a solution please post it here.
My workaround was to:
I'm not using this solution in production, because it is too hard to maintain. 7 workiflows with lots of logic...if something breaks or needs to be added, I'd be in trouble.
Yes, I hope they add a feature to allow concurrent instances of the same workflow or not allow it as a toggle swithch for each workflow.
I also need single workflow instant run at a time. In my case I am triggering work flow on item update. Also in the workflow i am updating same list to maintain workflow status, custom log and other fields as per my need but my workflow gets in infinite loop when I am updating current list item in the workflow.
Earlier we are using SharePoint designer/ Nintex workflow and it works fine for us.
Can you provide a simple action like set field value which will update the list item but not trigger workflow update event?
This is my POC to convert SharePoint designer/Nintex workfow to Microsoft flow. We need to convert thousants of workflow in future if POC gets success.
Appriciate your help to provide workaround for this senario.
Look out for new contribution recognition badges coming SOON!
Join us for the first ever Power Platform Online Conference!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!