HI @nikitapatel,

You could try creating a column called “Workflow 2 ran” or similar and when workflow 2 runs have it update this column to YES.  Then in your condition for workflow 2 you can add “Workflow 2 ran = no”.
This way workflow 2 can only run once.

However, in all cases, Workflow#1 will always run when the submit button is clicked.

With your suggestion, when the submit button is clicked the column would update to YES. If I set Workflow#2 settings to run when Workflow 2 ran = NO, it wouldn’t run Workflow#2 at all.

I need both workflows to run.

• Workflow#1 runs when the submit button is clicked.
• Workflow#2 runs when the item is modified and checks to see if a question was answered or not. If the question had a response entered then Workflow#2 should run.
• The issue is that once both workflows complete, Workflow#2 starts running again without any modifications being made to the form.

Hi @nikitapatel 

I believe that this is what @SimonMuntz is trying to say.

• Workflow #1 - Upon clicking SUBMIT, a new Item is created, and this triggers WF #1
• Workflow#2 - runs when the item is updated or modified
  AND when a yes/no question is not empty 
  AND “Workflow 2 ran = no”

You need to exercise caution when triggering a Workflow to run when the item is updated or modified.
That is the key reason to add additional conditions.
Every update to the item will trigger Workflow #2.
When Workflow #2 updates any column(s), this itself will trigger another Workflow #2 

• The issue is that once both workflows complete, Workflow#2 starts running again without any modifications being made to the form.

Are you using multiple updates to the item when Workflow  #2 runs? How Many?

Here are my button settings:

Here are the WF settings for Workflow#2(Conference Contracts Workflow):

ConfOnsite? Is the question that asks if the conference is on site. For the workflow to trigger, it has to be either Yes or No. The WF settings do not allow me to configure it to “not empty”, so this is the approach I had to take with the criteria. FYI: Conference Details Flag is the column name I created for the approach that was suggested above.

Here is Workflow#2

This workflow basically checks to see how questions were answered on the form. Depending on the responses, different set of approvals get triggered. I didn’t use “update item” actions anywhere. I have used the Set action. Everything works fine… this workflow however keeps restarting. Idk if it is because of Workflow#1 running at the same time and setting fields.

Add a Log to History as the first item in Workflow #2
Display the values of both ConfOnsite? and ConferenceDetailsFlag.

This helps to show the values of those columns when the Workflow #2 is triggered.

What are the values of both ConfOnsite? and ConferenceDetailsFlag when the Workflow #2 first runs?
What are the values of both ConfOnsite? and ConferenceDetailsFlag when the Workflow #2 runs again?

Hi,

Workflow#2 ran multiple times. See below:

1. ConfOnsite? Was answered Yes on the form. 
2. Detailed view of each of the three workflow instances was the same

   

    

What I see happening is this:

1. WF#1 has 4 approval tasks
2. For every approval task that gets approved, WF#2 starts and ends in 3-4 completed instances
3. Each approval task sets the response within the SharePoint list, could this be why WF#2 keep triggering?

Hi @nikitapatel 

This condition will not work.  You cannot mix AND and OR conditions as there is no way to add parentheses to group the statements.

For instance, this can be

(this OR this) AND this 

or it can be:

this OR (this AND this)
 

The settings originally only had ConfOnsite? = Yes OR ConfOnSite? = No…. So I can change it back to that. But it still triggers Worfklow#2 multiple times.

What else can I try to stop Workflow#2 from running over and over again? It seems to retrigger the workflow every time I hit approve for a flexi task for Workflow#1.